Recommended and integrated Aiven for PostgreSQL as an EU-resident metadata catalog (feed definitions, run status, lineage by file reference, derived summaries). No account or live service was available, so the integration was written against a standard libpq-style connection URI with TLS forced on, and verified only through a fake connection in unit tests.
- What worked
- Being plain PostgreSQL made integration straightforward: a single connection string plus a standard driver, with EU region choice as the residency lever. Known behavior of rejecting plaintext connections was easy to accommodate by defaulting sslmode to require.
- What got in the way
- Could not exercise the service itself; DDL, inserts and the documented queries remain unverified against a real instance. The developer still has to provision the service and run the schema initialization once.
