Dbeaver – Multi-platform database tool • Hacker News Board

Re: Dbeaver – Multi-platform database tool

#111

Post by axaxs » Fri, Jan 18, 2019, 5:32 AM UTC

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…

Absolutely. I only work in MySQL and dbeaver was the only tool that worked without a huge headache in Linux.

Re: Dbeaver – Multi-platform database tool

#112

Post by rahilsondhi » Fri, Jan 18, 2019, 5:36 AM UTC

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…

PopSQL (https://popsql.io) should give you the modern UI you're looking for. Although you will have to create a connection per database, unfortunately.

Re: Dbeaver – Multi-platform database tool

#113

Post by smt88 » Fri, Jan 18, 2019, 5:53 AM UTC

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…

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.

Re: Dbeaver – Multi-platform database tool

#114

Post by spricket » Fri, Jan 18, 2019, 5:57 AM UTC

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.

Ability to maintain many database connections at once, and support for doing stuff before/after connecting which we widely abuse to setup SSH and VPN connections.

Very liberal database support. My original search for a tool like DBeaver was from the need to connect to MySQL, Postgres, and SQL Server and not wanting to use a bunch of different tools. DBeaver supports roughly anything Java supports, which is everything.

Wide OS support. Good luck finding another tool that can connect to MS SQL Server on MacOs that isn't garbage or money.

The icon is also adorable

The only downside is a bit of classic FOSS UI clunk. Not nearly as rediculous as Eclipse or Blender or the like, but it takes a few days to get comfortable.

Re: Dbeaver – Multi-platform database tool

#115

Post by ChristianGeek » Fri, Jan 18, 2019, 5:57 AM UTC

krick wrote: post #36

genieyclo wrote: post #11

Earlier quoted context omitted.

DataGrip:DBeaver::IntelliJ:Eclipse

Not sure what you are trying to say.

DataGrip is to DBeaver what IntelliJ is to Eclipse.

Re: Dbeaver – Multi-platform database tool

#116

Post by emmelaich » Fri, Jan 18, 2019, 6:04 AM UTC

Dbeaver is great.

If you like a cli tool, http://henplus.sourceforge.net/ is ok and easy to modify if you feel inclined.

It's written in Jython and used jdbc.

There is a version with line-editing around using jline.

Re: Dbeaver – Multi-platform database tool

#117

Post by sixdimensional » Fri, Jan 18, 2019, 6:12 AM UTC

crawrey wrote: post #105

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.

DataGrip is great. My previous workplace used to be locked into the Microsoft ecosystem and the core legacy product was backed onto a Microsoft SQL Server DB. Over the years we pushed the business to move away from the MS/Windows ecosystem. When this happened, like many others, I looked for a UNIX compatible DB client that supported SQL Server. First, I tried SQuirreL[1] and it was horrible. I just had to uninstall i…

I paid for and use Navicat and it has always been stable, fast and good. A little pricey as you say, but good.

Re: Dbeaver – Multi-platform database tool

#118

Post by sixdimensional » Fri, Jan 18, 2019, 6:14 AM UTC

JimmyL wrote: post #78

I've had better experiences with DataGrip, but if I wasn't at a place that would pay for proper tools, DBeaver is an OK substitute. Neither, though, have the big thing I want in an analytical SQL workspace: Simple charts A whole lot of my work ends up with a three- or four-column table with one column of buckets, and the other being counts of how many things ended up in that bucket. I'd love a view where I could rend…

Have a look at Metabase. It's open source, web based and runs from a single JAR. Not the same as a full fledged management tool of course, but I like it for simple queries and charts and the price!

DbVisualizer also has built in charts that are simple but... not free/open source.

Re: Dbeaver – Multi-platform database tool

#119

Post by sixdimensional » Fri, Jan 18, 2019, 6:16 AM UTC

sixdimensional wrote: post #118

JimmyL wrote: post #78

I've had better experiences with DataGrip, but if I wasn't at a place that would pay for proper tools, DBeaver is an OK substitute. Neither, though, have the big thing I want in an analytical SQL workspace: Simple charts A whole lot of my work ends up with a three- or four-column table with one column of buckets, and the other being counts of how many things ended up in that bucket. I'd love a view where I could rend…

Have a look at Metabase. It's open source, web based and runs from a single JAR. Not the same as a full fledged management tool of course, but I like it for simple queries and charts and the price! DbVisualizer also has built in charts that are simple but... not free/open source.

Or if you don't mind the web based approach, Apache Zeppelin too.

Re: Dbeaver – Multi-platform database tool

#120

Post by sixdimensional » Fri, Jan 18, 2019, 6:17 AM UTC

zmmmmm wrote: post #79

eyeball wrote: post #53

My company's IT team won't allow install of non-approved tools. I'm stuck with oracle sql developer. fml.

Pretty sure if it's java based you can download it and run it entirely in user space if that is OK. Of course, making an end run around IT policy isn't always an advisable solution even if it does work.

Yup, I am in the same boat and DBeaver works great just running standalone even without admin rights.