Live data from Hacker News

PGlite – Postgres in WASM

github.com

11–19 of 19 posts

Re: PGlite – Postgres in WASM

#11
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?

I think performance and cost are the big motivators here.

I work on a web framework for building data apps like reports and dashboards, and we use duckDB’s WASM runtime for interactions (e.g when a user changes a date range filter). It’s really fast, and you don’t spend snowflake credits.

Re: PGlite – Postgres in WASM

#12
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

That's neat, I wonder what the overhead is though.

Re: PGlite – Postgres in WASM

#16

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.

join us on the Extism discord https://extism.org/discord, we're working on some things that will enable this. would love to hear what you're thinking!

Re: PGlite – Postgres in WASM

#18
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?

No one using postgres in the cloud is going to use this as an alternative, but there are at least two use cases where this could be very useful:

- You want your app to be local first (snappy, great offline support, etc) but sync data to a server. This is the ElectricSQL use case.

- You want a serious data store in-browser. SQLite via wasm already fits this use case, but it's nice to have options.

Post reply on HN