SQLstream provides the power to create streaming Kafka & Kinesis applications with continuous SQL queries to discover, analyze and act on data in real time.
s-Studio is a stream inspection, application development, and administration console for the s-Server platform. s-Studio enables dynamic updates to live applications, adding new queries as needed or changing existing queries or views. s-Studio is built as a plug-in to the standards-compliant Eclipse framework.
SQLstream s-Studio is SQLstream’s Integrated Development Environment. It provides access to all the objects defined in an instance of the SQLstream s-Server, including streams, tables, views, adapters, and pumps. Using s-Studio, you can create, delete, view, or edit SQL object definitions (such as streams, foreign tables, and views) as well as inspect streaming data in real time. It lets you develop, test, run, and administer streaming SQL applications.
The Catalog tab displays s-Server objects. Most objects–streams, tables, functions, views, and pumps–appear under schemas.
Whenever SQLstream s-Studio is connected to the server, ad-hoc SQL queries can be issued against the server, with immediately visible results.
Data is visible in any stream, table, or view from within SQLstream s-Studio. For a regular table or relational view, this is the same as selecting all the data from the table.
For a stream, the inspection window shows all rows as they pass through the stream. The inspection window – like any stream query – only sees rows arriving after the start of the query. Here is an example from the Edamame Demo.
Often, when testing an application, you need to provide data for a stream to test downstream objects, particularly aggregations and JOINs. Normally, to handle this you have to either run a script or use an external tool to execute INSERT SQL statements.
SQLstream s-Studio provides an easy way to inject proper test data into a stream or foreign table.
READY TO GIVE IT A TRY?
SQLstream Blaze is free to download and use up to 1GB/day (after which it throttles).