All posts by Philip O'Toole

Building a highly-available search engine using SQLite

Did you know that SQLite contains a full text search engine? The SQLite FTS4 and FTS5 Extensions allow you to perform full-text searches on documents loaded into SQLite.

And since rqlite uses SQLite as its database engine, rqlite makes it really easy to deploy a highly-available search engine – and one you can interact with using SQL and HTTP.

Continue reading Building a highly-available search engine using SQLite

Latest updates to rqlite 8.23

rqlite is a lightweight, open-source, distributed relational database written in Go, utilizing SQLite as its storage engine.

rqlite has been updated to versions 8.23.1 through 8.23.3, bringing a series of targeted improvements to refine its internal operations and enhance overall stability. These updates focus on advancing the database’s core functionality through code refactoring and important bug fixes.

Continue reading Latest updates to rqlite 8.23

Prepping to Speak at Tech Conferences: From AWS re:Invent to GopherCon

Getting ready to speak at a technical conference can be as nerve-wracking as it is exciting, especially if it’s your first time.

Having had the opportunity to present at notable events like AWS re:Invent, Monitorama, DevOps Days, and GopherCon, I’ve learned a thing or two about preparing for the big stage.

Continue reading Prepping to Speak at Tech Conferences: From AWS re:Invent to GopherCon

rqlite Versions 8.20.0 to 8.22.2: Enhancements in Stability, Performance, and Data Handling

rqlite, the lightweight, open-source, distributed relational database written in Go and built on SQLite, has seen a series of significant updates enhancing its robustness, efficiency, and feature set.

With releases from 8.20.0 to 8.22.2, rqlite continues to evolve, driven by community input and a commitment to providing a high-quality, distributed database solution.

Continue reading rqlite Versions 8.20.0 to 8.22.2: Enhancements in Stability, Performance, and Data Handling

rqlite 8.17.0 & 8.18.0: Scheduled VACUUMs and Enhanced JSON Support

rqlite is a lightweight, easy-to-use, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine.

rqlite has recently seen two significant upgrades with the release of versions 8.17.0 and 8.18.0. These releases introduce new features that enhance both performance and functionality.

Continue reading rqlite 8.17.0 & 8.18.0: Scheduled VACUUMs and Enhanced JSON Support