From results over the past 24h: 1K databases, ingestion of new 5K to 10K rows per day per db (200B to 500B per row), sync’d every day (if possible, every hour), The sqlite3.db file grows about ~500KB (gzipped) or ~2.7MB per day.
We’d only want to retain 30d to 90d historical data per db.
Queries are on-demand and not predictable ahead of time (we don’t have anything yet to compare or profile against), but fair to assume reads (table scans) will be heavier than writes; but expect most databases to go without having to serve any read requests, too.
For us, we’d be super happy if the entire setup costs 1cent to 5cents per db per month.