Hacker News Reader

Comment by jgalt212 | Hacker News Reader

If you want to fiddle with SQLite and don't need all the power herein, I recommend DB Browser for SQLite.

I would recommend TablePlus, the free version has annoying limitations (how many tabs you can open at the same time) but it’s more than enough if you’re just getting started. One of the best developer tools that I’ve ever bought

https://tableplus.com/

I second table plus. Great tool

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.

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

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

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

Reply on news.ycombinator.com