Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Dbeaver – Multi-platform database tool

dbeaver.io

Post reply on HN
Print view View original

71–80 of 209 posts

Re: Dbeaver – Multi-platform database tool

#71

Post by sk5t »

rsyring wrote: post #64

I can't believe how hard it is to find a good database client tool that runs on Linux. I spent hours on Sunday looking for something that worked as well as pgadmin3. I don't prefer these Java tools that force you to manage JDBC drivers and usually share dated and cluttered UIs. Plus, I can't stand having to manage connections to each database instead of to each server. Let me connect to the server and then select my…

You can flip between postgres databases in dbeaver quite easily (dbeaver calls it changing the "active object"). I used to use pgadmin3 every day, and have found dbeaver to be much better, and about the same as DataGrip. Although some things still feel better in psql or pgcli.

The vast coverage of JDBC is probably a good reason so many tools use Java. I'm sure you wouldn't prefer they all used ODBC or DBI instead.

Re: Dbeaver – Multi-platform database tool

#73

Post by brightball »

edgarvaldes wrote: post #7

I use Navicat, and I'm very pleased with it.

I’m a huge Navicat fan and it’s the tool I most miss since switching to Linux. Their Linux version is just running the Windows version in Wine.

I’ve been using DBeaver and I’ve been very happy with it though. Paid for the enterprise license to help support it too.

The biggest tools from Navicat that I miss within DBeaver are the data sync and schema sync tools.

Re: Dbeaver – Multi-platform database tool

#74

Post by AlfeG »

zamazingo wrote: post #15
orthecreedence wrote: post #4

I use DBeaver all the time and love it. MySQL, Postgres, SQLite, etc...all the tools I need in one app. I generally try to avoid Eclipse-based projects because they can be very bloated, but in this case it's easily justifiable.

Does it provide any linting or other code checks? I'm curious because I'm looking for something that can teach me proper SQL coding style and practices as I write it.

Yes. At least for Postgres autocomplete is very handy.

Re: Dbeaver – Multi-platform database tool

#75

Post by zoom6628 »

Been a user of DBeaver for years - across all my platforms. Its does most things well enough that it has not been a problem to use across SQLite, MSSQL, MySQL and various file based data. Easier to use than SQuirreL which used to be my fav. All of these are java tools I think primarily because of starting from JDBC for which there seems to be a driver for just about everything on the planet.

So DBeaver scratches my itch of needing same tool across platforms, across databases.

Re: Dbeaver – Multi-platform database tool

#76

Post by tomnipotent »

yumraj wrote: post #61
neosavvy wrote: post #57

How is no one talking about https://www.jetbrains.com/datagrip/ These guys actually fix their bugs. It works on every database known to humans, and also does nearly everything DBeaver appears to do.

Perhaps, but DBeaver is free while Datagrid is not, in fact it is rather expensive at $199. For many people, including me perhaps, something like DBeaver is good enough since it's free.

> rather expensive at $199

Compared to a six-figure salary? Developers tools are a bargain for what we get out of them.

Re: Dbeaver – Multi-platform database tool

#77

Post by doxavore »

chamakits wrote: post #69
wyqydsyq wrote: post #68

Earlier quoted context omitted.

The software is great but I would never buy it purely because of their business model. There is absolutely no reason DataGrip needs to be a subscription service. There aren't any ongoing costs for customers to use it. It should be a one-off purchase with optional support subscription, maybe requiring re-purchase at major version increments, not this bullshit where you need to maintain a subscription for a license on…

Just so you know, although not very clearly documented, yearly subscriptions include perpetual license for that specific version. You can see it on the “buy” page. It’s still less than ideal, but I pay yearly for their “all pack” product and I feel with the amount I use it I’ve gotten my money’s worth every year.

This. The JetBrains licensing model is great. Subscribe to get updates, with a perpetual fallback license for the last version when your subscription lapsed. Their old versions also continue to work across OS upgrades, etc. If you subscribe, the annual fee decreases substantially for the first few years. This is nothing like Adobe's Creative Cloud.

Re: Dbeaver – Multi-platform database tool

#78

Post by JimmyL »

I've had better experiences with DataGrip, but if I wasn't at a place that would pay for proper tools, DBeaver is an OK substitute. Neither, though, have the big thing I want in an analytical SQL workspace:

Simple charts

A whole lot of my work ends up with a three- or four-column table with one column of buckets, and the other being counts of how many things ended up in that bucket. I'd love a view where I could render that into a line or bar chart as a sanity check, and have it update in real-time as I change my query. Instead, I end up having to constantly copy/paste into Excel and do it there.

Yes, I should be using a proper BI or visualization tool for real reports. But sometimes I just need a quick line chart to show that yes, that one count is going in the right direction.

Re: Dbeaver – Multi-platform database tool

#79

Post by zmmmmm »

eyeball wrote: post #53

My company's IT team won't allow install of non-approved tools. I'm stuck with oracle sql developer. fml.

Pretty sure if it's java based you can download it and run it entirely in user space if that is OK. Of course, making an end run around IT policy isn't always an advisable solution even if it does work.

Re: Dbeaver – Multi-platform database tool

#80

Post by endorphone »

neosavvy wrote: post #65
crazysim wrote: post #63

Earlier quoted context omitted.

$90 individual https://www.jetbrains.com/datagrip/buy/#edition=personal But you're probably right.

If you are a student it's free. Also good tools are worth paying for, I have been a subscription user of their tools now for years. I think it's like $199 for a subscription to the whole suite. If you are a dev (or work for someone who expects you to do dev work for pay) it's worthy spending a few of your coins on good tools. I stare at these tools all darn day, and they rarely if ever crash. I don't regret moving aw…

I agree wholeheartedly, and subscribe to the whole suite of JetBrains tools. Absolutely fantastic value.
Post reply on HN