The Arcology Garden

SQLite is not a toy database - Anton Zhiyanov



I use sqlite in Arcology and I think actually it's a pretty neat database if you can live with the tradeoffs. This page lays out some of the calculations and query types which are supported in sqlite these days. A lot of them I didn't know about, including things like JSON partial indices which I have been a huge booster of PostgreSQL for.