PGlite – Postgres in WASM • Hacker News Board

PGlite – Postgres in WASM

#1

Post by samuba » Fri, Feb 23, 2024, 6:00 AM UTC

PGlite – Postgres in WASM
github.com

Re: PGlite – Postgres in WASM

#2

Post by erichocean » Fri, Feb 23, 2024, 1:39 PM UTC

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

Re: PGlite – Postgres in WASM

#3

Post by andrenotgiant » Fri, Feb 23, 2024, 1:51 PM UTC

How is this different than the one done by CrunchyData here https://www.crunchydata.com/blog/crazy-idea-to-postgres-in-t...

Re: PGlite – Postgres in WASM

#4

Post by thruflo » Fri, Feb 23, 2024, 1:57 PM UTC

andrenotgiant wrote: post #3

How is this different than the one done by CrunchyData here https://www.crunchydata.com/blog/crazy-idea-to-postgres-in-t...

The previous PG WASM projects from Crunchy and Snaplet have run Postgres in a VM and required a large 32MB download.

This is pure WASM, no VM, 3.7MB download. Plus it has persistent storage.

Re: PGlite – Postgres in WASM

#5

Post by thruflo » Fri, Feb 23, 2024, 1:58 PM UTC

erichocean wrote: post #2

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

Yup, this is based on work by Neon. Also the Neon model allows you to sync in a database on demand, whilst scaling to zero when you’re not using it.

Re: PGlite – Postgres in WASM

#6

Post by nalgeon » Fri, Feb 23, 2024, 2:58 PM UTC

Fitting PostgreSQL into a 12MB binary with a simple API is amazing!

I was so excited to try it out it that I just released an in-browser PostgreSQL playground on top of PGlite.

It's also open source and easy to integrate:

https://codapi.org/postgres-pglite

Re: PGlite – Postgres in WASM

#7

Post by vbalegas » Fri, Feb 23, 2024, 3:09 PM UTC

nalgeon wrote: post #6

Fitting PostgreSQL into a 12MB binary with a simple API is amazing! I was so excited to try it out it that I just released an in-browser PostgreSQL playground on top of PGlite. It's also open source and easy to integrate: https://codapi.org/postgres-pglite

Awesome! Will check it out

Re: PGlite – Postgres in WASM

#8

Post by ejb999 » Fri, Feb 23, 2024, 3:27 PM UTC

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?

Re: PGlite – Postgres in WASM

#9

Post by throwaway92374 » Fri, Feb 23, 2024, 3:37 PM UTC

ejb999 wrote: post #8

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?

It can persist data to indexedDB, so web applications can use it if they want a more flexible alternative

Re: PGlite – Postgres in WASM

#10

Post by tjelen » Fri, Feb 23, 2024, 4:07 PM UTC

ejb999 wrote: post #8

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?

Code testing is a big one for me. I'm currently using in-memory sqlite for tests and I'm often running into differences between sqlite and postgres (default values, JSON handling, etc). This could allow me to use the real thing without running a full Docker instance.