Live data from Hacker News

Dbeaver – Multi-platform database tool

dbeaver.io

161–170 of 209 posts

Re: Dbeaver – Multi-platform database tool

#161

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.

    It works on every database known to humans
Our team just bought a bunch of licenses of DBeaver and I think this is only correct if you mean 'relational' databases. We have a MongoDB and Eleastic and I don't believe that DataGrip supports either of these, which was a real drag.

We're fully on Jetbrains tools otherwise (R#, dotTrace and dotMemory, TeamCity as build server) so it was a no brainer for me to want to continue that trend but it didn't check all the boxes for us, despite its clear polish.

I tend to hate any IDE built on Eclipse (which I think DBeaver is), but I've been very pleasantly surprised with how well it works.

1. It's got very nice ER modeling where other tools (Like Oracle SQL Developer) make you jump through a dozen screens and a wizard to make a simple diagram.

2. It's got nice export tools to get your data to business partners in a more convenient way. Sure you can copy tables in pretty much every tool but there's just an 'excel' button that can pop open your current query in a new sheet.

3. It does have a weird delay when opening up databases sometimes where it 'reads metadata' about the table and it can sometimes take a long time to return even the most basic query. But once it's cached that data I've not noticed problems after that.

4. It does seem like the document database tooling isn't as baked as the relation tooling. I routinely get hangs when querying my Mongo collections, which is sometimes a drag. But it hasn't been a huge issue.

Overall, I'd highly recommend the paid version of this tool as it's helped me consolidate: Robo3T, Sql Server Mgmt Studio, SQL Developer, and MySQL Workbench into a single tool.

Re: Dbeaver – Multi-platform database tool

#162

Earlier quoted context omitted.

The installer comes with it's own JRE just for DBeaver, so you don't have to install Java systemwide for it to work. And why the hate for Java? Most other languages have runtime libraries or VMs too, does it really make a difference if that runtime code is baked into the exe vs. stored in a separate folder?

Maybe I don't know JRE vs Java well, but I really dislike the constant "update Java now!" messages and the hassle that goes with it.

Ah yes, that's different. There's no need to install any of that stuff when you pick the DBeaver installer that ships with a JRE. It basically just adds another folder into the DBeaver directory.

Re: Dbeaver – Multi-platform database tool

#163

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.

> It works on every database known to humans

Except any non-relational DBs.

Re: Dbeaver – Multi-platform database tool

#164
post #142
post #84

Earlier quoted context omitted.

I used to think like this too, but I've since changed my mind and understand why they do this -- and it can even be beneficial for users. There's a few big problems with the old model: First, you have to define the difference between "major" and "minor" version. Users expect major versions to have some significant improvements or new features. What this means is as a developer, you have incentive not to release minor…

I don't disagree with your points, but you can still sell software in the buy once model and just keep it live. No need for major versions unless they are needed. So the only point remaining is "we get more money this way", and that's something one could not want to participate in.

If you buy Jetbrains stuff you get a perpetual license included. It's just going to be for the initial version.

Re: Dbeaver – Multi-platform database tool

#165
post #113
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…

HeidiSQL works fine with Wine. DataGrip is fantastic and not expensive if you use other JetBrains products. It also manages its own JDBC drivers -- you don't need to install at the OS level.

Datagrip looks ugly on my gnome3 with 4k and 2.0 scaling. Fonts are way small. Also, it's a bit on the heavy side.

Re: Dbeaver – Multi-platform database tool

#166
I've been using DBeaver for years now, and it just keeps getting better and better. I use SQL every day, and DBeaver is the best client I've found.

It's shocking to me, actually, how absolutely awful most SQL clients are. It truly was an area that was ripe for "disruption".

Re: Dbeaver – Multi-platform database tool

#167
post #131

Earlier quoted context omitted.

If the cost of the tool is within the budget of the tradesman or professional, it's more common to buy it out of personal preference for a type or brand of tool. If no part of your toolset is within your budget, then you're in the working class, since you cannot ever own your own means of production.

That's not what working class means. If you earn money by working, then you are working class. If you earn money investing capital, then you're a capitalist. The working class can be further divided up, but those are all subcategories. A professional or a manager (petit bourgeois) are still working class. If you're a one-man company, then you're still working class. You only transition once your investment returns su…

That's a fair statement to make, and one that I have heard before but the definition of what constitutes the working class is arguable thus most people predefine it per scope of conversation, and not in a global sense.

For example, in the UK, commonly doctors and lawyers have not been considered part of the working class, regardless of if their investments outside of their profession.

Because a doctor can work independently, and hire other workers like nurses, and attendants, and own all of their tools of trade outright, they are part of the petit bourgeois.

Now you say that petit bourgeois is part of the working class, but many would disagree as Karl Marx and Friedrich Engels popularized a more fine grained definition of social classes as follows:

1. the working class - factory workers, peasants, and people who earn only by their labour

2. lumpenproletariat (commonly considered to include vagabonds, criminals or the 'unthinking poor')

3. professional middle-classes (engineers or tradesmen who do not typically hire employees)

3. petit-bourgeoisie - Professionals and small scale managers who hire workers but work alongside them

4. haute bourgeoisie - landed aristocracy & other capitalists who live from investment alone

Now if you are not marxists, you may drop some of the classes or simply call them something else. The lumpenproletariat are sometimes called the "underclass", and in advanced capitalist economies the line between professional middle-classes and petit-bourgeois blurs due to capital infusions from the top. For example, startup owners should rightly be professional middle class, but are upgraded due to VC infusion.

There are other ways to define the classes as well that don't depend on monetary wealth----for example the ladder from: working class to bourgeoisies to gentry to elite/aristocrats, so the terms themselves are fairly overloaded.

Analysing class warfare is a bit of my hobby. I blame my sassy liberal arts professors. :)

Re: Dbeaver – Multi-platform database tool

#168
post #130
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…

> JDBC drivers can not use a socket connection As someone that has done lots of Java development you have lost me there, as JDBC drivers obviously do make use of network connections, usually TCP/IP sockets.

TCP-only is not as big a deal as it used to be. If network stack overhead dominates your db connection you have probably done something wrong.

Re: Dbeaver – Multi-platform database tool

#169
post #81

Earlier quoted context omitted.

kind of curious about the passionate avoidance of installing Java - is that an anti-Oracle stance or something else? (I tend to be the opposite - if I can find a Java based tool to do the job I'll choose that because they tend to be very self contained, don't often require messing around with other OS dependencies ...)

It constantly hassles me with requests to upgrade. Doesn't it sometimes try to trick me into installing something else, too?

Yeah, the Oracle installer does / used to do all those things. Apart from anything else, you will now end up agreeing in the fine print not to use Java for certain purposes. Basically, don't use anything Oracle to do with Java.

Fortunately there are good ways to get it. OpenJDK and Azul have much more hassle free installations now. I personally use sdkman [1], but conda [2] is another very easy way to get java that won't hassle you.

Not that I'm trying to persuade you or anything - I was just curious!

[1] https://sdkman.io/ [2] https://anaconda.org/anaconda/openjdk

Re: Dbeaver – Multi-platform database tool

#170
post #130
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…

> JDBC drivers can not use a socket connection As someone that has done lots of Java development you have lost me there, as JDBC drivers obviously do make use of network connections, usually TCP/IP sockets.

Sorry, I meant Unix socket. They are the best setup for postgres connections on a dev machine imo.
Post reply on HN