VSHN.timer #138: Litestream your SQLite

Welcome to another VSHN.timer! Every Monday, 5 links related to Kubernetes, OpenShift, CI / CD, and DevOps; all stuff coming out of our own chat system, making us think, laugh, or simply work better.

This week we’re going to talk about how SQLite is adapting itself to the new world of Cloud Native Computing.

1. Imagine a cloud native database that is small, fast, reliable, and globally distributed; a great option to store your whole life in it. Yes, we’re talking about SQLite with Litestream, the new revolution in the world of SQLite, created by Ben Johnson (now at Fly.io, itself touted as the heir to Heroku).

https://fly.io/blog/all-in-on-sqlite-litestream/

2. Who’s using Litestream? Tailscale is. They moved to SQLite from raw JSON files and etcd, and instead of using MySQL or PostgreSQL, they decided that SQLite was the next step. (And no, in spite of the publication date, it’s not an April Fools‘ joke.) And you know who else is using SQLite in the cloud? Cloudflare.

https://tailscale.com/blog/database-for-2022/

3. If you run databases in AWS, you should attend the AWS Database Modernization event next week, with talks about Aurora, RDS, DocumentDB, and DynamoDB. That’s a lot of cloud database options up there.

https://pages.awscloud.com/emea-database-modernisation-week-q2-2022.html

4. Do you like PostgreSQL? Do you like containers? Well, rejoice, because now you can run containers in PostgreSQL. And yes, when we first heard about it we were as puzzled as you are right now.

https://www.crunchydata.com/blog/announcing-postgres-container-apps-easy-deploy-postgres-apps

5. The VSHN.timer tool of the week is termdbms, a text user interface (TUI) tool for viewing and editing databases, written in pure Go. For the moment it only works with SQLite, but support for MySQL and PostgreSQL is in the roadmap.

https://github.com/mathaou/termdbms

Are you using Litestream in production? What is your opinion about microservices using SQLite as a database? Would you like to share some SQLite tips and tricks with the community? Get in touch with us, and see you next week for another edition of VSHN.timer.

PS: would you like to receive VSHN.timer every Monday in your inbox? Sign up for our weekly VSHN.timer newsletter.

PS²: do you prefer reading VSHN.timer in your favorite RSS reader? Subscribe to this feed.

PS³: check out our previous VSHN.timer editions about databases and storage: #111 and #115.