5 ms·
What other SQL UIs are people using? There are so many out there: Redash, Metabase, DBeaver, SQLPad, Superset (kinda).
by akulkarni 6y ago
What other SQL UIs are people using? There are so many out there: Redash, Metabase, DBeaver, SQLPad, Superset (kinda).
- drewda 6y agoOf the commercial options, I used to use Navicat. Then moved on to DataGrip by Jetbrains. Of the open/free options, I like DBeaver.
- akulkarni 6y agoCurious - why DBeaver?
- rocmcd 6y agoNot the GP, but while the UI leaves something to be desired (it’s Eclipse-based), I’ve found it’s a very productive tool once you figure things out. ER diagrams, graphical ways to update data, extensive ways to export/import data, DB metrics dashboards, lots of useful tools and features.
- digitalboss 6y agoI've been using Mode Analytics for almost 5 years, and use Metabase or Redash for self hosted solution.
- smoe 6y agoWe are using DataGrip and DBeaver to develop any non trivial SQL and investigations. Metabase we use for building dashboards, and we taught non technical people to use it so they can answer ~70% of questions they have about the data themselves.
- Shorn 6y agoIf you use DataGrip, make sure you try out the new (to me as an IDEA user, anyway) "Show output results in editor" function. It's disabled in IDEA by default, so go switch it on and try it. It's my most recent example of a feature I didn't even know I wanted and now can't imagine not having.
- antman 6y agoAs an added question does any of those free systems support crossfiltering or drill down? Tested them and they seem severely lacking in basic 2020 features their big costly brothers got years years ago.
- infinite8s 6y agoHow does this work?