Ask HN: Best Interactive Environment for SQL?

#1

Post by ridaj » Wed, Dec 04, 2019, 3:36 AM UTC

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

...

Re: Ask HN: Best Interactive Environment for SQL?

#2

Post by dundercoder » Wed, Dec 04, 2019, 4:03 AM UTC

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.

Re: Ask HN: Best Interactive Environment for SQL?

#3

Post by lilfermat » Wed, Dec 04, 2019, 5:28 AM UTC

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).

Re: Ask HN: Best Interactive Environment for SQL?

#4

Post by stephenr » Wed, Dec 04, 2019, 3:37 PM UTC

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.

Re: Ask HN: Best Interactive Environment for SQL?

#5

Post by tcbasche » Wed, Dec 04, 2019, 10:11 PM UTC

dundercoder wrote: post #2

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.

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

Re: Ask HN: Best Interactive Environment for SQL?

#6

Post by slipwalker » Thu, Dec 05, 2019, 1:03 PM UTC

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