electric-pglite

It absolutely can be embedded. The bigger enabler is replacing the process-per-connection model with a thread-per-connection model. Projects like pglite[0] had to give up concurrency because of it. We also support compiling to wasm so you can embed it in the browser too, which is what powers pgrust.com [0] https://github.com/electric-sql/pglite [1] https://pgrust.com/

Which one? https://github.com/Ladybug-Memory/pgembed or https://github.com/faokunega/pg-embed ? Both will either download or ship the postgres binary with your app, and run it in a separate process. Pglite is different, it's actually a library (they have stripped some parts of the postgres source code) and it could in principle be ported to be used as a native library (meaning, you link to it and run as a single program) There's even a draft PR to do this, but it became stale https://github.com/electric-sql/pglite/pull/842 Right now what exists is, grabbing the pglite wasm and running it on native code on wasi https://github.com/f0rr0/pglite-oxide

I knew I remember your name working with something of sqlite and golang https://github.com/ncruces/go-sqlite3 Man I really enjoy golang and cross portability and wazero + sqlite could still be cross portable which is super fascinating What are your thoughts on https://github.com/electric-sql/pglite (postgres in wasm)? Also what were the goal behind a pure golang solution via wazero + wasm sqlite as you had made? Was it cross platform support, if so, what are your thoughts on zig, I have seen a project use zig + golang to create cross platform C language support but I think that adding zig into the picture complicates the build process so there are tradeoffs and I am interested to hear your opinions about it!

I see you guys are working on supporting the postgis extension. This would be HUGE!!! The gis community would be all over this. If anyone wants to help out who has compiled the postgis extension and is familiar with WASM. You can help out here. https://github.com/electric-sql/pglite/pull/807

I'd love to to use PGLite in a non-JavaScript runtime. For example, embed PGLite into my Go CLI with a WASM runtime and use PGLite as a replacement for SQLite. https://github.com/electric-sql/pglite/issues/89 makes it sound like there's "third-party" bindings for Rust. Is there any interest in "official" PGLite bindings to other languages?

Yes! I (experimentally) compiled and packaged it for react-native. Postgres on iOS and Android https://github.com/electric-sql/pglite/pull/774

"PSA: SQLite WAL checksums fail silently and may lose data" so that's probably not how to sync sqlite; https://news.ycombinator.com/item?id=44672902 electric-sql/electric: https://github.com/electric-sql/electric : > Specifically, Electric is a read-path sync engine for Postgres. It syncs data out of Postgres into ... anything you like. The core sync protocol is based on a low-level HTTP API. This integrates with CDNs for highly-scalable data delivery. electric-sql/pglite: https://github.com/electric-sql/pglite : > Embeddable Postgres with real-time, reactive bindings. "Using Postgres for Everything" https://news.ycombinator.com/item?id=40420474

You got my hopes up, but it's WASM for now, not something I could add into a golang [1] or python app and have running like sqlite. OK, still hoping...! [1]https://github.com/electric-sql/pglite/issues/89

See also https://github.com/electric-sql/pglite (REPL at https://pglite.dev/repl/) (Previously discussed 7 months ago: https://news.ycombinator.com/item?id=39477457)

SQLite is written in C. And the most commonly used SQLite driver interfaces to that compiled C code directly via JNI. The PostgreSQL client driver is written in pure Java on the other hand. Has nothing to do with language used. You can wrap anything in a jar (it’s just a zip file). You could certainly embed PostgreSQL in a jar and you can do something similar to this https://github.com/electric-sql/pglite I don’t think there’s that much interest, but it is doable. EDIT: https://github.com/zonkyio/embedded-postgres