Using SQLstream s-Studio

<< Click to Display Table of Contents >>

Navigation:  Installing SQLstream Blaze >

Using SQLstream s-Studio

Previous pageReturn to chapter overviewNext page

SQLstream s-Studio is a graphical interface for viewing and manipulating s-Server data. 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, tables, and views) as well as inspect streaming data in real time.

SQLstream s-Studio is SQLstream's Integrated Development Environment. 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. You can inspect these objects by clicking them. You can create new objects by right-clicking the object's folder as well as work with the SQL for each object.

The Activities tab displays information on managing s-Server.

Overview of the s-Studio Development Environment

Development Pane Contents after First SQLstream Server Connection

The left side of the window shows two tabs, Catalog and Activity. Once connected, the Development tab lists all s-Server objects. The Activity tab shows currently running sessions, statements, locks, stream graphs, stream operators, and the Global Error Stream.

At the bottom of the main window, to the right of the Catalog Navigator, is a utility area. Its default windows are for displaying information about properties, problems, console actions, and errors. New windows, such as data inspectors for looking at streaming data, will open in this lower area.

Finally, the empty area above the utility area, between the Development and Welcome panes, is the Editor area. When you open object editors, they will appear in tabbed panes within this space.

You can rearrange and resize all panes and tabs by clicking and dragging. You can restore closed windows using Window / Show View.  

Browsing Object Definitions

On install, the Catalog Navigator contains a single, default server instance called First SQLstream s-Server. It refers to the default installation of the SQLstream s-Server on the local host. You will find this same instance at the top of both the Development and Management tabs, with different information under it for each.

The installed First SQLstream s-Server includes samples of schemas, data sources, and data sinks, as shown in the screenshots above. (Clicking the triangle next to the First SQLstream s-Server label, or double-clicking the folder, shows the lower levels of the tree.)

Within the sample schema are the following objects:

Foreign Streams

Foreign Tables




User Defined Functions (and Procedures)


The sample instance also contains:

Data Sources and Sinks. These are server objects that let s-Server connect to and write to data sources.

Plugins - These are the standard set of foreign data wrappers in s-Server:

Each repository object has a right-click menu of appropriate actions, including Open (for most object types), Inspect (for streams), and Query (for tables, views and streams).

You can see a list of the components of an object, such as the ASKS stream, by clicking the arrowhead next to it.

To Open it completely and see the properties of those components, double-click its line in the Development pane, such as ASKS in this case.

The following two images illustrate the two methods. The second image shows the definitions (name, type, length, nullable, default) for each of the stream's columns, in a new window placed in the center of the SQLstream s-Studio frame:

Stream Opened Inside Development Pane

Stream Opened Inside Development Pane

Note that, below the definition pane, the Definition tab is selected for this view. ASKS can also be viewed as SQL by clicking the SQL tab, or as Java by clicking its tab, which provides (for relational objects) some sample Java code for accessing the stream, table, or view.