[ejb999]

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?

[tjelen]

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.

[amcaskill]

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.

[iansinnott]

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.

[throwaway92374]

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

[creatonez]

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