Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgres WASM

supabase.com

Post reply on HN
Print view View original

151–160 of 190 posts

Re: Postgres WASM

#151

Post by collinmanderson »

stuaxo wrote: post #99
pistoriusp wrote: post #4

Peter from Snaplet here. A month ago I saw the CrunchyData post and wanted to play around with the code that made it happen, it wasn't OSS so I asked for help: > If anyone out there wants to work on an open source version of this full-time please reach out to me. [0] Paul reached out and we started working on it almost immediately. Check out the repo here: https://github.com/snaplet/postgres-wasm We have a blog post…

Nice, I wonder if anyone has got Django with postgres working in this environment?

PyScript ( https://pyscript.net ) recently came out, though I don't know if Django works with it yet.

Re: Postgres WASM

#152

Post by encryptluks2 »

lioeters wrote: post #122
Kye wrote: post #115

There have been a lot of new WASM things popping up on HN. Was there some major new change the enabled all this?

I've also noticed a number of fun WASM projects this year. I think the underlying WASM features that enable all this have been around for a while, so the breakthroughs are probably coming from the community and ecosystem growing incrementally and synergistically, building on each other's work and collaborating.

I believe they are coming from people wanting to push people to get confortable with running binary blobs in their browsers so they can suck up all that juicy personal information leaked by browsers.

Re: Postgres WASM

#153

Post by mathiasrw »

Existenceblinks wrote: post #150

The most important piece of jigsaw left is writable local file access api. Yet, no energy put to do it! Security shouldn't be a stopper but a thing to be solved, probably only allow installed pwa app write with little cute settings widget like on mobile to see which apps have accessed to local machine's storage, showing path, usage size, etc. It's like conspiracy to leave Chrome do it alone. Strange!

WASI will blow your mind

Re: Postgres WASM

#154

Post by 101008 »

pistoriusp wrote: post #112
101008 wrote: post #65

Now I only need Django WASM and I can distribute standalone applications :')

Interesting, you're the second person to ask about this! Is there something in Django world that makes standalone application appealing?

I think it is just personal: I feel very proficient with Django and as developer I love it. It probably would be possible to do the same with any other framework such as Flask or Laravel (in PHP)

Re: Postgres WASM

#155

Post by Existenceblinks »

mathiasrw wrote: post #153
Existenceblinks wrote: post #150

The most important piece of jigsaw left is writable local file access api. Yet, no energy put to do it! Security shouldn't be a stopper but a thing to be solved, probably only allow installed pwa app write with little cute settings widget like on mobile to see which apps have accessed to local machine's storage, showing path, usage size, etc. It's like conspiracy to leave Chrome do it alone. Strange!

WASI will blow your mind

Progress is quite slow. The "Component Model" proposal is very early days. There's .wit and .world going on that will blow your mind!

Re: Postgres WASM

#156

Post by Too »

TheRealPomax wrote: post #80
alex_duf wrote: post #29

Earlier quoted context omitted.

Correct me if I'm wrong, but given your profile (I assume someone in the tech world), nothing stopping you from doing all of the above with a local pg. If installing is annoying you could run it in docker.

But now instead of the annoyance of installing pg, you have the annoyance of installing docker. and then writing a dockerfile. And then bootstrapping docker. etc. etc. =)

Who, working with these things regularly, does not have docker installed?

There is already an official image available so you don’t need to write dockerfile yourself. Having an instance up and running is literally just a docker run command away.

Re: Postgres WASM

#159

Post by mrtksn »

r3trohack3r wrote: post #109
mrtksn wrote: post #37

Earlier quoted context omitted.

IMHO the prime use case for all these WASM stuff is going to be platform independence. Web browsers are not that interesting because for regular use they already have ballooning resource use issues and making web apps even more resource intensive is not exactly inspiring, HOWEVER the web technologies are the only true multi-platform solution we have and it makes sense to use it to make everything with it and everythi…

Isn't that Deno and Node.js?

No not really, these are all about JavaScript. Wasm makes everything portable like JavaScript.

Re: Postgres WASM

#160

Post by BrandiATMuhkuh »

This is a really exciting development. It's super awesome to see again what the supabase team does. Thanks for your great work.

Here is my use case: We use firestore + PG. PG has a copy of all firestore data. And PG is used for search, aggregation, etc. (Everything firestore can't do). Sadly, the developer flow breaks during local development. Because each developer would need to have a local PG server running. My dream is to simply add PG via NPM and use the wasm version during local development. That way, everything simply works via NPM/node

I think an in-memory node only version of PG might even be simpler to achieve than the already developed approach. As it doesn't need the websocket workaround.

Post reply on HN