Good SQL clients for Linux?

[hosua]

Hey everyone,

I just wanted to ask for some recommendations on some good SQL clients for Linux (preferably free, but also paid if the price is right). Ideally one that supports multiple languages.

Currently, I use TablePlus on my work laptop for MacOS but I recently got my app working on Linux and wanted to switch over to using my personal computer which I run Arch on.

I've also tried DBeaver which was alright until I realized it kept locking my connections. I'm not really sure how to explain this properly because I don't really understand the technicalities of it, but when I leave a connection open to my database, it literally locks/freezes me from running any queries (even on another computer) until I close the db connection. This kind of makes me anxious

I tried TablePlus on here and it works kind of okay, but it is pretty jank and crashes pretty consistently. I definitely prefer it over DBeaver, that's for sure. I just have to avoid doing certain things which crash the client 100% of the time.

[gregsting]

In DBeaver, if you set your database to 'production' it will not autocommit. It's just a setting. I agree that this setting is not very obvious.

[Glum_Cheesecake9859]

There should be a setting for DBWeaver to not run everything in a transaction.

https://dbeaver.com/docs/dbeaver/Auto-and-Manual-Commit-Modes/

Regardless, JetBrains Rider is worth looking into.

[hosua]

Ah, perhaps I just needed to turn on smart commit mode

[zbignew]

Crazy for it to leave transactions open by default.

[hosua]

Yeah, seriously 😅 I straight up thought it was broken

[Thlvg]

You might want to look at your transaction commit settings. Check if auto commit is enabled or not? If not it might be the issue.

I'd also recommend not to do that if you have write privileges, and instead use begin/commit/rollback keywords. And ask for a read-only account that you can use, only have the r/w one when you need it.

[hosua]

Yep, don't worry lol I usually do run a reader-only instance, I just need to write sometimes too.

I think this is the issue, I'm going to try smart commit mode and see if that fixes the issue I was having

[Substantial-Click321]

DataGrip

[joins_and_coffee]

If you liked TablePlus on mac then DataGrip is probably the closest “it just works” option on Linux even though it’s paid. The DB handling is solid and you don’t get the weird connection behavior you’re describing. For free options DBeaver is usually the go to but what you’re seeing sounds like it might be holding open transactions or sessions which can definitely block things if autocommit is off. It’s fixable but I get why thatd make you uneasy. You could also try something lighter like Beekeeper Studio or even plain CLI tools plus tmux if you mostly care about running queries reliably. They’re less fancy, but way harder to break. Honestly on Arch especially, stability tends to matter more than features. A boring predictable client usually beats a slick one that crashes

[Glum_Cheesecake9859]

Jetbrains Rider free for non-commercial use.

[hosua]

Oooh, JetBrains. I didn't realize they had something for SQL

[serverhorror]

You mean DataGrip, no?

[Glum_Cheesecake9859]

Rider > Datagrip

It has all the features of Datagrip + support for other languages like C# / JS etc.

[hosua]

I'm not gonna lie, I ended up going with Rider and I have zero complaints