4 ms·
Ask HN: Best Interactive Environment for SQL?
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
...
- dundercoder 7y agoDataGrip 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 7y agoAnything Jetbrains seems to have pretty great SQL support in any case (e.g. PyCharm, Goland etc.)
- lilfermat 7y agoI 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 7y agoDepends 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 7y agoi used to love AquaDataStudio, but their license price went nuts sometime ago, since then, i have been orbiting around datagrip.