Company
Date Published
Author
Jessica Wachtel
Word count
810
Language
English
Hacker News points
None

Summary

InfluxDB 3.0 has improved storage compression and performance, supports unlimited cardinality data, and delivers fast SQL queries compared to previous versions, thanks to its new database engine built on top of Apache Arrow. The Flight SQL interface provides high-performance SQL access to InfluxDB databases using the Arrow Flight RPC framework, allowing for faster data access and lower latencies without converting data to Arrow format. To use InfluxDB with Flight SQL, a data source name (DSN) must be configured, which can be done using the usql CLI or programmatically, and requires installing Go 1.17+ and the FlightSQL Library. The DSN configuration includes parameters such as token, timeout, and TLS settings, which can be customized to fit specific connection requirements. Real-world examples of connecting to InfluxDB locally and in the cloud are provided, and the driver is available on the Apache Arrow GitHub page for more information.