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.

Interesting, I didn't know SQLite could have R-Tree indices. This can come in handy for three dimensions or geospatial problems.