Company
Date Published
Author
Anais Dotis-Georgiou
Word count
1924
Language
English
Hacker News points
None

Summary

InfluxDB Cloud now supports SQL querying for time series data, leveraging the Apache Arrow DataFusion project's query optimizations. This allows users to leverage PostgreSQL-compatible SQL implementation, providing compatibility with various databases and enabling more efficient querying of large datasets. The new feature offers advantages such as improved performance, increased flexibility, and better support for complex queries. Users can migrate existing SQL queries from other PostgreSQL-compatible databases, take advantage of the extremely performant columnar database, query all data without specifying a time range, and use SQL to write basic Flux queries using equivalent SQL queries. The new Script Editor in InfluxDB Cloud enables users to save, open, create, and visualize scripts, making it easier to work with SQL queries. By utilizing the iox.from() function, users can return output that looks similar to SQL queries, allowing for more flexibility in querying data. The inclusion of SQL as a query language excites developers, offering an alternative to Flux and providing improved performance and support for complex queries.