Support for more client apps

[dluc]

Please allow to extend the list of client apps, or at least add more options

Some apps that would be great supporting:

• pgAdmin 4 - https://www.pgadmin.org
• Beekeeper Studio - https://www.beekeeperstudio.io
• DBeaver - https://dbeaver.io

many more here https://wiki.postgresql.org/wiki/PostgreSQL_Clients

Thanks!

[jakob]

It would be nice if that popup could autodetect installed PostgreSQL clients.

I don't want to be responsible for choosing which clients are supported, and which are not.

Do all those clients support the postgresql: url scheme?

[dluc]

I don't think they do support the scheme. What about making the list configurable?

[tbussmann]

I once looked into the possibilities to support pgAdmin4. However, without support for an url handler nor command line switches, it seems impossible to tell the client application what database to connect to.

[jakob]

I checked the docs, and I found a pretty nice API introduced in macOS 12 that makes it easy to find apps that can handle a specific URL scheme:

import Cocoa
let appUrls = NSWorkspace.shared.urlsForApplications(toOpen: URL(string: "postgresql://localhost")!)

If PostgreSQL clients all supported the postgresql: URL scheme, that would then make it very easy to automatically add all installed apps to the popup menu.

(We would of course need to add some logic to deal with multiple copies of the same app)

Right now, Postico is the only app on my computer that supports postgresql: URLs. I think TablePlus may support the URL scheme (they are usually quick to add features to their app when I add them to Postico :), but I don't have it installed to check. DBeaver doesn't support it. I think I suggested adding an URL handler to one of the DBeaver devs a few years ago when I met them at a conference, but I never followed up on it.

Maybe we can suggest to app developers that they should add URL handlers to their apps. Without URL handlers and with no Apple Script support, it's going to be very hard to launch other apps...