3 ms·
I can really appreciate the fun and technical challenge of running postgres in a browser. However the use cases are extremely far fetched. 1. training website:
by alex_duf 4y ago
I can really appreciate the fun and technical challenge of running postgres in a browser. However the use cases are extremely far fetched.
1. training website: you can use a hosted PG, or use a sqlite wasm
2. same as above
3. if the use case is being offline, then the web browser isn't very relevant. If the use case is to avoid a load on the server, the sqlite in wasm will be just fine.
It's only if you go into triggers and such that it might start being relevant, but then I'd start seriously questioning what on earth are you trying to do :D
All of that to say: well done to the team that has done it, really fun and interesting work, I just can't see the use from where I stand.
- kiwicopple 4y ago> training website: you can use a hosted PG, or use a sqlite wasm from a supabase POV (which is in the business of hosting Postgres databases), we will definitely be using this for training/tutorials. We have several thousand visitors to our docs every day, and hosting a database for every one of them is expensive. We can now provide a fresh database for every user, and they can "save/restore" it with the click of a button is huge. > use case is being offline The offline use-case is definitely far-fetched in the current iteration. but that's the beauty of technology - something that seems impossible today can be mainstream in a decade.
- Bedon292 4y agoIt is awesome to be able to do things isolated client side and not have to deal with permissions and resources for something like a training website. Which is all stuff you would have to deal with for a hosted version. And there are plenty of reasons why you may want to use PG over sqlite. Especially if you are trying to mimic a production environment which is PG. Personally I only ever use PG, and never have a reason to use sqlite.