I've used SQLite for single-user analytics in the past and it's fine up to a point. It's slightly more SQL-literate than MySQL - it supports CTEs but not window

I've used SQLite for single-user analytics in the past and it's fine up to a point. It's slightly more SQL-literate than MySQL - it supports CTEs but not window functions - and it has an okay GIS extension. I've also been pleasantly surprised by performance in some cases. However, I was recently pointed at MonetDB: https://www.monetdb.org/Home https://www.monetdb.org/Home Monet's an open source column store, and I think it's worth evaluating by anyone doing offline analytics or research-driven work.