Handle connection strings and failover?

[kevinelliott]

Does the postgres library for dart support connection strings?
Does it support multi-hosts connection strings or multi-host in general?
Can it handle reconnection to a read-write node if failover occurs (such as w/ Citus pg-auto-failover, see: https://www.citusdata.com/blog/2021/02/12/reconnecting-your-app-after-a-postgres-failover/)?

The foundational Postgres library (libpq) does support these things, and it would be good to know if this library can be augmented to support the features.

[isoos]

Does the postgres library for dart support connection strings?

The related package postgres_pool does support some:
https://pub.dev/documentation/postgres_pool/latest/postgres_pool/PgEndpoint/PgEndpoint.parse.html

(they will be eventually merged)

Does it support multi-hosts connection strings or multi-host in general?

I've implemented this in another related library: cockroachdb_pool, which was very useful for a project. I guess one could use it and implement a similar thing for asymmetrical postgres/citus layouts too:
https://pub.dev/packages/cockroachdb_pool

The foundational Postgres library (libpq) does support these things, and it would be good to know if this library can be augmented to support the features.

I have plans for extending the features of the package, but in the past year or so I was really busy and couldn't find the time for it. If you are up for it, I'm happy to review and take PRs...

[kevinelliott]

I see, got it, so it looks like it doesn't yet support passing the attributes, or defining multiple hosts.

I am looking at migrating to CockroachDB later, but until then I have a multi-node failover cluster and need to define the hostname of the primary active node by hand. In production this is super painful when the primary goes down.