Postgres
Postgres is a relational database and the default choice for your system of record: durable, transactional, and queryable with SQL.
When to use it
Section titled “When to use it”- Your primary application data that must not be lost.
- Anything relational — joins, constraints, transactions.
- Workloads that need indexes, aggregations, and ad-hoc queries.
Connecting
Section titled “Connecting”When your instance is ready, copy the connection string from its detail page
and use it with any Postgres driver or ORM. It’s a standard postgres:// URL.
Pair Postgres with a Valkey cache for hot reads, and lean on OpenSearch when you need full-text or analytical search over the same data.