DBeaver is a software solution for developers, analysts and database administrators that have to manage different types of databases. It provides support for lots of popular databases such as MS Access, Oracle, DB2, SQL Server, MySQL, PostgreSQL, Teradata, or Firebird.
The app has a standard interface, comprised of a main menu tab, a toolbar with various options, a side panel, and the main display area. There aren't many visual customizations, but the navigation through the menu is straightforward. At times, the buttons feel unresponsive and the toolbar icons could've been more intuitive.
DBeaver supports any database that has a JDBC driver, but it's also capable of handling external datasource that doesn't have a JDBC driver.
It has a built-in Database Object Editor that can be used in multiple databases, to various jobs, like editing tables, views and schemas.
Moreover, it comes with Entity Relation Diagrams that allows users to view the diagrams of existing tables and whole database schemas.
To summarize, DBeaver is a friendly application to use, either you're a proffessional or a beginner. It's free, it supports multiple platforms, so it can be used in various projects.
v21.0 [Mar 1, 2021]
-Connection management:
Automatic ending of idle transactions was added
Network profiles configuration page was fixed
Filters in the connection selector dialog were fixed
-Data transfer:
Possibility to disable foreign keys was added (PostgreSQL, Oracle)
Numeric data types mappings were improved
"Skip all errors" button added in the error dialog
-Metadata editor:
Column delete now checks for dependent objects
Constraint/index create command now available in the columns edit tab
Problem with deleted object dup was fixed
-SQL editor:
Script selector popup panel UIX was improved
Hex constants and scientific numbers formatting was fixed
Columns alias generation was improved
Multi-line comments support was fixed
- Data editor:
Column filter UI was improved (value count column)
Extra configuration was added to SQL script generator
Better support of IE browser in the spatial viewer (GIS)
Virtual columns support (rows add/delete) was fixed
Cells selection was fixed (MacOS)
-Automatic app version upgrade was implemented
-Notification popup rendering in dark theme was fixed
-Perspective customization UI was fixed
-ERD:
Export as image: image cropping problem was fixed
Export in SVG format was improved
Diagram save now forces UTF encoding
Tables coloring was fixed
Show/hide system object option is now respected
Print command enablement was fixed
-PostgreSQL:
PgBouncer support was fixed (problem with prepared statements)
Data types read queries were fixed for older (8.4 and earlier) versions
Role permissions editor was fixed
Infinity timestamp values support was added
Auto-generated columns support was added
Role name DDL was fixed
-Teradata:
Triggers management was added
Views metadata read was fixed
Informix: foreign key DDL was fixed
-Clickhouse:
Table data edit support was added
Tables and indexed create/drop DDL was fixed
-Sybase IQ support (server version detection) was fixed
Vertica: view create/edit was fixed
-Firebird:
Procedure parameters' default value read was fixed
View metadata read was improved
-Data Virtuality driver was added (thanks to @sebcom-gmbh)
Preferences localization was updated
Feature-rich relational database known for its high performance and excellent concurrency
