We currently use Neon as general purpose persistence for our product and company, and it's been great.
We're looking to host around 1B rows of time series data. We want allow our users to query between two dates and aggregate (Average value in the last 5 years as an example). We want to store the data at the finest granularity we can. There's a bunch of options for this (Clickhouse, Influx etc.) - vanilla Postgres isn't well suited. We ideally want to have one DB and hosting provider to manage.
Keep sensor, on-chain, and customer data fresh with TimescaleDB. 100% PostgreSQL-compatible time-series database with 95% compression, real-time analytics, and automatic partitioning at scale.