Which GUI tools does /g/ use to manage their databases?
>>106557334A terminal
>>106557334dbeaver, unfortunatelyit's shit, but the rest is even more shit
HeidiSQL for sure!
Heidi
>>106557334dbeaver. Or just what the IDE has included. It doesn't really matter.
>>106557334That 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.
>>106557334Sqlitebrowser. 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
>>106557334Antares
phpMyAdmin
>>106557664We have this installed for our servers in case we need it and can't use something else but it's genuinely horrible.
>>106557334Navicat, 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.
>>106557334notepad, sometimes excel
>>106557334DBeaver for SQL, Compass for Mongo/Cosmos.
>>106557334Adminer
>>106557334notepad++
>>106558259>>106558192how 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?
>>106557334toad and sql developer
>>106558487You don't, that rat fuck is lying.
>>106557664>>106557745Isn't phpmyadmin an enormous security risk for serious stuff?
>>106557349This. 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.
>>106558813The 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.
>>106557334This 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.
>>106559362If 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
>>106559452Who said anything about SQL?
>>106557334DbForge. MySQL doesn't even have a dark mode.
>>106557334Pgadmin 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.
>>106560477nice
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.
