Using SQLite in production
Hello SQLite Enthusiasts,
Welcome to this edition of the SQLite newsletter. Whether you're here to enhance your database knowledge or explore the latest developments in the SQLite ecosystem, we have a variety of insights and resources for you this week.
Sorry, this is a week late. There were technical issues, but we got it out on a Thursday!
Please remember to submit your database and SQLite-related links to us — blog posts, videos, GitHub repos, etc.
Quote of the day:
If we're trying to make things easy on you, we shouldn't casually make you a Redis database admin in the process.
— Michael Buckbee
Highlights
- Rearchitecting for SQLite - Wafris migrated part of their stack from Redis to SQLite. They acknowledge it was not a drop-in replacement. This is a great example of using the right tool for the job for The Right™ reasons. — Michael Buckbee
- SQLite on Rails performance - An overview of optimizing the performance of Rails with SQLite. They are working hard to make SQLite ready out of the box for Rails 8. They did the math! — Stephen Margheim
- Turn on mmap support for SQLite connections - Thoroughly explains the mmap support built into SQLite. With multiple clients accessing your database, mmap can offer significant performance boosts by using a bit more memory. — Oldmoe
- SQLite is not a toy database - This write-up provides an overview of SQLite's features with easy-to-understand examples. A great primer to share with friends, family, and coworkers to introduce them to SQLite’s niceties. — Anton Zhiyanov
Code
- Litestack - A Ruby gem that adds support for SQLite in Rails for full stack — jobs, DB, cache, async, and search.
- qustar - A library for building SQL queries in JavaScript.
- sqlfluff - A library that validates different SQL dialects.
The Lighter Side
- mmap warmer - If you decide to use mmap, this code can help warm up the mmap cache.
- Backup strategies for SQLite in production.
Remember to submit your SQLite news to us. Have a great week!