Company
Date Published
Author
Victoria Xia, Leah Thomas, Wade Waldron
Word count
1224
Language
English
Hacker News points
None

Summary

ksqlDB 0.17 marks a significant release with the introduction of several new features aimed at enhancing database schema management and query capabilities. The update includes a migration tool that allows for version control of ksqlDB schemas, facilitating integration with CI/CD pipelines by enabling automatic application of new migration files upon changes in version control systems like Git. The release also introduces a first-class timestamp data type, accompanied by functions for manipulating time data, and the ability to create inline lambda functions to transform, filter, and reduce data using SQL. Enhanced pull query support now allows for more flexible operations, such as table scans, expanding beyond key equality comparisons to include a variety of operations in the WHERE clause. These improvements enable more sophisticated querying on derived tables, although support for pull queries on tables from table-table joins is still pending. Users running ksqlDB on Confluent will automatically receive the upgrade to version 0.17, and those new to the platform are encouraged to explore ksqlDB through Confluent or its standalone distribution.