Database work

I’ve been working a lot with various databases lately and think I’ve found at least one tool that I have been missing. I just ran across the DBeaver webside and their Github Repository.

I pulled the code down and built it using maven. Although I didn’t have to build it, there are references to pre-built packages on the web site for the two major platforms (as well as Windows!).

I have not investigated the full extent of the tool but I really do appreciate that it has a database driver mechanism that enables me to specify any maven driver package and fire up connections to whatever database driver and URL are needed. In my specific case, I am testing a database and as well as the connection mechanisms. So it was very nice to be able to provide my own jar.

For example, With a little bit of adjustment, I was able to connect to the foodmart database by configuring DBeaver to reference the maven repositories for both the hsqldb driver jar and the foodmart data jar.

And just to give you an idea of the sql editing enviroment, here’s an example sql editor query.

List of database connections

There are around 70 database connection types available to choose from. There are a few that I didn’t expect to see and I’ll have to circle back around to see what they really do. For example, I’m curious to see what the editing environment for neo4j provides…

All for now.. got stuff to accomplish!