Maybe fallback to Sequel Pro

[aubreypwd]

See https://community.localwp.com/t/sequel-pro-add-on/27380/2 for context.

The idea here is that if you don't have TablePlus installed, but you do have Sequel Pro installed (and I can just switch out the App that is launched to Sequel Pro and it works the same way) maybe a secret functionality of the addon could fallback to Sequel Pro (Nightly) if you have it installed.

• It would have to connect the same way: e.g. I fire up Sequel Pro and it uses /tmp/mysql.sock to connect by default (if it doesn't do this, I likely won't commit to this)
• It would have to be an easy fallback to code in (if it's too hard, I don't use Sequel Pro, so I don't want to commit both time and maintenance to it)

But, if it can be done easily, I'm happy to try.

[aubreypwd]

Noteable Information: https://community.localwp.com/t/add-back-sequel-pro-support/27272/13

Honestly, I tried. I actually created an issue about the sandboxing socket issue a little over a year ago (Sequel-Ace/Sequel-Ace#108 3). Unfortunately, it doesn’t look like there’s a good path forward at this point. @afragen, if you have any ideas, I’d be happy to look into it.

[afragen]

Thanks for looking into this. Sequel PRO nightly does work using the socket.

[aubreypwd]

Sequel PRO nightly does work using the socket.

How this addon works is it symlinks /tmp/mysql.sock to the mysql.sock file in Local for the site, it then uses macOS open to open a mysql:// protocol URL to /tmp/mysql.sock which should connect to the Local site.

What needs to happen here is I need to be able to do the same thing but

1. SequelPro needs to become the default for the mysql:// protocol
2. When I run the mysql:// command with open Sequel Pro needs to connect to it and load the DB

If it will operate that way it's easy for SequelPro to be the fallback, since it is just the App that responds to the mysql:// call and all I have to do is

1. Replace the "Open TablePlus" with "Open Sequel Pro"
2. Allow the button to show if you have Sequel Pro installed

I am wondering if macOS has an easy way to detect who owns the mysql:// protocol, because if I can just detect what App is going to respond to open mysql:// then I can easily detect which app to

1. Show in the button like #1 above if it's Sequel Pro

Hope that helps how I'm going to approach this. Again, if I have to do anything extra beyond this it might not be worth it to me time-wise. But if it's as easy as ⬆️ then I think it's a worthy effort.

[afragen]

Here's what I found. I hope it helps.

https://sequelpro.com/docs/url-scheme

Looks like they use a different URL scheme. I don't know if that's easier or harder.

[afragen]

Perhaps just looking at something like

if TablesPlus is present {}
if Sequel Pro is present {}

[chrismccoy]

Sequel PRO nightly does work using the socket.

How this addon works is it symlinks /tmp/mysql.sock to the mysql.sock file in Local for the site, it then uses macOS open to open a mysql:// protocol URL to /tmp/mysql.sock which should connect to the Local site.

What needs to happen here is I need to be able to do the same thing but

1. SequelPro needs to become the default for the mysql:// protocol
2. When I run the mysql:// command with open Sequel Pro needs to connect to it and load the DB

If it will operate that way it's easy for SequelPro to be the fallback, since it is just the App that responds to the mysql:// call and all I have to do is

1. Replace the "Open TablePlus" with "Open Sequel Pro"
2. Allow the button to show if you have Sequel Pro installed

I am wondering if macOS has an easy way to detect who owns the mysql:// protocol, because if I can just detect what App is going to respond to open mysql:// then I can easily detect which app to

1. Show in the button like #1 above if it's Sequel Pro

Hope that helps how I'm going to approach this. Again, if I have to do anything extra beyond this it might not be worth it to me time-wise. But if it's as easy as ⬆️ then I think it's a worthy effort.

the sql app itself has to support using mysql uri's, as tableplus allows you to give a database uri structure.

I use navicat, which doesnt allow those structures when adding a database connection