Awesome Universal Database Tool for multiple tables, scripts, triggers...

DBeaver

DBeaver

  -  117 MB  -  Open Source
  • Latest Version

    DBeaver 24.1.3 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64

  • User Rating

    Click to vote
  • Author / Product

    DBeaver Corp / External Link

  • Filename

    dbeaver-ce-24.1.3-x86_64-setup.exe

DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators, and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.

DBeaver is a free and open-source universal database tool for developers and database administrators.
  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is free and open-source (ASL).
  • It is multiplatform.
  • It is based on an opensource framework and allows writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external data source which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis, InfluxDB in version 5.x) and different database management utilities (e.g. ERD, data transfer, compare, data export/import, mock data generation, etc).
What`s new:
  • Database navigator
  • Create an object menu was improved (no redundant sub-menu)
  • Connection folders creation was fixed
  • Elements coloring was improved (for different connection types)
  • Shortcuts processing was fixed (broken shortcuts after some actions)
  • Table editor tabs activation was fixed
  • Columns Editor: auto-completion was fixed in drop-downs.
  • Data transfer: export from multiple queries was fixed (target file names)
  • SQL Editor: SQL formatter was fixed (exp numbers and other minor fixes)
  • Spatial data editor:
  • Geography/geometry value editor (plaintext, WKT)
  • Numerous fixes in different SRIDs support
  • Oracle: metadata (constraints, foreign keys) reading performance was significantly improved
  • PostgreSQL:
  • Multiple query result sets support was added
  • Table partitions information was extended
  • Native database backup was fixed
  • Database creation was fixed (special characters in db name)
  • Sequence rename was fixed
  • Full schema DDL generation was fixed
  • Greenplum, Redshift: execution plan explain now supports plaintext format
  • SQLite: sample database was updated
  • Sybase (12 and older): stored procedures source reading was fixed
  • Apache Ignite: identifiers quoting was fixed
  • DB2 iSeries: schema reading was fixed
  • Extra command line parameters (connection opening)
  • Connections import from SQL Developer was fixed
  • Windows installer: config files (dbeaver.ini) backup
  • Extensions (Office, SVG, etc) installer was fixed
  • Checking for multiple DBeaver instances was added
Note: Requires Java Runtime Environment.

Also Available: Download DBeaver for Mac

  • DBeaver 24.1.3 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    DBeaver 24.1.3 Screenshot 1
  • DBeaver 24.1.3 Screenshot 2
  • DBeaver 24.1.3 Screenshot 3
  • DBeaver 24.1.3 Screenshot 4
  • DBeaver 24.1.3 Screenshot 5

What's new in this version:

SQL Editor:
- Added ability to disconnect from the datasourse when all associated editors were closed (configurable)
- New autocompletion engine was significantly enhanced
- Autocompletion for derived columns in sub-queries was improved
- Autocomplete suggestions inside literals in INSERT INTO were disabled
- Execution of the corrected SQL script was fixed
- 'Recent SQL script' was renamed to the 'Last edited SQL script'
- Short/long object names completion configuration was redesigned
- Metadata editor: Composite data types presentation was added for table columns
- Data editor: JSON and XML panels performance was enhanced

Data transfer:
- Compress option behavior was fixed
- Wizard window auto-size was fixed
- Task management: Broken exported file extension after the task editing was fixed
- Dashboards: Project dashboard UX was improved

Connectivity:
- Connections invalidation after sleep mode was added
- Idle connections timeout was fixed

General:
- Establishing connection visualization was added to Database Navigator and Projects
- Tooltip delay on macOS was reduced and became configurable
- Saving script outside the Script folder was fixed
- SVG extension was moved to the PRO version
- Authentication in embedded browser was temporarily disabled on Linux

Databases:
Altibase:
- Added the ability to compile procedure, function, or package from the UI as well as truncate table and refresh materialized view
- Added status of the view, materialized view, procedure, function, or package
- Execution plan parsing error was fixed

Clickhouse:
- DateTime32 formatting was fixed
- IPV6 data presentation was added
- Complex structure display in the Data grid was fixed

CUBRID:
- View creation was added to the UI
- Supported keywords for SQL Editor were reviewed and updated
- Ability to edit Serial using UI was added
- DuckDB: Data edit was fixed
- Microsoft Azure driver was updated to version 12.7.0
- Oracle: DDL generation for Oracle Tablespaces was added

PostgreSQL:
- Specific functions were supported in the SQL Editor
- Metadata read was fixed

Redshift:
- Metadata reading for indexes was disabled
- Problems with broken connection were resolved
- SAP IQ: Duplicated output messages were fixed
- Teradata: Database name became optional for connection
- Vertica: Incorrect query execution with the cursor at the end was fixed

Localization:
- Italian localization was updated