Ask HN: Best Interactive Environment for SQL?

5 points by ridaj 6y ago ↗ HN

What's, for you, the best interactive environment for crafting SQL queries around here?

Things I'm wondering about:

* basic syntax help / autoindent

* red underline for indicating errors

* function autocomplete

* table and field autocomplete

* partial results streaming

* progress indicators

* table exploration (looking at a table catalog etc.)

* "workbench" where you can save multiple queries

* link to visualization tools

* link off to more powerful statistical analysis tools

...

5 comments

[ 112 ms ] story [ 219 ms ] thread

dundercoder 6y ago ↗

DataGrip by Jetbrains is decent. I really like the autocomplete found in the psql client as well. Sublime Text has a few sql plugins that help with code readability.

tcbasche 6y ago ↗

Anything Jetbrains seems to have pretty great SQL support in any case (e.g. PyCharm, Goland etc.)

lilfermat 6y ago ↗

I enjoy TablePlus throughly! I would download the free version and try it out. It’s a game changer for people that do majority of the their transformation and modeling in SQL. (Along with DBT).

stephenr 6y ago ↗

Depends what flavour of SQL you want to use. As pointed out already the DB plugin/DataGrip 'stand alone' app from Jetbrains is not bad, and has pretty wide language/protocol support.

For MySQL/compatible stuff, I still end up back on SequelPro though, because it's much "lighter", IMO.

slipwalker 6y ago ↗

i used to love AquaDataStudio, but their license price went nuts sometime ago, since then, i have been orbiting around datagrip.