Live data from Hacker News

Postgres WASM

supabase.com

181–190 of 190 posts

Re: Postgres WASM

#181

Can I have the opposite? I want to be able to run webassembly-based extensions in postgresql. I don't like writing C, and most postgresql languages offer too much (no sandboxing, need slow interpreters and shit). But a WASM based sandbox for creating custom functions for postgres in your favourite WASM-outputting language sounds very interesting

This exists, but with limitations: [0][1]

[0]https://medium.com/wasmer/announcing-the-first-postgres-exte...

[1]https://github.com/wasmerio/wasmer-postgres

Re: Postgres WASM

#183

Earlier quoted context omitted.

passing devices through to do libusb stuff with them (like OBD diagnostics on cars)

Oh, so it's not related to PostgreSQL. I'm super interested in new and different uses for WASM. This could open some new doors.

Could you tell me at a high level how you would implement in your mind/opinion passing USB devices through v86/WebUSB/libusb?

Re: Postgres WASM

#184

Earlier quoted context omitted.

This is cool, but is also somewhat saddening too. The dream is a real wasm native postgres; in fact to get all of postgresql's cool shared mem proccess stuff and make it something like shared array buffer! The dream is also that WASI interface and new-school OS interfaces like memfd_create are increasingly aligned. Instead of rationalization our interfaces, however, it's just emulation layer on top of emulation layer…

I think we'll see this - and it would be amazing to get someone to work towards this - once there is an amazingly compelling use case that resonates with the market, then I think there's room for optimization!

I am working on a few things that, if one squints, might be relevant.

Do ask if you want to know more, especially if you are interested in throwing some $$ that way! :)

Re: Postgres WASM

#185

Earlier quoted context omitted.

I don't understand what you're comparing Chromium to if you're saying it doesn't have features for business reasons, when the other browsers also don't have those features.

In almost every standards working group Google holds the most seats. It'd be naive to say that those in the groups are working only and only for the common good and don't pursue their employer's interests.

> In almost every standards working group Google holds the most seats

Can you substantiate this?

> It'd be naive to say that those in the groups are working only and only for the common good and don't pursue their employer's interests

This may be partly true without backing up what you were saying. You were saying something much stronger, which is that Google is deliberately holding back the internet. Now you're saying, "Well they aren't only working for the common good" which is just insinuation. Making the internet work better helps Google, which is why they do all sorts of things, from making Web browsers, to open sourcing codecs, to laying undersea cables. That doesn't imply anything negative.

Not to say there isn't anything negative. Just that your points don't seem to back that at all.

Re: Postgres WASM

#186

Earlier quoted context omitted.

In almost every standards working group Google holds the most seats. It'd be naive to say that those in the groups are working only and only for the common good and don't pursue their employer's interests.

> In almost every standards working group Google holds the most seats Can you substantiate this? > It'd be naive to say that those in the groups are working only and only for the common good and don't pursue their employer's interests This may be partly true without backing up what you were saying. You were saying something much stronger, which is that Google is deliberately holding back the internet. Now you're sayi…

> Can you substantiate this?

Since the topic is WASM here; here is the webassembly working group: https://www.w3.org/groups/wg/wasm/participants

15 Google, 7 Microsoft and rest are 1-2 seats max.

WebRTC https://www.w3.org/groups/wg/webrtc/participants

22 Google, 12 Microsoft, 7 Mozilla, rest are 1-2 seats max

Web Performance https://www.w3.org/groups/wg/webperf/participants

32 Google, 10 Meta

And the situation is similar in most groups: https://www.w3.org/groups/wg/

I agree that making the web work better is good for Google. But making the web good and advertiser friendly even at the cost of users and their privacy is better for them.

Re: Postgres WASM

#188

I was most impressed that you can exit out of psql and you have a Linux VM running in your browser that has some basic commands e.g. ping

It’s a busybox shell that does quite a bit. Plus you have pg_dump which you can use to shuttle data from an external database to the local database or vice-versa.

Re: Postgres WASM

#189

Earlier quoted context omitted.

I think we'll see this - and it would be amazing to get someone to work towards this - once there is an amazingly compelling use case that resonates with the market, then I think there's room for optimization!

I am working on a few things that, if one squints, might be relevant. Do ask if you want to know more, especially if you are interested in throwing some $$ that way! :)

Let's chat! Can you ping me on Discord? (peterp) https://app.snaplet.dev/chat/

Re: Postgres WASM

#190

Earlier quoted context omitted.

And those are very likely to have tcp sockets at some point in the future (or at least that is the hope!)

Funny thing is that Chrome used to have sockets. As an extension but they solidly worked. I wrote a socks proxy that ran in the browser. It worked really well.

I was reading about it, but I assumed it was just in Chromium? Did it actually make it into Chrome as well!
Post reply on HN