Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#1

Post by kadomony » Fri, Jul 07, 2023, 1:30 AM UTC

No post body was provided.

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#2

Post by momirlan » Fri, Jul 07, 2023, 1:42 AM UTC

Relational? DbVisualizer

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#3

Post by billy_bitchtits » Fri, Jul 07, 2023, 2:05 AM UTC

microsoft access

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#4

Post by seeknotfind » Fri, Jul 07, 2023, 2:06 AM UTC

Nothing beats the freedom and universality of the command line or using APIs (with a small utility library) in a repl of the language of your choice.

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#5

Post by vietthan » Fri, Jul 07, 2023, 2:07 AM UTC

I’m happy with DBeaver as I have many databases of different engines that I have to connect to throughout the day.

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#6

Post by jayy-lmao » Fri, Jul 07, 2023, 2:08 AM UTC

Without a doubt DBeaver!

PgAdmin never got me out of the psql terminal but DBeaver has been a pleasure to use

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#7

Post by nico-mac » Fri, Jul 07, 2023, 2:11 AM UTC

phpMyAdmin, what a great database tool. I have always missed it when working with postgres.

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#8

Post by vmurthy » Fri, Jul 07, 2023, 2:16 AM UTC

My use case is a bit different (I am a PM) but I found what pyCharm offers very useful for my use case (Postgres) . I don't create or manage DBs if that helps.

They have a tool called DataGrip as well [1]

[1] https://www.jetbrains.com/datagrip/

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#9

Post by garciasn » Fri, Jul 07, 2023, 2:32 AM UTC

seeknotfind wrote: post #4

Nothing beats the freedom and universality of the command line or using APIs (with a small utility library) in a repl of the language of your choice.

I mean, you're not wrong: there is absolutely a big place for API/CLI support with DB tools, but in this specific instance, the OP specifically asked for a GUI, not CLI or APIs to roll their own.

If you're a MacOS user and your DB of choice is supported, this is my choice: https://www.beekeeperstudio.io/

If you're a Postgres user, pgAdmin had previously been my go to: https://www.pgadmin.org/

Re: Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

#10

Post by factorialboy » Fri, Jul 07, 2023, 2:35 AM UTC

I've tried a few, but given my workflows, I find the "built-in" database GUI capabilities in Jetbrains IDEs more than sufficient for my needs.