Dbeaver

Dbeaver is a free multi-platform database administration tool. For more information about features, see the official homepage.

It supports popular databases such as MySQL, MariaDB, PostgreSQL, SQLite, Oracle Database.

It provides a plugin architecture (based on Eclipse plugins architecture) that allows to modify much of the application behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

Installation

Install the dbeaver package.

There are also some plugins available:

• dbeaver-plugin-apache-poi - DBeaver library for Microsoft Office documents
• dbeaver-plugin-batik - DBeaver library for SVG format
• dbeaver-plugin-office - DBeaver plugin to export data to Microsoft Office format
• dbeaver-plugin-svg-format - DBeaver plugin to save diagrams in SVG format

Troubleshooting

If you are getting an error like this:

 JVM terminated. Exit code=1
 /bin/java
 -XX:+IgnoreUnrecognizedVMOptions
 -Xms64m
 -Xmx1024m
 -jar /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
 -os linux
 -ws gtk
 -arch x86_64
 -showsplash
 -launcher /usr/lib/dbeaver/dbeaver
 -name Dbeaver
 --launcher.library /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.551.v20171108-1834/eclipse_1630.so
 -startup /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
 --launcher.overrideVmargs
 -exitdata 5b000e
 -vm /bin/java
 -vmargs
 -XX:+IgnoreUnrecognizedVMOptions
 -Xms64m
 -Xmx1024m
 -jar /usr/lib/dbeaver//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar

Try adding export _JAVA_OPTIONS="-Dswing.defaultlaf=com.sun.java.swing.plaf.gtk.GTKLookAndFeel" to your xinitrc.

DBeaver file location

The location of the DBeaver configuration files are located ~/.local/share/DbeaverData

Java version

DBeaver needs a jre >= 11.

If you get an error message starting like this:

!ENTRY org.eclipse.compare 4 0 2021-02-25 11:11:08.257
!MESSAGE FrameworkEvent ERROR
!STACK 0
org.osgi.framework.BundleException: Could not resolve module: org.eclipse.compare [27]
   Unresolved requirement: Require-Bundle: org.eclipse.ui.navigator; bundle-version="[3.2.0,4.0.0)"; resolution:="optional"

This means that your jre version is outdated. You can fix it by installing a newer jre version and changing the default java on your system with archlinux-java. For example:

# archlinux-java set java-11-openjdk

GUI elements too big or filled with black rectangles

For HiDPI screens, GUI elements of Dbeaver might appear too big and certain parts of the interface might be filled with black rectangles.

This can be fixed by setting the following environment variables:

 env GDK_SCALE=2 GDK_DPI_SCALE=0.5

Obviously the optimal values depend on the resolution of the screen, so a bit of trial and error might be needed. See HiDPI for more information.