Ask HN: Best Interactive Environment for SQL?

Posted by ridaj on Tuesday December 03, 2019 @10:36PM
from the ask-hn dept.

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 | 5 points | on HN )

Re:Ask HN: Best Interactive Environment for SQL? by dundercoder on Tuesday December 03, 2019 @11:03PM (#21699469)

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.

[ Parent | on HN ]

Re:Ask HN: Best Interactive Environment for SQL? by tcbasche on Wednesday December 04, 2019 @05:11PM (#21707764)

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

[ Parent | on HN ]

Re:Ask HN: Best Interactive Environment for SQL? by stephenr on Wednesday December 04, 2019 @10:37AM (#21703034)

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.

[ Parent | on HN ]

Re:Ask HN: Best Interactive Environment for SQL? by lilfermat on Wednesday December 04, 2019 @12:28AM (#21699850)

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

[ Parent | on HN ]

Re:Ask HN: Best Interactive Environment for SQL? by slipwalker on Thursday December 05, 2019 @08:03AM (#21711930)

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

[ Parent | on HN ]