[croo]

My chooosen database explorer is Dbeaver. Horrible name but great app.

You can set colours for local/test/prod servers and a red colored tab will scream at you to be cautious. And with red color every edit will pop up an "are you sure?" question. And autocommit is off.

I sorta stopped making unrecoverable mistakes.

[nucleardog]

Autocommit being off took prod down for me.

Hop in the test database, run some SQL, update a bazillion records, run some selects to verify, open the test app and verify there. All good! Someone else checks… LGTM.

So I do the same thing in prod. Make changes, validate in the DB, looks good. Open the prod app… down. Requests are hanging.

Our software is shit so I’m not surprised. I start frantically digging through trying to figure out where and why it’s hanging. Eventually chase it down to some lock wait timeouts in SQL. Start looking at the database… no queries seem to be running against the table in question. Eventually dig a little deeper and find… the call was coming from inside the house! The locks are held by my connection. Go hit “commit” in dbeaver and prod comes right back up.

And that’s the boring story of the day I learned that dbeaver used transactions in prod connections by default.

[reaperducer]

My chooosen database explorer is Dbeaver

I just checked it out, and it looks promising.

Con: There are too many licensing options. I'm not even sure which one I would need.

Pro: They'll send out an invoice, like a real company. I work for a billion-dollar healthcare company, and if your company only takes PayPal, or Venmo, or something else that makes it look like two guys in a basement, it'll never get through our purchase approval process. Big companies do business with other big companies. Startups have to learn to interface with businesses on a business level if they ever want to grow out of being a startup.

[fbdab103]

Start with the Community Edition and see where it takes you.

[loa_in_]

As if two guys in a basement couldn't send out an invoice

[Lvl999Noob]

The parent isn't saying that they couldn't. They are saying that they shouldn't advertise their two-guy-ness in the financial parts of their company.

[fbdab103]

My only complaint about DBeaver is how powerful it is -I feel like I have only ever scratched 1% of the functionality it offers. I need a tutorial class on all of the goodies the platform can do.

All of the tutorials I seem to find online are basic level and/or mixed with introducing SQL.

[jareklupinski]

i'm using it on Mac, and it seems to want to update every time I turn it on... i get that having timely updates is great, but the way to update the app on a mac is:

click ok on the update dialog, wait until the download finishes, shut down the app, drag the new app over to Applications, click Replace, wait for the actual moving dialog to pop up, wait for the moving dialog to finish, minimize all your windows so you can see the desktop, unmount the dbeaver image, click dbeaver again

and you can get back to work! now if only I could remember all the details that were in my head when i opened the app in the first place...

dbeaver team: can you do what paint.net did please? that is, only bother me to update as i'm turning the app off, not on?

[throitallaway]

This is more of a Mac problem than anything, and why I'm such a big fan of package managers.

[acomjean]

DBeaver is great. I came from a different tool, and had to get used to persisting the changes. I’m totally use to it.

I run a local copy of the database I connect to remotely and I have to be careful about which database/table I’m connected too.

[psnehanshu]

I love DBeaver too.