Learn Postgres at the Playground – Postgres compiled to WASM running in browser

Re:Learn Postgres at the Playground – Postgres compiled to W... by jjwiseman on Wednesday August 17, 2022 @01:41PM (#32499448)

Speaking of making Postgres easy to setup and use, here are instructions for setting up per-project Postgres ("So I worked out how to set up a Postgres database that’s almost as convenient as SQLite."): https://jamey.thesharps.us/2019/05/29/per-project-postgres/

[ Parent | on HN ]

Re:Learn Postgres at the Playground – Postgres compiled to W... by gen220 on Wednesday August 17, 2022 @01:57PM (#32499613)

I think most people who use postgres in their personal projects have a snippet like one that they copy from project to project, I know I do. Curious to see others' scripts!

Mine logs in as `postgres`, creates the database and extensions I normally use, then creates a user and grants the appropriate privileges to that application user for the relevant db/schemas. Incidentally, it's the same script I use for "prod" deployments on my homelab.

[ Parent | on HN ]

Re:Learn Postgres at the Playground – Postgres compiled to W... by ithrow on Wednesday August 17, 2022 @02:14PM (#32499783)

FYI, not all drivers support unix sockets, like the official Java one.

[ Parent | on HN ]