Ask HN: How do you handle time-series metrics at scale without a large bill?
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.
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.