Embed Postgres with OpenGB CLI to remove Docker dependency

[NathanFlurry]

See:

• https://github.com/faokunega/pg-embed
• https://github.com/zonkyio/embedded-postgres-binaries
• https://github.com/opentable/otj-pg-embedded
• https://github.com/electric-sql/pglite

Easiest path is likely to use the Rust library to create a Deno plugin.

Before embarking on this, ensure that

• This solution is portable
• Supports the same extensions that's available on Neon
• Still supports a Docker fallback

[linear[bot]]

OGBE-69 Embed Postgres with OpenGB CLI to remove Docker dependency

See: * [https://github.com/zonkyio/embedded-postgres-binaries](https://github.com/zonkyio/embedded-postgres-binaries) * [https://github.com/opentable/otj-pg-embedded](https://github.com/opentable/otj-pg-embedded) Easiest path is likely to use the [Rust library](https://github.com/faokunega/pg-embed) to create a Deno plugin. Before embarking on this, ensure that * This solution is portable * Supports the same extensions that's available on Neon * Still supports a Docker fallback

[AngelOnFira]

fwiw there are some bugs that can come from pg-embed in terms of making sure postgres is downloaded properly and running, and it's less maintained. Not too hard to work get around though, it's a pretty light wrapper I think.

Another path to examine when the time comes is postgres inside of wasm, through a project like this: https://github.com/electric-sql/pglite