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]

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

See:

• https://github.com/zonkyio/embedded-postgres-binaries
• https://github.com/opentable/otj-pg-embedded

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

[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