Postgres UNIX socket support

[Svenum]

Important

Wait for a maintainer to approve this issue before opening a PR. We'll signal approval with a comment or label. Feature PRs without an approved issue will be closed.

✨ Feature Request

Is your feature request related to a problem? Please describe.
I have a postges server running on my container host and want connect to it via unix socket auth. So I added the volume /var/run/postgresql:/var/run/postgresql:z and the env POSTGRES_URL: postgresql://kanbn@%2Fvar%2Frun%2Fpostgresql/kanbn but this does not work as drizzle dont support it via URL.

Describe the solution you'd like
The solution is to use seperate values to create the db connection:

const dbCredentials = {
  host: '/run/postgresql', // Unix socket path
  port: 5432,
  user: 'your_user',
  database: 'your_db'
};

Would you like to work on this feature?

• Yes, I'd like to help implement this feature
• No, I'm just suggesting the feature