rqlite
is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine.
Release 8.30.0 is out now and adds support for Automatic Optimize.
Automatic OPTIMIZE
The new Automatic Optimize feature automates the PRAGMA optimize command for the underlying SQLite database. Why does optimize matter? It matters because optimize instructs SQLite to gather statistics on its underlying tables, making the Query Planner more efficient at running queries.
And since SQLite recommends periodic optimization, rqlite now automates this process once per day by default. This interval can be adjusted to your needs, or disabled entirely. Check out the rqlite documentation for more details.
Next Steps
As always, feedback and contributions from the community are welcome. You can get started quickly with rqlite, and check out the official documentation or join the conversation in the rqlite Slack channel.