Show HN: Centia.io – Open PostgreSQL/PostGIS back end for developers

24 pointsposted 3 months ago
by mhoegh
(centia.io)

6 Comments

nullfield

3 months ago

So my very first question, after opening your page, is “what does this get me, if anything, to offset the very large decrease in efficiency vs. the native wireline protocol, given that it’s implemented pretty much everywhere?”

whizzter

3 months ago

Feels like they're trying to make something alike PostgREST (and sell it as a service), ie being able to skip backend coding and this manages brokering and permissions for frontends that does most of the job anyhow.

mhoegh

3 months ago

That’s right. You can compare it to Pocketbase, but with PG as storage. It is open source and it’s easy to self host

mhoegh

3 months ago

It enables you to use Postgres without the wireline protocol

lab14

3 months ago

Does it work with pgbouncer?

mhoegh

3 months ago

Yes, it works with pgBouncer, which is recommended in production. Centia.io will connect to pg/pgBouncer with different PG user creds, so pgBouncer must be configured for that. You can also use whatever managed PG service you like.