PGlite – Postgres in WASM

Fitting PostgreSQL into a 12MB binary with a simple API is amazing!<p>I was so excited to try it out it that I just released an in-browser PostgreSQL playground on top of PGlite.<p>It&#x27;s also open source and easy to integrate:<p><a href="https:&#x2F;&#x2F;codapi.org&#x2F;postgres-pglite" rel="nofollow">https:&#x2F;&#x2F;codapi.org&#x2F;postgres-pglite</a>

This is awesome. Are extensions like PostGIS supported? I wish react-native natively supported WASM. It would be cool to run this client-side instead of sqlite.

This is super cool. Postgres is slowly overlapping on every part of the data stack, even SQLite isn&#x27;t safe!

Related (but different):<p><i>Postgres WASM</i> - <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=33067962">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=33067962</a> - Oct 2022 (185 comments)

Interesting that it could be done at all - but having a hard time coming up with any real world use cases for this. Are there any?

How is this different than the one done by CrunchyData here <a href="https:&#x2F;&#x2F;www.crunchydata.com&#x2F;blog&#x2F;crazy-idea-to-postgres-in-the-web-browser" rel="nofollow">https:&#x2F;&#x2F;www.crunchydata.com&#x2F;blog&#x2F;crazy-idea-to-postgres-in-t...</a>

This seems possible due to the separation of Postgres storage and compute work done by Neon?

This is amazing! I’ve been wanting this to exist for years for use in unit tests. This made my day (and maybe upcoming work week)