search

electric-sql / pglite

Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno
https://electric-sql.com
Apache License 2.0
4.76k stars 81 forks source link

extension: Foreign data wrappers #10

Open mustafaakin opened 4 months ago

mustafaakin commented 4 months ago

I know it might be early to ask but it'd be great to have support for it and use pglite as a wrapper for running SQL over other resources securely

kiwicopple commented 3 months ago

if this goes ahead we're be open to adding Wrappers as a single interface for many other data stores:

https://github.com/supabase/wrappers

That said, I think this feature request should be delayed as long as possible while the current storage mechanisms reach maturity (like https://github.com/electric-sql/pglite/issues/9)

mustafaakin commented 3 months ago

Yeah it'd be great. I was thinking of something like Steampipe but a permissive & compatible license.

samwillis commented 3 months ago

@kiwicopple Supabase wrapper support would be awesome, but as you said priority is stability, parameterize queries, storage, then extensions. Support for opening the same db from multiple tabs is also essential (probably by routing all operations to a single worker with a leader electrician, should make an issue to this...)