@ee11a5dff40c19a555f41fe42b48f00e618c91225622ae37b6c2bb67b76c4e49 It outperformed Postgres querying large time-based datasets. Eg "trending hashtags in the past year".

Key-value stores will give you more performance of course, but you are essentially building a custom datastore.

SQLite is great for being an all-in-one embedded solution, and I'm gonna love it until I witness the performance being bad firsthand.