postgres.js does not correctly parse URLs containing unix sockets

[honnip]

Related:

• gcp cloud sql socket connection porsager/postgres#484
• Connecting to GCP Cloud SQL and the path Config Option porsager/postgres#950

The library does not correctly parse URLs containing unix sockets.

I confirmed that porsager/postgres#484 (comment) solves it. (https://github.com/honnip/hollo/commits/db/unix-socket/)

[ThisIsMissEm]

@dahlia is there a reason we're using postgres instead of pg?

[dahlia]

@ThisIsMissEm It's because @fedify/postgres depends on postgres.js.

[ThisIsMissEm]

Could @fedify/postgres depend on pg instead?

[dahlia]

It can switch over to pg if pg supports NOTIFY/LISTEN. However, I think it will require a whole rewrite. 🤔

[ThisIsMissEm]

Ah, ick, okay. I can't recall if pg does explicitly support those but I think so?

[dahlia]

Maybe it would be better to create a separate package called @fedify/pg. 🤔