1 year ago

Best SQL Client

Posted 1 year ago by packy

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.

Please sign in or create an account to participate in this conversation.