Currently I use Sequel Pro and find it works for what I need. I primarily use it for inspecting my DB, make a quick edit in content when developing, and exporting my data from staging to production on launch. One thing I have noticed is sometimes my tables will have a JSON column. When you export a SQL file with just the content and then try and import the data when there was a JSON column you get an error:
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
This is forcing me to look at other options until they fix it. Right now I saw:
-Querious 2
-TablePlus
Anyone have any preference or suggestions for OS X? Honestly Sequel Pro is perfect besides that so something simple and native would be great.
I had this problem dealing with exports made by Sequel Pro. I unchecked the Output BLOB fields as hex option and the problem went away. Visually inspecting the export showed legible JSON instead of binary.
Source: https://stackoverflow.com/a/49544119
I am using it now for a few weeks and as far as I can see it works good. I only use it to browse, query, export and import. So pretty limited use. Only thing that I discovered today is that clicking on foreign keys is not bringing me to the correct record. It is opening the correct table but it is not applying the automatic filter on id. See also this ticket https://github.com/sequelpro/sequelpro/issues/2792
I like Sequel Pro but looking at the release cycle and all the open issues for many months it is not looking good. There are even a lot of pull requests fixing those issues that are not being merged: https://github.com/sequelpro/sequelpro/issues/3051
BTW, if you use PHPStorm: it also includes a database client where you can query. Big plus is that if you have your database linked in PHPStorm it can use autocomplete in raw queries.
@m-rk I use VS Code (after years of switching around its the only one I have liked enough to stay with). After messing around with a few clients, Querious 2 has looked promising but only been messing around for a day.
