LO VS pglite

Absolutely. The memory management is manual like in C, but with addition of defers it is actually quite good to work with.

Here is the source for the allocator: https://github.com/glebbash/LO/blob/81f96bb09e3a0b1455b32497...

It also links to where I learned how to build the "proper" allocator from scratch.

While I was developing lole-lisp I happened to create a tool to generate C FFI bindings for Deno.

One alternative is to use pglite [1] which is Postgres compiled to WASM. It can act as a sqlite replacement during development, then when you are ready to move to a server model your SQL is already in Postgres format.

[1]: https://pglite.dev/

For a very similar scenario I'm currently looking to use PGlite: https://pglite.dev/ which is a 3MB WASM build of Postgres which also includes pgvector.

Does something like PGlite work for your use case? https://pglite.dev/

In case you missed it, database.build is an in-browser Postgres sandbox with AI assistance. You can spin up an unlimited number of Postgres databases and interact with them using natural language (via LLM). This is possible thanks to PGlite - a WASM build of Postgres that can run directly in the browser.

Would be nice to add support for PGlite [0] to have the same “spin up in the browser” experience with Postgres.

Let me know if we can help with it!

[0] https://pglite.dev

See also https://github.com/electric-sql/pglite.

(Previously discussed 7 months ago: https://news.ycombinator.com/item?id=39477457)

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.

ElectricSQL | https://electric-sql.com | PGlite Engineer | Remote in Europe or eastern US | €80-100k + Equity

We're looking for a generalist web and systems engineer to join the core PGlite team, working mainly in Typescript, Rust and C++.

PGlite (https://pglite.dev) is a lightweight, embeddable WASM Postgres. It's a fast growing open source project, with 8k GitHub stars and 100k+ weekly downloads. It opens up new possibilities for local-first apps and systems built on an embedded, real-time, reactive Postgres, such as https://postgres.new

Technically, you need strong Typescript and systems programming experience, ideally in C++ and Rust. It would be great if (but is not essential that) you're familiar with some aspects of database internals, filesystems and WASM.

We're a highly technical team working remote-first on a 4-day week. More information at https://electric-sql.com/about/jobs/pglite-engineer

I'm wondering how would it perform if we can compile https://pglite.dev/ as a native library and use it as an in-process Postgres... I know Node folks already use it as a Wasm module, so it shouldn’t be too tricky?

You can now run Wasm builds of PostgreSQL that will get you everything you like about SQLite.

https://github.com/electric-sql/pglite