Interesting take on building software that lasts. I'm not sure I'm fully aligned with this but its good food for thought.

This is indeed an area which could be better handled in SQLite. It needs to be carefully checked when introduced in a project.

It shows unexpected results in its measurements. It also highlights the importance of proper settings for your database system.

Interesting explanation of a research paper exploring the possibility of a faster SQLite by focusing on async I/O.

If you wonder how the protocol is designed and how the actual implementation works, this is a nice introduction. Clearly it's helped by the size of that program which is fairly small.

Interesting, there's now an official tool to replicate sqlite databases. It's still early days, we'll see which features it'll get.

Another nice list of defaults for SQLite. Some of them I didn't have on my radar.

Wish to use SQLite in production? You better have a good backup strategy. This article explains the main available options.

Looks like a neat extension which can come in handy.

Interesting experiment showing that BLOBs in a database can be a good alternative to individual files on a filesystem in some contexts.

Some improvements coming in SQLite transactions. Here are some early tests.

Where are the limitations of using SQLite in production for web applications? Here is a good list.

Little and to the point reference on safer SQLite use. I should check if some of this would apply or is used by Akonadi as well.

With some tuning SQLite can go a long way, even for server type workloads. There are still a few caveats but in some case this can reduce complexity and cost quite a bit.

Some more deserved praises for Sqlite. It's finding its way in more and more places.

An interesting but sometimes forgotten possibility for extending SQLite. Keep in mind this can lead to bad coupling between the software and the DB though which could carry interesting challenges around upgrades for instance.

Interesting bug in SQLite. In particular look for the conclusion regarding tests and coverage. It's something I often have to remind people of.

The tone of the article isn't exactly to my liking, sounds "too good to be true" at times ignoring important details driving the choices (despite some warnings early on). Still, depending on the amount of data stored in your database, SQLite looks increasingly viable on the server, replication even coming down the road.

Starts a bit like a (somewhat deserved) love letter to SQLite. But that also does a good job pointing out some of its caveats and when to not use it.

SQLite keeps being a fun database full of little nuggets. Plenty of cases when it could fly but when somehow we use the bigger players instead.