News for hackers. Stuff that matters.
Re:Postgres WASM by nicoburns on Monday October 03, 2022 @06:22PM (#33074507)
Installing pg is hardly annoying. `brew install postgres`. Done.
Re:Postgres WASM by TheRealPomax on Monday October 03, 2022 @06:35PM (#33074611)
Replied to the wrong person, but I'll take that bait anyway: "Ahahahaha, no".

That only works if you live a blissful "all my hosted pg instances use the exact same version" world, which I've never seen be the case for even moderately sized projects. You're going to need multiple Postgres installs if you're going to need pg_dump/pg_restore, which you probably are.

(How you solve that problem, of course, is not a one-size-fits-all, and Docker may be the answer... or it may not)

Re:Postgres WASM by nicoburns on Monday October 03, 2022 @07:11PM (#33074900)
Doesn’t pg_dump/pg_restore work across versions? (So long as the CLI tools are the latest version). I guess version compatibility could be an issue in theory, but I’m yet to hit into a backwards compatibility issue with Postgres.
Re:Postgres WASM by TheRealPomax on Monday October 03, 2022 @09:58PM (#33075997)
I wish. You'd think it'd just be able to check the db to see if there's any schema or procedure incompatibility, but it doesn't. Instead, it goes "Remote uses version X and you're using version Y, sort that out" and then it exits.
Re:Postgres WASM by nicoburns on Tuesday October 04, 2022 @06:24AM (#33078437)
Oh, that's incredibly unhelpful!