Hacker News new | ask | show | jobs
by JonoBB 3843 days ago
If you are on Windows, then HeidiSQL is very good (MySQL, MSSQL and PostgreSQL).

If you just want something very light and easy and runs in a browser, then Adminer is pretty good (not an IDE, but certainly better than PHPMyAdmin).

5 comments

Just to add, HeidiSQL also runs fine on Wine (it's even mentioned on the download page)

I've been using it on Linux for quite some time. Being able to work on MSSQL from Linux is just great :)

Absolutely agree with HeidiSQL. I'm in a situation where I'm still running MySQL 4.0.26 and essentially nothing properly supports that with the exception of the old MySQL query client (not workbench) and HeidiSQL which blows mysqls software out of the water. It's a really solid software.
Datagrip will work, so long as you have compatible JDBC driver.
I'm going to give it a shot again, but when I tried before it was buggy with support for that version. It seemed like it technically connected but it wouldnt run any queries nor show any of the columns. Now that it's 1.0 I'll try again but I can't spend too much time fighting it. I really want to be able to use it but time unfortunately equals money :/.
Checked HeidiSQL again after so many years and I'm surprised to see it work so effortlessly and fast with any MSSQL and PgSQL db connection I threw at it. It definitely needs to be given a chance.
HeidiSQL is pretty good feature-wise, though I think it still can't connect to a server via a SSH tunnel if also using an encrypted MySQL connection (the SSL checkboxes are greyed out).

Another issue is that while it's open source, it's written in a language that requires an obscure, proprietary and expensive compiler, which makes contributing to it basically impossible.

Speaking about db tools that run in a browser, have you checked out Datazenit? It has handy data grid, query builder, keyboard navigation everywhere, charts/visualizations and a lot of other features.