We've just released software version 5.0.6 and it comes with plenty of additional features and functionality, a full refactoring of PostgreSQL wire support, and multiple fixes to improve the stability of the system. Here's a roundup of recent changes that have just landed.
The complete refactoring of PostgreSQL wire protocol, including binary support, means improved usability for many popular libraries and languages.
Users can now use prepared statements (bind variables), which allows for better efficiency on repeated queries:
Support for the RFC339Nano timestamp format enables the use of alerting via Grafana. This helps identify unintended changes, minimize disruptions and stay on top of your system or infrastructure:
There's now a function built-in that provides the current server version number and commit hash for troubleshooting. It can be run with the following command:
This language feature adds more flexibility in cases where
queries are run and tables already exist:
Full examples using this statement in multiple languages can be found on the Insert data page.
Even better than good error reporting is error prevention! This fix enhances the the resilience of the system by preventing data loss in QuestDB instances if disk space unexpectedly runs out.
These have been our top picks from the 5.0.6 release which cover what our users have been most excited about recently but there are a lot more changes that have been omitted here. For a full list of the fixes, features and improvements that we've added, take a look on the GitHub Release.
If you like our new additions or have a burning suggestion for upcoming changes, we'd love to know your thoughts! Feel free to share your feedback in our Slack Community and don't forget to drop us a star on GitHub.