Best SQL Client

Posted 8 months 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.

Laracasts Mascot

Hi, Have We Met Yet?

Did you know that, in addition to the forum, Laracasts includes well over 1000 lessons on modern web development? All for the price of one lunch out per month.

Sign Me Up

Channels

Reply to

Use Markdown with GitHub-flavored code blocks.