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.
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.
2. Deploy the WAR on your java runtime container.
For tc Server simply copy it into the “webapps” directory of the server.
3. Start tc Server.
4. Access the user interface in your browser
To Learn More About Pivotal SQLFire:
- Read about effective design patterns in NewSQL
- See how SQLFire’s sibling product, GemFire, can be used to run Spring apps 60x faster
- Read over 60 similar articles on SQLFire at the vFabric Blog
- Read over 50 similar articles on GemFire at the vFabric Blog
- Access the product overview, features, downloads, and documentation
About the Author