Using s-Studio

SQLstream s-Studio is SQLstream's Integrated Development Environment. It lets you develop, test, run, and administer streaming SQL applications.

Sections

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

s-Studio Interface Overview
s-Studio Interface Overview

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
  • Streams
  • Tables
  • Views
  • User Defined Functions (and Procedures)
  • Pumps

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.

Setting Preferences in s-Studio

The Windows / Preferences menu offers some customization opportunities. Most are associated with the Eclipse toolkit itself. The following two are specific to SQLstream s-Studio:

  • Inspect View: how many rows to retain in the inspection window
  • SQL Format: preferences for the SQL Formatter

s-Studio Preferences
s-Studio Preferences