I want to build my own first party analytics for fun and profit and I'm trying to find a good timeseries database that has a sweet spot between costs, overhead, and scalability.

I've considered just standard PostgreSQL, SQLite on the edge (Cloudflare D1 / Turso), purpose built columnar databases (Clickhouse, DuckDB) and the ones managed by big cloud like Google BigQuery, Amazon Timestream, and Cloudflare Analytics Engine.

For those running event analytics on indie / small-team budgets: what has your actual production experience been? Trying to make an informed decision.