Thread 106557334

Which GUI tools does /g/ use to manage their databases?

>>106557334 (OP)
A terminal

>>106557334 (OP)
dbeaver, unfortunately
it's shit, but the rest is even more shit

HeidiSQL for sure!

Heidi

>>106557334 (OP)
dbeaver. Or just what the IDE has included. It doesn't really matter.

>>106557334 (OP)
That one. MySQL Workbench.
It looks good (and SOVLful too), it displays the queries properly, but it's horribly unstable, and the autocomplete is shit.
Still, I don't know of a better one, so I use it for work and personal stuff too.

>>106557334 (OP)
Sqlitebrowser. There are probably better options, but I mainly handle my database via python programs so I mostly use it to troubleshoot

DBGate, you don't need more

>>106557334 (OP)
Antares

phpMyAdmin

>>106557664
We have this installed for our servers in case we need it and can't use something else but it's genuinely horrible.

>>106557334 (OP)
Navicat, it was insanely fucking helpful, I honestly wouldn't have learned sql as well as I know it today if it weren't for it.

Unfortunately a single computer license is like $799, or $199 for MySQL only.

desu I might consider asking my boss to get one. It's a too good app.

>>106557334 (OP)
notepad, sometimes excel

>>106557334 (OP)
DBeaver for SQL, Compass for Mongo/Cosmos.

>>106557334 (OP)
Adminer

>>106557334 (OP)
notepad++

>>106558259
>>106558192
how do you performance analysis with notepad/++ ?

I've only messed around with sqlite. Only used terminal and python scripts to manage things.

This picture looks very busy. Isn't all that a bit distracting?

>>106557334 (OP)
toad and sql developer

>>106558487
You don't, that rat fuck is lying.

>>106557664
>>106557745
Isn't phpmyadmin an enormous security risk for serious stuff?

>>106557349
This. Readline > any widget toolkit for manipulating textual data.

Just a reminder if you don't know: you can use c-x c-e to open the current command line in EDITOR. c-r does a regex search through your history.

Of course if your a corpo on sqlplus you get squat because oracle fired everyone who could code and won't touch the GPL with a ten foot pole.

>>106558813
The endpoint is not publicly accessible, and I think we run the version that doesn't need root account credentials. So no, not more than any other DB client.
I would never run it on a public endpoint as it is of course.

>>106557334 (OP)
This looks like a nightmare only compared to Java code.

>>106557574
>Sqlitebrowser.
That's fine for having a poke around providing the DB isn't live. It's too eager to hold full transactions open for it to be a good thing for a live DB.
Mostly I just use the command line tool.

>>106559362
If you don't even know SQL, there's a 100% chance you don't know programming at all, so your opinion on Java or anything else is irrelevant.

I had a good one but only remember db beaver now. Have a look on alternativeto and see pops up.

Every JetBrains IDE has a fantastic database GUI

>>106559452
Who said anything about SQL?

>>106557334 (OP)
DbForge. MySQL doesn't even have a dark mode.

>>106557334 (OP)
Pgadmin for postgres.
I also use mariadb, but I don't care for using a tool

Adminer.

At work, we went from intelij, then dbeaver, and now we use a crappy cloud terminal session where the terminal breaks if a line is longer than 80 characters or if you paste anything in.
And that's just database stuff. I feel like this constant downgrading is deliberate.

>>106560477
nice

I used aquadata studio when I worked.
I hate that it was so fucking good. I wanted to hate it because it was java, probably spagghettied by 1000 jeets, but it just worked.
Tried some of the other free alternatives and they were laggy, or didn't have good support for anything that wasn't fotm (we used HP nonstop and db2) or the completion sucked or had some random issue or another.

you're not White if you've never used this.