Welcome! We're proud to present the following reference information about StreamSQL.

Developers like you can use the language to create applications that process and query real-time streaming data and stored data. Please reference the whitepaper, "Characteristics of a Good Language for Stream Processing" (PDF), to learn why streaming SQL is the optimal approach. As you read the topics below, you can draw upon your existing knowledge of SQL and discover how StreamSQL extends it, addressing the needs of high-volume, real-time applications. This includes solutions for financial services, telecommunications/networking, e-Business, RFID/sensor networks, and other industries.

The older "store first, index next, then query" data model cannot meet the performance requirements of real-time applications. With StreamSQL, now you can apply your processing logic to the inbound data records while they are "in flight," with the results available in milliseconds. StreamSQL enables you to create these real-time applications by working in the context of data streams, windows, and tables.

StreamSQL Reference Documentation

• Syntax Conventions and Grammar
• Data Definition Language:
  • CREATE INPUT STREAM Statement
  • CREATE OUTPUT STREAM Statement
  • CREATE STREAM Statement
  • CREATE TABLE Statement
  • CREATE INDEX Statement
  • CREATE WINDOW Statement
  • CREATE LOCKSET Statement
  • CREATE METRONOME Statement
• Data Manipulation Language:
  • DELETE Statement
  • INSERT Statement
  • INSERT/UPDATE Statement
  • REPLACE Statement
  • TRUNCATE Statement
  • UPDATE Statement
  • BSORT Statement
  • GATHER Statement
  • HEARTBEAT Statement
  • LOCK/UNLOCK Statement
  • MERGE Statement
  • SELECT Statement
  • Tuple Join
  • UNION Statement
  • VJOIN Statement

For details about using the StreamBase implementation of StreamSQL in real-time applications, see the StreamBase Developer Zone. On that site, you can also download a StreamBase evaluation kit ("Developer Edition"), read the full documentation, and access other resources. The kit includes StreamSQL demos and sample apps.