3 ms·
Another fantastic UI is IntelliJ (database support is built into the IDE) or Datagrip. It's a paid product, but it's more than worth the money if you use it dai
by binwiederhier 3y ago
Another fantastic UI is IntelliJ (database support is built into the IDE) or Datagrip. It's a paid product, but it's more than worth the money if you use it daily.
- mhitza 3y agoCan you sell me on the IntelliJ suite of IDEs database UI? What makes it in your opinion fantastic? I'm using it at the monent, it sure beats dealing with sqlite at the cli level but apart from that to me it feels as rudimentary as any other DB UI I've used in the past.
- ochoseis 3y agoOne thing I’ve done before is variable replacements in the queries (e.g. `WHERE user_id = ${user_id}`). Not sure if other tools do that easily, but it makes having a library of debugging queries more handy. They also support a lot of drivers, including specialized ones for things like RDS. I don’t have a ton of experience with other tools, so not sure if those a standout features versus the competition.
- rovr138 3y agoConsistency is what makes it for me. I work with MySQL, Maria, Postgre, BigQuery, snowflake, SQLite I can find UI’s for them, but having one tool means it’s the same set of shortcuts and tools. I also use their ides for development so having one set of global shortcuts that work across them is also great. Usually someone chimes in that vscode, vim or whatever also can do this. My counter argument is that I don’t want one tool to do python and go. I don’t want my settings in one to affect the other. I want separate tools that I can configure but have the same feel and global shortcuts.