2w ago

My boss bought me DataGrip today

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.

33 comments

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
- Pff, imagne not just using butterflies.
I forgot database UIs exist lol
Hey you leave my favourite beaver alone!
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
Over here feeling all posh with DataGrip (Jetbrains).
It's honestly so much better if you're in DBs a lot.
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.
  
  Beaver does not crash
  Whole OS Crashes instead
  
  Arch is incredibly stable. The old meme about it needing constant attention hasn't been true for at least a decade now.
Ah DataGrip, where my Untitled Querys go to never be seen again
Flatpak version seems to run stable enough for my taste, but i'm no expert when it comes to db management
My 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.
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.
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.

33 comments