Live data from Hacker News

DBeaver – open-source database client

github.com

101–110 of 161 posts

Re: DBeaver – open-source database client

#101

DBeaver works surprisingly nicely with less popular DBs. I work with Babelfish for PostgreSQL [1], it supports connections with SQL Server client libs. Most GUI client tools (like SSMS) expect "real" SQL Server on the other end of the wire - depend on various system views for DB introspection, so only partially work with Babelfish. Even if client tool is based on JDBC (like SQuirell SQL), it doesn't guarantee that th…

I personally like the ER diagram viewer in DBeaver. On a project with very little documentation, it was extremely pleasing to point it to the staging database and be able to visualize the relationships between various entities.

SchemaSpy can generate static docs based on a live db, and they include pretty good ER diagrams (IMO).

They have a sample on their website (go to the relationships section):

https://schemaspy.org/samples/epivirusurf/

The convenience factor is that you don't need a continuous connection to the db to refer to the diagrams or other docs.

Re: DBeaver – open-source database client

#102

DBeaver is great, but it's so heavy/clunky on OSX. Also, 99% of the time I want 1. tables+data 2. data structure+index of table 3. search 4. sql query DBeaver aims to be a full admin system and simply getting to the data makes me drill 3-4 levels deep in a tree and it's quite annoying that only adds to the "clunky-ness".

Yeah, to me TablePlus feels much better to use than anything else honestly, even if it's not open source.

Re: DBeaver – open-source database client

#103
It's a great client and used it for years. But I have some issues. Sometimes the cursor disappear and ctrl-enter stops working. Anyone experienced something similar and know what it could be? I run on a rather minimalistic UI environment and might lack some desktop festures.

Re: DBeaver – open-source database client

#105
post #103

It's a great client and used it for years. But I have some issues. Sometimes the cursor disappear and ctrl-enter stops working. Anyone experienced something similar and know what it could be? I run on a rather minimalistic UI environment and might lack some desktop festures.

Yep, same. A recent update introduced a bug where the entire editor window contents disappear on a diagonal. No idea why. Sometimes adding a newline foxes it, sometimes it doesn’t.

Re: DBeaver – open-source database client

#106
post #59

I know probably 95% of HN will see it as a downside but one of my favorite things about DBeaver is that because it is implemented on Eclipse you can install nearly any Eclipse plugin and they work. So I installed Vrapper to edit in Vi-mode, some git tools I like, PlantUML, etc. Really makes it a step above other tools in terms of the power and flexibility you can have with it. Apart from that, you can install it insi…

I love the Eclipse IDE. It's a shame the Eclipse Foundation doesn't treat it better.

Last time I tried to contribute to it, I ended up giving up. They wanted me to sign paperwork simply to report a bug. There was no documentation about how to build the IDE, which is scattered across dozens of repositories. Maybe that has improved, but I doubt it.

They seem to be putting all their eggs into the Theia basket, which is an IDE framework similar to VSCode. Would have been nice to see that energy go towards improving Eclipse instead of reinventing the wheel.

Improving the UI's handling of HiDPI would be nice. One can but dream.

Re: DBeaver – open-source database client

#107
post #22

Earlier quoted context omitted.

Ugliness is something I found to be quite common in Java based apps. I never understood why, though.

None of major Java/OpenJDK contributors (Oracle, Red Hat, SAP etc) care about desktop GUI Java libs. Jet Brains do care, but they are not major. All Java progress is concentrated on backend cloud services for 10-15 years already. This can explain why Swing is so underdeveloped and JavaFX was thrown away. Basically much more effort is required to make Java GUI look and behave nicely, comparing to Delphi/Lazarus or .NE…

Jet Brains care? Do they? In my experience their tools are some of the ugliest out there. Granted, that's highly subjective, but there is "something" off about IntelliJ that I can't really put my finger on. Maybe the lack of whitespace. Maybe the weird tabs.

Re: DBeaver – open-source database client

#108
post #8

I use HeidiSQL for my SQL databases

I also use HeidiSQL almost daily. Besides MySQL / MariaDB it also can connect to MSSQL and Postgres.

I recently had to import a CSV with some million rows into MariaDB. Neither HeidiSQL nor DBeaver could do it (tried various settings). IntelliJ worked like a charm.

Re: DBeaver – open-source database client

#110
post #17

I don’t know why it matters to me, but I’ve always been put off by it being ugly and using non-native widgets. That may be the only reason I’ve paid for TablePlus. I’d probably be fine with a great TUI interface, too. So it’s really this intermediate UI that irritates me.

I tried tableplus, liked it, it just feels right. I reported a minor error in docs, got a friendly message and a year of license. 10/10
Post reply on HN