New Open Source Download: Browser-based Schema Management for Pivotal SQLFire

July 25, 2013 Pas Apicella

With a familiar, browser based user interface, SQLFire*Web allows data fabric administrators to browse schema objects, create tables, view partitions, and more. It can make big data grid management of Pivotal SQLFire much easier and provides a convenient option for those who might want to connect remotely. You can now access the open source bits for SQLFire*Web from our GitHub repository or get a WAR file here.

This post provides a quick background on SQLFire*Web, digs into the capabilities of this project, and shows you how to get it set up and running.


The Quick Background on Pivotal SQLFire

Recently, our team gave a viewpoint on how big data might be the #1 key to US economic growth and how Hadoop’s buzz has migrated toward fast data. These point out home-base for Pivotal SQLFire—it’s a data fabric built for scaling big, fast data problems, and it blows away traditional RDBMS in scale tests. SQLFire is used in mobile applications, to replace traditional databases, and mainframe modernization. With it’s in-memory, distributed architecture, developers can organize data in groups, partitions, and with redundancy, and SQLFire allows joined data to be colocated for increased performance. There are many more SQLFire capabilities to dive deeper into—for example, automatically batching changes asynchronously across a WAN and running efficiently on virtualized infrastructure.

About SQLFire*Web

In many cases, the most convenient way to access a data store is via a web-based tool, with no local installs or configurations to worry about. While command lines are often a favorite and quite fast, sometimes you might also want to browse a user interface to see drill into different objects, taken a quick peek at data sets, or run a quick SQL query. This is why SQLFire*Web was created. Here are all the things you can do with it:

  • Multiple users can connect at once via a browser
  • Browse schema objects + SQLFire schema objects
  • View the partitioning strategies of tables
  • Create tables and indexes via a wizard
  • View data distribution across members
  • View memory usage for tables
  • Manipulate multiple schema objects at once
  • Run any SQL query—DML or DDL
  • Load and execute SQL files
  • Stop and start gateway senders
  • Stop and start async event listeners
  • Add your own dynamic SQL reports to extend query capabilities


How to Get Started with SQLFire*Web

To install SQLFire*Web, download the WAR file from above and install into into your java runtime container and access as follows. Note, this project has been tested with Apache Tomcat version 6 and 7 as well as Pivotal tc Server. The instructions below are for tc Server. Please check with your run time container on how to deploy WAR files to get SQLFire*Web installed if you are not using tc Server.

1. Create a new tc Server instance for the application.

Screen Shot 2013-07-24 at 2.55.21 PM

2. Deploy the WAR on your java runtime container.

For tc Server simply copy it into the “webapps” directory of the server.

Screen Shot 2013-07-24 at 2.59.28 PM

3. Start tc Server.

Screen Shot 2013-07-24 at 3.01.42 PM

4. Access the user interface in your browser

Screen Shot 2013-07-24 at 3.04.43 PM

To Learn More About Pivotal SQLFire:

About the Author

Pas Apicella

Pas is a Senior Platform Architect at Pivotal Cloud Foundry

GemFire XD’s New Open Source Download: Browser-based Schema Management
GemFire XD’s New Open Source Download: Browser-based Schema Management

A new open source, browser-based administration and development tool is now freely available for Pivotal Ge...

Keep Your App Platform in a Happy State: An Operator's Guide to Capacity Management on Pivotal Cloud Foundry
Keep Your App Platform in a Happy State: An Operator's Guide to Capacity Management on Pivotal Cloud Foundry

Platform operators are tasked with making sure Pivotal Cloud Foundry is in an updated, healthy state at all...