StreamLab 2.0 is a browser-based interface for parsing, analyzing, and displaying data streams.You can now read and write to CSV, XML, and JSON files from StreamLab. StreamLab 2.0 also lets you read and write to external data sources, including Oracle, PostgreSQL, MySQL, Teradata, and Microsoft SQL Server.StreamLab 2.0 also lets you create sinks. Sinks can serve as data sources for other StreamLab projects. StreamLab 2.0 also adds a number of new analytics, including pivot, time sort , window, partition window, and GroupRank.
For a tutorial on using new StreamLab features, please see http://thyrd.org/sqlstream/tutorials.html. This tutorial walks you through the process of installing s-Server, installing StreamLab, and creating a PostgreSQL table. It then walks you through the process of using StreamLab to analyze a log file (in this case, data on the location and speeds of regional buses), create visualizations based on this analysis, and then store this data in a PostgreSQL database.
The purpose of this document is to describe how to use StreamLab to parse, analyze, and display s-Server data graphically. Topics include:
•Using the StreamLab interface
•Integrating StreamLab with s-Server
•Using built-in StreamLab projects
•Creating custom StreamLab projects
•Creating StreamLab sources, from s-Server streams, tables, and views, or from local log files.
•Creating views with StreamLab guides.
This document is aimed at developers and end users.