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.
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.
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.
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
Postgres WASM - https://news.ycombinator.com/item?id=33067962 - Oct 2022 (185 comments)
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.
- 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.
This is pure WASM, no VM, 3.7MB download. Plus it has persistent storage.
Deleted Comment