Under Windows DBeaver is a solid (and free) tool for the casual database user. But under Linux you really learn to save your scripts often.
Over here feeling all posh with DataGrip (Jetbrains).
It’s honestly so much better if you’re in DBs a lot.
Casual is just using PHPMyAdmin or Adminer or even simpler the console mysql/mysqldump tools.
Beside that HeidiSQL and SQLyog are worth trying.Heidi’s Linux support is new. At the time I last checked for database GUIs that didn’t exist yet and I didn’t yet know how easy Wine is to use (if your application of choice works with it).
I like beekeeper studio.
Maybe you should switch to arch. Never had a beaver crash on arch.
Hell, no. This is a work laptop. I can’t justify spending days fixing some arcane bullshit that spontaneously decided to do a Leroy Jenkins.
C’mon. Live a little.
Just imagine needing to give a company-wide demo of a newly completed platform initiative, so you wanted to make sure your camera and mic were working, but you care about privacy so you want to do it locally.
You dont have an app for that, as this is a purpose-built, minimal, Arch Linux workstation, so you use pacman to install a local webcam GUI. While you’re using pacman, you think, might as well update too.
Update, reboot, uh oh.
WHERE’S THE ARCHISO USB?!?!
You can’t find it anywhere! And you even check that weird place you found it last time! Think! … Your phone has a USB-C port and a terminal right? And right there is a USB-C Flash Drive… Surely you can just flash - Ah shit, not without rooting the phone!
Thinking quickly, you unscrew the back panel and replace the M.2 SSD with the one from your personal Librem 14 laptop [you care about privacy, remember?] that’s currently out for repairs for the (now infamous) power issues. It’s Arch too, but it hasn’t been updated yet – thank the good Dennis Ritchie, so you’re able to boot with it and check the ArchWiki homepage…
Those dreaded words… MANUAL INTERVENTION NEEDED… Ugh! Why does this only happen when I need it not to!
You frantically download and flash the archiso to your available usb stick, swap ssds, boot up, decrypt the drive, mount it manually (remembering fondly the carefully chosen partition layout), chroot in, perform the “intervention”, and reboot.
Perfection. Smooth as freshly polished glass. Smoother even – probably – with these sweet new updates! You log in, slide directly into the meeting, you were only 30 seconds late. You give the presentation expertly, they’re all impressed by your fancy words like “kubernetes” and “admission controller”. “What a genius” you know they’re thinking. They have no idea.
You sign off, and wipe the cold sweat from your brow. These are the moments when you remember why you run Arch at work. Not because it’s easy – because it’s hard. Because every time you’re faced with a situation like this, you get a little bit better.
Sure, you could be an Ubuntu Urchin, a Debian Dweeb, a Mint Mistake, but you’re not. You’re better than them. You’re an Arch Assassin, because you know the moment you lose your edge – is the moment you lose your job.
You sit back and start your favorite database UI tool, DBeaver. It full screens instantly thanks to your tiling window manager. You love how it’s always been reliable on Arch Linux. Why anyone would bother doing anything else is beyond you.
Ugh, have my upvote.
You gave me second hand embarrassment because this was (admittedly an embellished version of) me during my undergraduate.
> Beaver does not crash
> Whole OS Crashes insteadArch is incredibly stable. The old meme about it needing constant attention hasn’t been true for at least a decade now.
I still wouldn’t recommend it for business. Even when stable, the Arch philosophy is to empower the end user, whereas other distros like Ubuntu/RHEL are focused on getting stuff done. In 90% of situations the difference is immaterial. But if my client is angry and my boss is breathing down my neck, and I can’t work because a thing isn’t thing-a’lating, a support path is essential.
But if my client is angry and my boss is breathing down my neck, and I can’t work because a thing isn’t thing-a’lating, a support path is essential.
Arch is still stable enough for that. The chances of something going sideways is smaller on Arch than on Windows. And unless you’re a medium to large company paying Microsoft for enterprise support, you’re going to be stuck with forums for community help with Windows.
Saying the chance of something going sideways is smaller than on Windows isn’t saying much. I’ll pick a distro that’s stable by default, TYVM.
Pff, imagine not just using the cli
In my defence: I am a frontend developer.
Is the CLI not a frontend?
So am I, and I still prefer CLI for everything
A matter of preference, really. Each side can sneer at another.
Pff, imagne not just using butterflies.
I forgot database UIs exist lol
Wait. What? I never have any issues. Maybe it’s because I use mssql? I love that thing. I recommended it yesterday
What’s your OS?
Windows at work. Ive used it con mac and linux but not enough to guarantee it doesn’t crash
Hey you leave my favourite beaver alone!
Flatpak version seems to run stable enough for my taste, but i’m no expert when it comes to db management
Ah DataGrip, where my
Untitled Querys go to never be seen againMy favorite is SQuirreL SQL. Something about that 1990s Java look is always claiming to me.
DBeaver is available for Mac and Linux too. But DataGrip is pretty sweet, so good one.
TablePlus and Postico on macOS are where it’s at. DataGrip is shit and you’ll never get me to use it.
You gotta drink enough Jetbrains koolaid to desire some amount of consistency when you’re jumping between projects.
