This is very cool. Having to always set up a server is one major downside of Postgres, with cumbersome updates being the second. This solves the first and has potential to help with the second.

Is there a way to compile this as a native library? I imagine some of the work should be reusable.

▲

evelant 8 hours ago | parent | next [-]

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

▲

samwillis 8 hours ago | parent | next [-]

This is such awesome work! We *are* going to get this integrated with the ongoing work for "libpglite".

▲

patwolf 8 hours ago | parent | prev [-]

Glad to see it working in react native. It always surprises me that RN doesn't natively support wasm. I've had to avoid other wasm-based libraries, like loro, for that reason.

	▲	evelant 7 hours ago \| parent [-]
		Yeah, it's unfortunate but it's not really react-native/facebook's fault. Apple doesn't allow any sort of JIT to run on iOS outside of their builtin webkit js engine. That means that AFAIK there's no way to run wasm at reasonable speed on iOS, which means react-native can't really support wasm.

▲

tdrz 8 hours ago | parent | prev | next [-]

Native library is on our radar!

▲

worthless-trash 9 hours ago | parent | prev [-]

Took the words out of my mouth, i can think of many use cases for this.

Imagine being able to go from 'embedded' to 'networked' without having to change any SQL or behavior, so cool.