Founder and SVP of Product Edan Kabatchnik describes s-Server, the engine at the heart of Guavus SQLstream.
Why is this kind of performance important? Because it means that you can deploy your applications on fewer servers —which keeps your ongoing opex costs to a minimum.
what does s-Server do?
s-Server is the SQLstream runtime component that manages and executes streaming applications developed in StreamLab. s-Server can be managed through the s-Studio console. Processing data at over 1M events/second per CPU core on benchmarks and at over 1M events/second per server on real-world applications, s-Server is the most powerful and scalable data processing platform available, and includes a rich suite of agents and adapters for machine data mediation and enterprise system/storage platform integration.
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.
SQLstream s-Server is the first true standards-based streaming SQL platform for managing live data feeds on, off, and around the cloud in real time.
why SQL
Our latest benchmark achieved a record Kafka ingest throughput for complex Protobuf data structures that scaled up to 1.8M recs/second on a single server.
learn more
SQLstream Guavus requires 10X less hardware for equivalent performance and only 1PM development effort versus 10PM for alternative proprietary solutions.
READY TO GIVE IT A TRY?
Guavus SQLstream is free to download and use up to 1GB/day (after which it throttles).
Guavus SQLstream’s mission is to make real-time stream analytics easy to use and own with a one-stop-shop solution that performs the best, has the widest footprint, never turns off, and can be developed and customized by data scientists and engineers alike.
©2021 Guavus, Inc. All Rights Reserved. SQLstream® is a registered trademark of Guavus, Inc.