Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

HeidiSQL Available Also for Linux

heidisql.com

Post reply on HN
Print view View original

1–10 of 51 posts

Re: HeidiSQL Available Also for Linux

#2

Post by Daril »

HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird.

Since some days it is finally available in a native Linux version. The code has been ported from Delphi to FreePascal / Lazarus.

Re: HeidiSQL Available Also for Linux

#5

Post by kQq9oHeAz6wLLS »

moron4hire wrote: post #4

I'm curious if anyone here has any experience with DbBeaver and HeidiSQL and can make a comparison. I've been using DbBeaver for a while, but the interface is... strange. Will probably try Heidi tomorrow.

I've used both; DBeaver for personal stuff, Heidi at work. Heidi has a much more intuitive interface, IMHO

Re: HeidiSQL Available Also for Linux

#6

Post by mappu »

Heidi is the best, this is really wonderful. I had been using MeowSQL as an imitation client which was fine, but having the real HeidiSQL again is such a nice feeling.

The deb package here didn't run for me on Debian 12 nor under distrobox Ubuntu, i think the dependency list needs a little attention, but that can be easily solved.

Re: HeidiSQL Available Also for Linux

#7

Post by cookiengineer »

moron4hire wrote: post #4

I'm curious if anyone here has any experience with DbBeaver and HeidiSQL and can make a comparison. I've been using DbBeaver for a while, but the interface is... strange. Will probably try Heidi tomorrow.

I've been using HeidiSQL since around 2008(?) at my first job. What I like the most about Heidi is the UI for generating queries and editing left/right joins in a graphical manner. So you can use it to "prototype" your queries first, try them out, see the results, and then copy/paste them into your code, which is a supernice experience, including for beginners that haven't had much experience with SQL databases and lack the "feeling" of how to decouple datasets into tables.

I was trying out DBeaver a lot, actually, but a couple of things here and there didn't work as expected. Sometimes I had problems with batch selections that I couldn't reproduce so I was then most of the time switching back to HeidiSQL in my wine sandbox when it didn't work, out of frustration.

To me it's really great to see Heidi getting revived into a community software again, I really missed the tool a lot since I've made the switch to Linux as my daily driver everywhere. Wine's double click seemless windows aren't really nice and sometimes really annoying.

Re: HeidiSQL Available Also for Linux

#9

Post by smackeyacky »

moron4hire wrote: post #4

I'm curious if anyone here has any experience with DbBeaver and HeidiSQL and can make a comparison. I've been using DbBeaver for a while, but the interface is... strange. Will probably try Heidi tomorrow.

When I switched to Linux full time, I had to ditch Heidi as they didn’t have a Linux version. I actually prefer dbeaver now, Heidi had some odd defaults (default collation especially) which need attention but you don’t realise it until too late. It also was a bit crashy here and there.

DBeaver has the worst name in history but it can do everything Heidi does and doesn’t fall over every 20 minutes. The buttons are all over the place and it’s harder to navigate than Heidi but it’s also standard on a few distros.

I’m glad it has some competition though. If you’re working with sql server Microsoft have really dropped the ball with SSMS and don’t talk to me about azure data studio it is a undergraduate project that got a C.

I was switching a lot between SQLite, pawl, Marian and sql server and dbeaver is excellent on all of them

Post reply on HN