ksqlDB
ksqlDB is a streaming database system that uses SQL-like statements to process Apache Kafka event streams continuously.
Kafka Streams in Action, Second Edition
A ksqlDB server is the server-side service that executes ksqlDB statements and manages continuously running stream-processing applications.
- How it is used
- Builds continuously running Kafka stream-processing applications through SQL queries.
- How deep it goes
- Explains streams, tables, query types, serialization, aggregations, and joins, including co-partitioning requirements.
- Examples
- Demonstrates purchase-reward joins, member lookup enrichment, foreign-key joins, and nested JSON queries.
- What you can do after
- Builds real-time Kafka applications with SQL streams, tables, persistent queries, and joins.
Read how Kafka Streams in Action, Second Edition explains ksqlDB →
Kafka for Architects
ksqlDB is a Confluent streaming database system that defines and executes continuous event-processing queries using a SQL-like language over Kafka data.
- How it is used
- Reduces application-development and operational overhead by deploying declarative stream-processing logic without a full-fledged application.
- How deep it goes
- Explains continuous queries, stream definitions, filtering, aggregation, windows, and Kafka Streams execution, but not low-level implementation.
- Examples
- Uses order filtering, an Orders stream definition, country counts, and one-hour tumbling-window aggregation.
- What you can do after
- Apply via ksqlDB by defining, deploying, and continuously evaluating SQL-based filtering and aggregation queries.
Related concepts
- Kafka Streamsuses · Kafka Streams is a client library for building applications that continuously process data from and write data to Apache Kafka topics.
- SQLuses · SQL is a standardized declarative language for defining, querying, and manipulating data and structures in relational database systems.
- Apache Kafkauses · Apache Kafka is a distributed event-streaming platform for publishing, storing, processing, and consuming streams of records.
- KSQL queryuses · A KSQL query is a SQL-based query that continuously processes streams or tables backed by Kafka topics.
- schema registryuses · A schema registry is a service that stores, versions, and provides schemas for structured data, often validating compatibility between schema versions.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.