Live data from Hacker News

Dbeaver – Multi-platform database tool

dbeaver.io

151–160 of 209 posts

Re: Dbeaver – Multi-platform database tool

#151
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…

Run pgadmin4 on docker, save yourself the setup.

dpage/pgadmin4

Re: Dbeaver – Multi-platform database tool

#152
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…

I have subscribed to this issue [1] of azuredatastudio (ex sqlopsstudio) in the hope that one day it will support more than SQL Server. I am not sure Microsoft would have any interest in supporting others SQL engine though. Visually the software looks really similar to VSCode by the way.

[1] https://github.com/Microsoft/azuredatastudio/issues/56

Re: Dbeaver – Multi-platform database tool

#153
post #133

Earlier quoted context omitted.

Not all WORK needs to be paid for.

That is correct. Trivial example: If I say I'll do some work for free the we can assume you don't need to pay for it.

Just like I should not complain if you decide not to keep doing it, when the need to pay for bills arises or I happened to abuse from your goodwill.

Re: Dbeaver – Multi-platform database tool

#154
post #127

Earlier quoted context omitted.

Just installed it for the first time in a few years. - Again I wonder why it doesn't show the tables first, I have to go through Schemas -> Public. - 480 MB of RES RAM, I'm connected to one smallish Postgres DB. - I can't even find "just show me the contents of the table, like 'SELECT * FROM'. I know, maybe it's tailored for Enterprise Database Architects, but this is my smoke test for a DB GUIs: "How long and how ma…

Maybe I've been jaded by SSMS and Mysql Management Studio heh. DBeaver actually has a better UI than most DB tools I've used, even though that's still not saying a lot. Mouse over the buttons for an excessive amount of time and the tooltips will tell ya what they do. Double click a table and go to "data" tab to see contents. Schemas ->public is just a side effect of supporting a lot of different databases. Many suppo…

I don't know those 2, but I like Sequel Pro and pgadmin.

And yeah, I found "data" and maybe reading the manual would even let me somehow get there quicker. Still, I don't remember ever working with Postgres (or Oracle) in whatever role or project and not needing the "data" view 10 times as often as the schemas or other stuff :)

Re: Dbeaver – Multi-platform database tool

#155
post #55

Needs Java. I saw it mentioned in the HeidiSQL thread and thought I would try it. Never completed the installation. Not putting Java on my machine, nope. Yes, I do understand the advantages of Java. Runs everywhere, which is nice. I'm still not installing it.

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.

Re: Dbeaver – Multi-platform database tool

#156
post #81
post #55

Needs Java. I saw it mentioned in the HeidiSQL thread and thought I would try it. Never completed the installation. Not putting Java on my machine, nope. Yes, I do understand the advantages of Java. Runs everywhere, which is nice. I'm still not installing it.

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?

Re: Dbeaver – Multi-platform database tool

#157
post #61

Earlier quoted context omitted.

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.

Sure. Tools are still difficult to maintain and develop. I love VS code which is free (as in Microsoft). It has replaced JetBrains Pycharm for me.

That said, I have a JetBrains subscription because their suite has a lot of value if you deal with multiple types of databases (or Java/.Net). Their business model is refreshingly straightforward, the coding is solid and I don’t mind giving them money.

Re: Dbeaver – Multi-platform database tool

#158
post #61

Earlier quoted context omitted.

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.

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

It's not the money, it's having to buy it.

Re: Dbeaver – Multi-platform database tool

#159
post #127

Dbeaver is the best FOSS database UI tool hands down. I've done a lot of searching and haven't found anything close. Managed to convert my whole office to it in a matter of months. Favorite features: Well integrated ER diagrams that let you quickly see parts of the db related to current table, or the whole thing if you want. SQL generation from structure or data edits. Great for cranking out DB migrations like a boss…

Just installed it for the first time in a few years. - Again I wonder why it doesn't show the tables first, I have to go through Schemas -> Public. - 480 MB of RES RAM, I'm connected to one smallish Postgres DB. - I can't even find "just show me the contents of the table, like 'SELECT * FROM'. I know, maybe it's tailored for Enterprise Database Architects, but this is my smoke test for a DB GUIs: "How long and how ma…

I have this same smoke test and it's one of the reasons we built "slash commands" into SeekWell (https://seekwell.io/). If you type "/show" (or even just "/s") you get a list of tables that will be filtered down as you type. Once you select a table it will autocomplete a SELECT statement and return the results. It also works for things like adding a WHERE condition. The goal is to make it so you never have to leave your keyboard, but also never need to type out menial SQL. Here's a 30 seconds video showing how it works.

https://www.useloom.com/share/0e0b79b0b8304035af4bb15552abc3...

Re: Dbeaver – Multi-platform database tool

#160
post #134

Earlier quoted context omitted.

TablePlus is very nice and it supports NoSQL databases like Cassandra, CockroachDB, and Redis. It's Electron-based, so it is relatively heavyweight, but I like it a lot.

It is not Electron, it's native. The reason it's heavy because it contains the database drivers, some of them is hundreds of MBs (Oracle > 200MB).

Pardon me - I've checked and you are right. The look&feel really threw me off here, and I could've sworn it's browser-based.
Post reply on HN