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

DBeaver – open-source database client

github.com

Post reply on HN
Print view View original

11–20 of 161 posts

Re: DBeaver – open-source database client

#11

Post by cbb330 »

I like dbeaver for browsing DDL, list of tables, examples of schema, data types. also, to edit a few rows here and there as a quick test/fix to something. because its easier to click around than write many 2 line sql to do the same thing.

But, I often use jupyter notebooks for the DML aspect of hard queries and data anlysis, for the power of dataframes and repeatable cells mixed with documentation and sharing.

So all that to say, anyone know if there is a DDL browser equivalent ideal for jupyter notebooks / ipywidgets?

Re: DBeaver – open-source database client

#13

Post by nurettin »

neals wrote: post #8

I use HeidiSQL for my SQL databases

This is a windows program written in delphi. A fitting choice, because Delphi provides both the necessary data grid component and the syntax highlighting editor, as well as connectors to several sql databases.

A cross platform version could be written in Lazarus, with the idea that it uses less system resources than a large java program.

Re: DBeaver – open-source database client

#16

Post by singingfish »

cbb330 wrote: post #11

I like dbeaver for browsing DDL, list of tables, examples of schema, data types. also, to edit a few rows here and there as a quick test/fix to something. because its easier to click around than write many 2 line sql to do the same thing. But, I often use jupyter notebooks for the DML aspect of hard queries and data anlysis, for the power of dataframes and repeatable cells mixed with documentation and sharing. So all…

same, except I use emaacs org mode instead of jupyter (and have record keeping / backup implemented with git-auto-commit-mode as well)

Re: DBeaver – open-source database client

#17

Post by dfee »

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.

Re: DBeaver – open-source database client

#18

Post by staticlibs »

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 this tool won't use additional SQL Server-specific queries for introspection. DBeaver is much better at this, I guess it is using JDBC API or DB-neutral INFORMATION_SCHEMA views for introspection.

[1] https://babelfishpg.org/

Re: DBeaver – open-source database client

#19

Post by osigurdson »

Functionally it is very good, I like it very much. it does show that not all dark modes are created equal however. I think it takes an especially good designer to do dark mode well.

A good example of a well done dark mode (in my opinion of course) is Grafana.

Re: DBeaver – open-source database client

#20

Post by ramon156 »

dfee wrote: 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.

Not good at supporting GTK either, its the sole reason I do not use it on gnome
Post reply on HN