Ask HN: Best Interactive Environment for SQL?
5 comments
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.)
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.
For MySQL/compatible stuff, I still end up back on SequelPro though, because it's much "lighter", IMO.
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).
i used to love AquaDataStudio, but their license price went nuts sometime ago, since then, i have been orbiting around datagrip.
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
...