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!