What software do you use for your day-to-day SQL work?

(Postgres, MySQL, etc.)

I’m talking primarily about browsing through data, navigating the relations, editing. (E.g. find the client by email, get their orders, find the last one, edit it – this kind of stuff)

I’ve been using https://www.adminer.org/ with a couple of custom dirty plugins for years. It looks shitty, but it’s functional. Yet, I fail to find something that’s more ergonomic for working with data, not for DB administration (I change the schema via migrations in code anyway).

author Kirill Rogovoy

Reply

14 Answers

Justin Allen are experts in coding

writen by WBE Office

Try ArcType

writen by Dobroslav Radosavljevič

Cool, this is new to me, thanks!

But..

writen by Kirill Rogovoy

https://www.beekeeperstudio.io/|https://www.beekeeperstudio.io/ is awesome. Built by an indie dev too 😎

writen by Stephen N

Kirill Rogovoy Oh well, I forgot Try typing ArcType download to google. They still have site with download, but it’s hidden (because they were recently acquired, so they have some plans)

writen by Dobroslav Radosavljevič

Beekeeper is also good :muscle::skin-tone-3:

writen by Dobroslav Radosavljevič

Dbeaver

writen by Bartolomeu Rodrigues

I use or have used: MYSQL WorkBench Microsoft SQL Server Management Studio PHPMyAdmin Dbeaver

None of them are that great!

writen by Justin Allen

Thanks!

Stephen N do you use the paid one?

writen by Kirill Rogovoy

You could also use intellij

writen by Benedikt

I’ve tried Beekeeper today.

Here are some of the missing things for me:

Could not edit JSON columns (the UI gives you a tiny input, but I can have a 1kb+ JSON there)
I could jump through foreign-key columns (e.g user_id -> user row with that id), but only in one direction – couldn’t see other DB records that have references to the one I’m looking at
I can’t host it on the server to send links to my partner (or the whole team if I had one)
I could not extend it in any way All of those things I can do with a crappy-looking Adminer.

On the other hand, I really liked the clean UI, saved queries, tab pane (although with Adminer I just use browser tabs), the schema explorer, Cmd+P pane.

writen by Kirill Rogovoy

> You could also use intellij I used DataGrid a few years ago and it was very basic in terms of data manipulation. Couldn’t even jump through foreign keys. Is it any different now?

writen by Kirill Rogovoy

On this note, what are the main criteria for you folks? And what are the features all of these SQL browsers miss for you?

Not looking to build anything atm, but I have a lot of pain on this front and I’m yet to find a product that’s really good (ready to pay $100 per year for it).

writen by Kirill Rogovoy

Yeah, IntelliJ is pretty basic. Most of the time I use direct queries anyway so I’m not a 100% sure if it can follow foreign keys

writen by Benedikt

Do you want to ask a question?

Related Questions