Hey y'all, Just posted this question to stackoverflow regarding modeling a one-to-zero-or-one relationship. Any suggestions (here or there) are welcome. Hopefully the answers can serve as a reference for folks needing to setup this sort…

So, the necessary backstory is I have a big internal application I happen to support which is built on MSSQL, and it's at best infeasible to migrate it to PgSQL. I really would love to move away from the hodgepodge it is today, but rewr…

I've seen previously that it isn't possible (from about 4-5 months ago), but I'm looking to see if it's on the roadmap. I've been doing quite a bit of devcontainer development these days, and like to keep my db in a sepa…

I'm trying to model a many-to-many relationship with containers containing items which can belong to multiple containers with the help of a container_items table defined like so: CREATE TABLE container_items ( container_id UUID NOT …

What is the scope of database transactions? fetch-command ( my guess ), request, session? Is there any way of controling or will there be? …

I'm just starting to play with this and so far I like what I see, but is there a way to connect to an existing db? I'm not 100% through all the docs yet, so I may have missed it. …