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

171–180 of 209 posts

Re: Dbeaver – Multi-platform database tool

#171

Post by rsyring »

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…

For what it's with:

- Valentina Studio: support confirmed and fixed the bug in about a day. Waiting for the next release. Not crazy about some of their UI, but hopeful this will be my answer.

- DBeaver: going to give it a try

Re: Dbeaver – Multi-platform database tool

#172

Post by zepearl »

I love DBeaver.

Long time ago I started searching for a DB-client similar to "TOAD", but on Linux and targeting only my following key requirements: 1) write & execute single SQLs on a "page" which has multiple SQLs without having to use any terminator (";") between them, 2) ability to show the execution plan of the SQL in which the cursor is positioned and 3) ability to connect to different kinds of databases.

I ended up with nothing, and I actually even initially excluded DBeaver as running on Java (personal thing - most Java apps I tried always had some kind of bug which made it a no-go for me).

After a while I gave it a try and I ended up being extremely happy with it, especially because I can use it with basically all databases that I am/was using (I'm currently using it mostly with MariaDB & Clickhouse, but used it in the past as well with DB2, Kudu, PostgreSQL).

Re: Dbeaver – Multi-platform database tool

#173

Post by tyldum »

milin wrote: post #100
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.

Prolly does not work on redis

Enterprise version, like with Influxdb as well.

Re: Dbeaver – Multi-platform database tool

#174

Post by mthoms »

wwn_se wrote: post #128
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…

All jetbrains products have a licence witch grants you the right to use the tools you buy forever(Without updates). If you buy a tool in 2019 you get a licence for 2019.1 and updates for a year. So if you never update you only have to pay once.

Except you only get the version that was released at the beginning of the cycle. In other words, when your subscription is over, you have to downgrade to a version that's a year old. Bugs and all.

With most software, this would not really be a huge deal. Photoshop? Who cares. Excel? Meh.

But with Jetbrains products you've got to consider whether the old version is going to be 100% compatible with your existing project files, plugins, keybindings, settings and configurations.

It's quite a gamble IMHO.

Re: Dbeaver – Multi-platform database tool

#175

Post by mthoms »

spullara wrote: post #88
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…

You always have a perpetual license to the last version that your subscription covered. It isn't anything like Adobe's model.

Actually, it's the first version that your subscription covered.

Re: Dbeaver – Multi-platform database tool

#176

Post by mthoms »

rolleiflex wrote: post #85
doxavore wrote: post #77

Earlier quoted context omitted.

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.

I thought their fallback perpetual license is actually for the version you had when you purchased it, not for the version that was available when your subscription lapsed? Not sure if they changed this recently - I stopped following them when they switched to subscription with fairly onerous terms (which they rectified after backlash to ‘mediocre’, but never to ‘fair value’).

My subscription lapsed just before the New Year and I wasn't able to continue to use the software I had already installed.

In order to keep using it, I would be required to downgrade to the version available at the beginning of my subscription. 12 months ago.

If there are show stopping bugs in that version, then too bad. If it's not compatible with your current projects and plugins? Deal with it.

Re: Dbeaver – Multi-platform database tool

#177

Post by mthoms »

013a wrote: post #66

I've used TablePlus before (Mac+Windows); its really good, and pretty affordable at a $60 one time charge. https://tableplus.io/

My experience with it wasn't so great. Very buggy and unintuitive. I also got summarily dismissed on github when reporting a very pedestrian bug/oversight. https://github.com/TablePlus/TablePlus/issues/677

Aesthetically, it looks great though. I wanted to like it.

Re: Dbeaver – Multi-platform database tool

#178

Post by spricket »

wink wrote: post #154
spricket wrote: post #139

Earlier quoted context omitted.

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 :)

I agree completely. The UI is kinda hokey but I still love it because I've seen so much worse. Try giving it a few weeks, as you need the more advanced stuff you'll learn where the bodies are buried and it becomes semi pleasant to use

Re: Dbeaver – Multi-platform database tool

#179

Post by spricket »

mritchie712 wrote: post #159
wink wrote: 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…

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…

DBeaver has some basic autocomplete that's frequently useful. Nothing super powerful but hitting shift enter(shortcut may be different off Mac) when on text pane at top of data tab will help you select cold easier

Re: Dbeaver – Multi-platform database tool

#180

Post by h1d »

spricket wrote: post #139
wink wrote: 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…

My workflow is just too used to the easiness of using SequelPro, I can't live using any of "heavy" clients, not even DataGrip which is unfortunate as I cannot leave using MySQL.

Closest thing that works for me is TablePlus but the UI smoothness is still rough around the edges.

Post reply on HN