DBeaver - универсальный менеджер баз данных

[drinkin]

DBeaver

скриншоты:

DBeaver - универсальный бесплатный менеджер баз данных с открытым исходным кодом. Программа позволяет совершать над базами данных ряд основных действий, таких как создание таблиц, редактирование и экспортирование информации, генерирование скриптов, печать данных, а также создание и запуск различных SQL-запросов. Среди возможностей программы следует отметить: просмотр и редактирование метаданных (таблиц, колонок, ключей, индексов), выполнение SQL запросов и скриптов, визуальная разметка SQL (отличается для разных движков баз данных), автозавершение и гиперссылки в метаданных в редакторе SQL, редактирование результирующих таблиц, поддержка BLOB/CLOB (режимы просмотра и редактирования), скроллинг в наборах ResultSet, экспорт данных (таблицы, результаты запросов), управление подключениями, поиск по объектам баз данных (таблицам, колонкам, процедурам), ER-диаграмы, закладки в объектах баз данных, управление SQL скриптами, работа с проектами (соединения, SQL-скрипты и закладки) и многое другое. Также следует отметить, что DBeaver использует меньше оперативной памяти, чем конкуренты (SQuirreL, DBVisualizer). Метаданные БД загружаются только по мере необходимости — RAM не забивается неиспользуемыми данными. Очень быстро работает просмотрщик ResultSet, также использующий минимум оперативной памяти. Все операции с удаленными БД производятся в «не блокируемом» режиме — DBeaver не зависает при отсутствии ответа от сервера и при выполнении параллельных сетевых задач. Программа кроссплатформена, имеется портативная версия.

Поддерживаемые базы данных:

• MySQL
• Oracle
• PostgreSQL
• IBM DB2
• Microsoft SQL Server
• Sybase
• ODBC
• Java DB (Derby)
• Firebird (Interbase)
• HSQLDB
• SQLite
• Mimer
• H2
• IBM Informix
• SAP MAX DB
• Cache
• Ingres
• Linter
• Teradata
• Vertica
• а также любые базы данных, работающих с драйвером JDBC.

Разработчик: JKISS project
Лицензия: Free (Open Source)
Системные требования: Java 1.6 или выше
ОС: Windows XP, 7, 8 | Linux (Ubuntu) | Mac OS X
Интерфейс: многоязычный, в т.ч. русский

Страница загрузки | Возможности | Скриншоты | История

[drinkin]

DBeaver 2.3.8

Изменения:

February 25th, 2014

• SQLite driver has been fixed
• DB2 metadata read was fixed
• Generic driver metadata read was improved
• Data export was improved (SQL format)
• Result set navigation was improved

32-bit: Инсталлятор (21,76 Мб) | Портативная версия (36,03 Мб)

64-bit: Инсталлятор (22,66 Мб) | Портативная версия (36,03 Мб)

[drinkin]

DBeaver 2.4.2

Изменения:

DBeaver 2.4.2 (June 17th, 2014)

• JRE 7 is now default Java version for DBeaver (however DBeaver still works under Java 6). Windows installer now contains JRE 7 (update 60).
• Database selection toolbar was fixed
• Auto-completion was improved (duplicated objects removed)
• DDL generation was fixed (Vertica and Sybase)
• A few minor bugfixes of UI improvements

DBeaver 2.4.1 (May 20th, 2014)

• Results scrolling was fixed
• DB2 tables edit was fixed (RID_BIT problem)
• SQLite driver configuration fixed (stable driver version used by default)
• SQL editor opening error fixed

DBeaver 2.4.0 (April 29th, 2014)

• Foreign keys navigation added
  
• Structured and collection types support added
  
  
  
• Results viewer improved
• A lot of minor bugfixes and improvements

32-bit: Инсталлятор (22,14 Мб) | Портативная версия (36,26 Мб)

64-bit: Инсталлятор (22,87 Мб) | Портативная версия (36,27 Мб)

[drinkin]

DBeaver 2.4.3

Изменения:

July 18th, 2014

• Table constrains reading fixed
• SSH tunnel instantiation fixed
• Editors reopen fixed
• Data grid UI improved
• Data grid toolbar fixed
• jTDS driver updated
• SSL for MySQL (alpha version)
• Generic driver now splits tables and views
• Oracle XML type support improved
• ERD diagrams made IDEF1X compatible
• Many minor UI fixes

32-bit: Инсталлятор (22,15 Мб) | Портативная версия (36,29 Мб)

64-bit: Инсталлятор (22,89 Мб) | Портативная версия (36,30 Мб)

[drinkin]

DBeaver 3.0.0

Изменения:

August 26th, 2014

We have split standalone version on Community and Enterprise editions.
Community edition includes the same extensions as DBeaver 2.x.
Enterprise edition = Community edition + NoSQL support (Cassandra and MongoDB in 3.0).
Both Community and Enterprise editions are free and open source. New Cassandra and MongoDB extensions are not open source (but free to use).

Eclipse plugin version includes only Community edition plugins.
Standalone version is now based on Eclipse 4.4 (Luna).
Java7 is now default JRE for DBeaver.
And many bugfixes and minor UI improvements were added as usually.

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (22,06 Мб) | Портативная версия (35,44 Мб)

64-bit: Инсталлятор (22,79 Мб) | Портативная версия (35,44 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,28 Мб) | Портативная версия (42,95 Мб)

64-bit: Инсталлятор (25,02 Мб) | Портативная версия (42,95 Мб)

[drinkin]

DBeaver 3.0.1

Изменения:

• Firebird and PostgreSQL extensions were added (views and procedures definition view now supported)
• MongoDB secured connections support was added
• Indexes information read was fixed
• SQL editor was fixed
• Oracle metadata read was fixed
• Data transfer wizard configuration was fixed

Note: DBeaver now depends on Java7. Windows installers already contains appropriate JRE.
If you are on *nix/MacOS please make sure you have Java 7 or later.

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (22,06 Мб) | Портативная версия (35,46 Мб)

64-bit: Инсталлятор (22,79 Мб) | Портативная версия (35,45 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,29 Мб) | Портативная версия (42,97 Мб)

64-bit: Инсталлятор (25,02 Мб) | Портативная версия (42,97 Мб)

[drinkin]

DBeaver 3.0.2

Изменения:

• We rolled back to Java 6
• Custom queries results are now editable
• SQL parser/formatter was improved
• SSH tunnel connection timeout was added
• Many minor bugfixes and improvements

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (22,07 Мб) | Портативная версия (35,46 Мб)

64-bit: Инсталлятор (22,79 Мб) | Портативная версия (35,46 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,29 Мб) | Портативная версия (42,97 Мб)

64-bit: Инсталлятор (25,02 Мб) | Портативная версия (42,97 Мб)

[drinkin]

DBeaver 3.1.1

Изменения:

• Full-text database search feature added
• SQL queries parser was fixed
• DBeaver perspective and initial windows layout were improved
• SQL hyperlinks and object navigation now supports fully-qualified names
• Data export (in isolated connection) has been fixed
• Primary keys/indexes read has been fixed (MSS SQL, DB2 z/OS, and SQLite)
• Resultset navigation has been fixed (now it keeps filter settings)
• Many other minor UI fixes

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (22,08 Мб) | Портативная версия (35,50 Мб)

64-bit: Инсталлятор (22,80 Мб) | Портативная версия (35,50 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,30 Мб) | Портативная версия (43,02 Мб)

64-bit: Инсталлятор (25,03 Мб) | Портативная версия (43,02 Мб)

[drinkin]

DBeaver 3.1.2

Изменения:

January 13th, 2015

• Cassandra 2.1.x support was added
• Apache Derby driver was updated
• ResultSet scrolling bug was fixed
• Data export wizard was fixed
• DB2 execution plan was fixed
• SQL editor execution log was fixed

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (22,07 Мб) | Портативная версия (35,50 Мб)

64-bit: Инсталлятор (22,80 Мб) | Портативная версия (35,50 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,20 Мб) | Портативная версия (43,47 Мб)

64-bit: Инсталлятор (24,93 Мб) | Портативная версия (43,47 Мб)

[drinkin]

DBeaver 3.1.5

Изменения:

DBeaver 3.1.3 - February 9th, 2015

• Dark theme support was added
  i
• Resultset scrolling was fixed
• Multiple results fetch (SQL Server, Sybase) was fixed
• Driver tree was redesigned
• SSH tunnel private key passphrase support was added
• JDBC driver class discovery was improved
• Schema filter was fixed
• Table/column creation was fixed
• NULL values insert was fixed
• Datasource configuration save was fixed
• H2 driver was updated
• Many minor UI problems were fixed

DBeaver 3.1.4 - February 16th, 2015

• Eclipse plugin version now works for older Eclipse versions
• SSH auth was fixed
• SSH logging was added
• Max rows issue was fixed (MS SQL)
• MS Access driver was fixed
• Results control toolbar was fixed

DBeaver 3.1.5 - February 24th, 2015

• Eclipse plugin update site was fixed
• Parameters binding dialog was fixed
• Data export was fixed (by-segment reading)
• Data types load fix (PostgreSQL)
• Copy/paste in resultset was fixed
• SQL autocomplete was fixed
• Scripts titles are now configurable
• A few minor UI bug was fixed

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (21,94 Мб) | Портативная версия (35,60 Мб)

64-bit: Инсталлятор (22,68 Мб) | Портативная версия (35,60 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,08 Мб) | Портативная версия (43,57 Мб)

64-bit: Инсталлятор (24,81 Мб) | Портативная версия (43,57 Мб)

[drinkin]

DBeaver 3.2.0

Изменения:

March 11th, 2015

• Data transfer wizard UI improved
• Cross-database data transfer fixed + performance significantly improved
• Object editor UI changed
• Many minor UI improvements and bugfixes
• MongoDB extension (EE version):
  • Support of JavaScript expressions/queries in SQL editor
  • Multi-db authentication support
  • Create/delete collections/databases
  • Server functions (JS) and users view
    

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (21,94 Мб) | Портативная версия (35,60 Мб)

64-bit: Инсталлятор (22,68 Мб) | Портативная версия (35,60 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,09 Мб) | Портативная версия (43,60 Мб)

64-bit: Инсталлятор (24,82 Мб) | Портативная версия (43,60 Мб)

[drinkin]

DBeaver 3.4.0

Изменения:

DBeaver 3.4.0 (May 17th, 2015)

• Informix database extension was added (thanks to Bert Herngreen)
• Resultset scrolling UI was fixed. Auto-fetch of results next page if now configurable.
• Date/time editor was redesigned + nanoseconds support added
• Custom SQL delimiter support was added
• Complex SQL (DDL) execution was improved
• Association rendering in ERD was fixed
• Vertica extension was fixed (results scrolling support)
• Many minor UI bugfixes
• Licensing was made consistent (GPL2)
• EE version branding was fixed

DBeaver 3.3.2 (April 22nd, 2015)

• Driver license accept is now required
• SQL parameters binding dialog was fixed
• Error dialog was fixed
• Added drivers configuration for NuoDB, GemfireXD, ExaSol
• SQL formatter was fixed
• Data transfer DDL generator was fixed
• Data transfer performance was improved
• LIMIT clause usage was fixed + SQL limit configuration was added
• ERD UI fixes
• Document renderer (JSON) was improved (MongoDB)
• UI freeze on disconnect was fixed

DBeaver 3.3.1 (April 12th, 2015)

• Results viewer UI was fixed and improved
• Plaintext results viewer was fixed (columns width, scrolling, etc)
• Dark theme support was improved
• Single entity diagrams (ERD) were improved (show more connections)
• Hex editor UI was fixed
• GTK: context menus was fixed
• GTK: UI freeze in cell editors was fixed
• Vertica extension was added (views and procedure source code)
• SQL Server & Vertica: big resultsets reading was fixed
• PostgreSQL procedures source code viewer was improved
• DB2: nanoseconds support in date/time data types was added
• Cassandra: BLOBs columns reading was fixed
• MongoDB: JSON & XML viewer added
• Many minor UI fixes

DBeaver 3.3.0 (March 30th, 2015)

• Plain text results presentation added
• Results viewer redesigned
• DB2: metadata fixes (indexes, functions, table DDL, keywords)
• SQL Server: extension added (views definition and procedures source code now available)
• PostgreSQL: explain plan support added
• SQLite: driver version update
• CSV-JDBC: driver version update
• SQL autocomplete fixed
• SQL parser improved
• Data transfer fixed (column types auto-cast added)
• Results navigation fixed (keep filter values after navigation)
• Mongo DB:
  • Connection invalidate
  • Data type management improved
• Cassandra:
  • Cassandra Thrift is now obsolete. Legacy (0.x-1.x) Cassandra extension removed from DBeaver
  • Map, set and list types support added
  • Data type management improved
  • Tables autocomplete added
  • UUID type handler fixed

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (21,98 Мб) | Портативная версия (35,71 Мб)

64-bit: Инсталлятор (22,71 Мб) | Портативная версия (35,71 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (23,94 Мб) | Портативная версия (42,66 Мб)

64-bit: Инсталлятор (24,66 Мб) | Портативная версия (42,66 Мб)

[drinkin]

DBeaver 3.4.4

Изменения:

DBeaver 3.4.4 (July 27th, 2015)

• Oracle: metadata loading performance improved (12g)
• SQLite: driver updated
• SQLite: foreign keys loading fixed
• PostgreSQL: sequences support added
• Firebird: sequences support added
• MySQL: columns extra info added (ON UPDATE, etc)
• DB2: INOUT parameters support fixed
• BIT/TINYINT and LONGVARCHAR types support fixed
• Date/time value editor improved
• BLOB/CLOB editors fixed
• CLOB values cache support added (+configuration)
• GoTo database objects dialog was fixed
• Find/Replace dialog in results was fixed
• SQL editor: parenthesis matching fixed
• Results cell value editor fixed and improved
• DDL generation improved
• SQL parameters handle fixed (+configuration)
• Transactions management fixed
• Query manager fixed (updated row count si now correct)
• UI freeze problems fixed
• Document editor support added for MongoDB JSON documents and Oracle XML tables
• A LOT of minor UI bugs was fixed
  
  

DBeaver 3.4.2 (June 29th, 2015)

• Stored procedures support was added in SQL Editor
• Connections wizard and driver editor were improved
• Bootstrap SQL queries config was added
• Embedded databases support was improved
• Possibility to disable editors reopen was added
• Keyboard shortcuts were fixed
• DB2 table names escaping was added
• DB2 read-only connection was fixed
• LOB export was fixed
• Multi-connection initialization was fixed (auto-commit, transactions isolation level, current schema)
• Cassandra multi-connection issue fixed
• Persistent Query Manager history was added (no UI yet)
• Many other minor UI fixes

DBeaver 3.4.1 (June 3rd, 2015)

• Now DBeaver can create separate connections for each SQL editor (configurable)
• Connection invalidate improved
• Plain text presentation was fixed
• Date/time editor was fixed
• Many minor UI bugs were fixed

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (22,02 Мб) | Портативная версия (35,81 Мб)

64-bit: Инсталлятор (22,75 Мб) | Портативная версия (35,81 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (24,36 Мб) | Портативная версия (43,99 Мб)

64-bit: Инсталлятор (25,09 Мб) | Портативная версия (43,99 Мб)

[drinkin]

DBeaver 3.5.1

Изменения:

DBeaver 3.5.1 (2015-10-05)

• Table columns rename feature added (MySQL, DB2, Oracle)
• Possibility to create embedded database added (Derby, H2)
• Templates assistant feature added (Shift+Tab)
• Launcher icons fixed
• MS Access driver updated
• Informix driver updated
• Multiple config fixes support fixes
• Export of MySQL routines added
• Multiple resultsets support added to DB2
• Decimal columns handling fixed
• Stored procedures/packages loading fixed (UI freeze fixed)
• Maven artifact version resolve fixed (exclude alpha/beta versions)
• DBeaver now depends on Java 1.7
• A few UI fixes

DBeaver 3.5.0 (2015-09-27)

• Driver manager and driver download dialogs were redesigned and improved.
• Connection wizard was improved. Driver settings button added.
• DBeaver now uses Maven repositories to download JDBC drivers.
• Support of Maven artifacts was added to driver editor dialog.
• Oracle and DB2 JDBC drivers were removed from DBeaver distribution. Now they have to be downloaded manually (due to license restrictions).
• Data formatter was fixed (problem with cached configuration).
• Export to SQL INSERTs was fixed (quotes).
• Multiple connections configuration files support added (DBeaver loads all config files matching .dbeaver-data-sources*.xml).
• Many minor UI fixes.
• Base platform was changed to Eclipse 4.5 (Mars). A few UI bugs in standalone version were fixed with this migration.
• DBeaver migrated to Tycho build system instead of Ant headless builds.

DBeaver 3.4.5 (2015-08-24)

• Apache Derby extension was added (view source, sequences, etc)
• SQL editor now scrolls to error position (Oracle, MySQL, PostgreSQL, Firebird, Derby)
• Output messages were fixed (MSSQL)
• Sequences were fixed (PostgreSQL)
• MongoDB 3.x support added
• Preference pages were redesigned
• Plaintext results presentation configuration was added
• Eclipse 4.5 (Mars) support added for plugin version
• CSV export config improved
• ERD export in GraphML format was added
• A few hanging/UI freeze problems were fixed
• Misc UI bugs were fixed

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (19,43 Мб) | Портативная версия (31,10 Мб)

64-bit: Инсталлятор (20,17 Мб) | Портативная версия (31,09 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (20,95 Мб) | Портативная версия (37,76 Мб)

64-bit: Инсталлятор (21,68 Мб) | Портативная версия (37,75 Мб)

[drinkin]

DBeaver 3.5.4

Изменения:

3.5.4 (2015-11-16)

• New objects creation was fixed
• Foreign key navigation (back/forward) was fixed
• Paste in property editor (inline) was fixed
• MySQL: connection dialog fixed
• DB2: MQT indexes support was added
• PostgreSQL: date time support was fixed
• Firebird: procedures/views DDL was fixed
• Oracle: block statements (begin .. end) execute was fixed
• CLOB/text columns edit was fixed
• Query manager: queries now formatted with parameter values
• RPM package fixed (Fedora 20+ format)
• Editors UI was improved (icons)
• Keyboard shortcuts fixes

3.5.3 (2015-11-09)

• Drivers download UI was fixed.
• Linux: RPM installer has been added, DEB installer has been fixed (version update).
• Macos: DMG archive has been added.
• Windows: installer has been fixed (version update).
• PostgreSQL: inline editor fixed. Custom SQL queries results are now editable. Native data types loading was fixed.
• Oracle: metadata reading performance was improved. IOT support added.
• Oracle structures edit support fixed. XML edit support fixed.
• Data export: column name quoting added for SQL INSERTS format.
• Query manager UI improved (SQL formatting).
• Properties view was fixed.
• Floating-point numbers default format was changed.
• Metadata read/edit: a few minor fixes.

3.5.2 (2015-10-26)

• Drivers download UI was fixed
• Checkbox editor UI was fixed (MacOS)
• JDBC drivers (Maven artifacts) dependencies resolution added
• Windows installer was fixed (libraries unpacking error)
• Data export: JSON format support was added
• Solaris (x86) version is back in business
• Table/columns alter fixed (column NULL/NOT NULL and DEFAULT modifiers)
• SQL editor: hyperlinks resolution was fixed
• SQL editor: active query extraction was fixed (multiline comments support)
• SQL scripts creation (in a folder) was fixed
• Redundant SQL scripts cleanup was added
• MySQL comments handling was fixed (escaping)
• MS Access (UCanAccess) driver updated
• Firebird driver updated
• Apache Hive driver was added
• Apache Drill driver was added
• Drivers icons added
• Program icon fixed (Linux)
• DBeaver sources moved to GitHub

Community Edition - включает те же расширения, что и DBeaver 2.x.

32-bit: Инсталлятор (19,44 Мб) | Портативная версия (31,19 Мб)

64-bit: Инсталлятор (20,18 Мб) | Портативная версия (31,19 Мб)

Enterprise Edition = Community edition + поддержка NoSQL (Cassandra и MongoDB)

32-bit: Инсталлятор (21,08 Мб) | Портативная версия (38,22 Мб)

64-bit: Инсталлятор (21,81 Мб) | Портативная версия (38,22 Мб)