File dbeaver.spec of Package dbeaver
#
# spec file for package dbeaver
#
# Copyright (c) 2021 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.
# Please submit bugfixes or comments via https://bugs.opensuse.org/
#
Name: dbeaver
Version: 22.3.3
Release: lp153.1.1
Summary: Universal Database Manager
License: GPL-2.0-or-later
Group: Productivity/Databases/Clients
URL: https://dbeaver.io
Source0: https://github.com/serge-rider/dbeaver/releases/download/%{version}/dbeaver-ce-%{version}-linux.gtk.x86_64.tar.gz
#Source1: https://github.com/serge-rider/dbeaver/releases/download/%%{version}/dbeaver-ce-%%{version}-linux.gtk.x86.tar.gz
BuildRequires: fastjar
BuildRequires: fdupes
BuildRequires: update-desktop-files
Requires: java >= 11
%description
DBeaver is free and open source (GPL) 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 freeware.
* It is multiplatform.
* It is based on opensource framework and allows writing of
various extensions (plugins).
* It supports any database having a JDBC driver.
* It may handle any external datasource which may or may
not have a JDBC driver.
* There is a set of plugins for certain databases (MySQL and Oracle in
version 1.x) and different database management utilities (e.g. ERD).
%prep
%ifarch x86_64
%setup -q -T -b0 -n %{name}
%endif
#%%ifarch %%{ix86}
#%%setup -q -T -b1 -n %%{name}
#%%endif
# rpmlintrc
sed -i '/WM_CLASS/d' dbeaver-ce.desktop
sed -i 's|\/usr\/share\/dbeaver-ce|%{_libdir}\/dbeaver|g' dbeaver-ce.desktop
sed -i 's|%{_libdir}\/dbeaver\/dbeaver.png|dbeaver.png|g' dbeaver-ce.desktop
# use jre package
rm -r jre/
%build
%install
install -m 755 -d %{buildroot}%{_bindir}
install -m 755 -d %{buildroot}%{_datadir}
install -m 755 -d %{buildroot}%{_libdir}
install -m 755 -d %{buildroot}%{_libdir}/%{name}
install -m 755 -d %{buildroot}%{_datadir}/applications/
install -m 755 -d %{buildroot}%{_datadir}/pixmaps/
cp -r * %{buildroot}%{_libdir}/%{name}
install -m 0644 dbeaver.png %{buildroot}%{_datadir}/pixmaps/
ln -sf %{_libdir}/%{name}/dbeaver %{buildroot}%{_bindir}/dbeaver
%suse_update_desktop_file -i dbeaver-ce Development Building
%fdupes %{buildroot}%{_libdir}
%files
%license licenses/
%doc readme.txt
%dir %{_libdir}/dbeaver
%{_bindir}/dbeaver
%{_libdir}/dbeaver/*
%{_datadir}/pixmaps/dbeaver.png
%{_datadir}/applications/dbeaver-ce.desktop
%changelog
* Sun Apr 24 2022 ecsos <ecsos@opensuse.org>
- Update to 22.0.3
* Sun Apr 3 2022 ecsos <ecsos@opensuse.org>
- Update to 22.0.2
* Mon Mar 21 2022 ecsos <ecsos@opensuse.org>
- Update to 22.0.1
* Mon Mar 7 2022 ecsos <ecsos@opensuse.org>
- Update to 22.0.0
* Mon Feb 21 2022 ecsos <ecsos@opensuse.org>
- Update to 21.3.5
* Mon Feb 7 2022 ecsos <ecsos@opensuse.org>
- Update to 21.3.4
* Sun Jan 23 2022 ecsos <ecsos@opensuse.org>
- Update to 21.3.3
* Mon Dec 27 2021 ecsos <ecsos@opensuse.org>
- Update to 21.3.2
* Mon Dec 13 2021 ecsos <ecsos@opensuse.org>
- Update to 21.3.1
* Mon Nov 29 2021 ecsos <ecsos@opensuse.org>
- Update to 21.3.0
* Mon Nov 15 2021 ecsos <ecsos@opensuse.org>
- Update to 21.2.5
* Mon Nov 1 2021 ecsos <ecsos@opensuse.org>
- Update to 21.2.4
* Mon Oct 18 2021 ecsos <ecsos@opensuse.org>
- Update to 21.2.3
* SQL editor:
- Schema detection for auto-complete was fixed
- Intelli-sense proposals detection was fixed for queries with variables
* Data editor:
- Dark theme support was improved
- Booleans editor rendering was fixed
* Data transfer:
- Data export now respects columns order and visibility
- Exported files are highlighted in OS file explorer
- XML export/import support between Oracle and PostgreSQL was added
- CSV parser was fixed (unexpected input file read termination)
- CSV export format: column header format configuration was added
- CSV export: quotation of NULL values was fixed
- Import from XML: column mapping was improved
- Additional variables were introduced for target file name pattern
- Redundant table name quotation was fixed
- Output files split option was fixed (problem with extra empty file)
- XLSX format: column values are now trimmed to 32kb
* Navigator:
- Create new connection from JDBC URL command was added
- Database metadata refresh was fixed
* ERD:
- Palette icons were updated
- Dark theme support was improved
* CSV driver: aggregated functions support was fixed
* Exasol: geometry data types support was fixed
* ODBC driver: app crash during database connection was fixed for several drivers
* PostgreSQL:
- Composite data types support was improved
- Database backup wizard UI was fixed
* SQL Server: square brackets escape was fixed
* Command-line support: running app instance detection was fixed
* Booleans view was improved (font weight is now configurable)
* SSL encryption algorithms were replaced by BouncyCastle
* TLS 1.0/1.1 support was fixed
* XML-parser related security issues were fixed
* Base platform was changed to Eclipse 2021-09
* Mon Oct 4 2021 ecsos <ecsos@opensuse.org>
- Update to 21.2.2
* DBeaver for MacOS X for M1/Silicon/ARM was released
* SQL editor:
- Client-side command @include was fixed
- Bug with hanging SQL parser on long queries was fixed
- Auto-completion was fixed for a number of cases
- Schema selector in SQL consoles was fixed
- Statement text extraction was fixed in "block selection" mode
* Data editor:
- Expression parser was fixed in grouping panel
* Navigator: database metadata refresh speed was significantly increased
* Generic drivers: problem with wrong table schema recognition was fixed
* Exasol: extra keywords were added to SQL dialect
* HANA:
- Begin/end blocks parser was fixed
- Alter table syntax was fixed
* Hive: backslash escape support was added
* Netezza:
- Table editor for non-default database was fixed (problem with wrong schema recognition was resolved)
- Import/export to/from non-default database support was added
* PostgreSQL:
- Composite value editor was improved (for composite data types)
- Version 13 support was improved (rare problem with data types metadata read was fixed)
* Redshift:
- Driver 2.x support was fixed (proper data types handle was added)
- Table truncate command was fixed
* Sybase: "Encrypt password" option was added to the connection page
* Teradata: default schema detection was fixed
* Windows installer: default install location was changed to current user
* UI rendering for HighDPI monitors was fixed
* Properties editor UI was fixed (possibility to delete custom property)
* Tables UI was fixed for multiline cells (Linux)
* Bundled Java was upgraded to OpenJDK 11.0.12
* Mon Sep 20 2021 ecsos <ecsos@opensuse.org>
- Update to 21.2.1
* Data viewer:
- Boolean value render configuration was redesigned
- Special format for "time/timestamp with timezone" types was added
- Advanced paste: configuration dialog was added
- Radix transformer was fixed
- Numeric transformer was added
- Geometry data type editor was fixed (Exasol, Oracle)
- Value panel now saves last used content viewer settings
* Data transfer:
- Output settings configurator was fixed
- External process execute was fixed (backslash escape)
- Import from XLSX: column mapping was fixed
- Database dump configuration page was fixed (Mysql, PostgreSQL)
- Data load performance was improved (thanks to @deepaksenthilkumar)
* SSH tunnel: jump server configurator was fixed (port number)
* Windows shortcuts (lnk) resolution was added
* ERD: columns sort support was added
* Confirmation dialog UI was redesigned
* Metadata search:
- Search in object comments configurator was fixed
- Search page was fixed for cross-database search PostgreSQL
* Database session manager refresh was fixed
* DB2: columns, procedures and functions search support was added
* Firebird: calculated fields support was added
* Greenplum: table DDL was fixed (unique keys)
* H2: procedure aliases support was added
* PostgreSQL:
- Composite data type support was fixed
- UDF parameters support was fixed
- Foreign table comments support was added
* Redshift:
- External table columns metadata read was fixed
- Char data type support was fixed
- Timeout error recovery was added
- Driver version was upgraded to 2.0
- Geometry data types support was improved
* SQL Server: cross database metadata search support was added
* Vertica: metadata search and full-text search support was added
* Linux installers (deb, rpm) were improved. App shortcut links were fixed
* Eclipse 2021-06 is new base platform
* DBeaver now requires Java 11
* MacOS X M1 installer was added (beta)
* Mon Aug 30 2021 ecsos <ecsos@opensuse.org>
- Update to 21.2.0
* Data transfer:
- Value binding mode switcher was added (affects performance)
- Automatic columns mapping was fixed
- Import from files/relational tables into document oriented databases was fixed
- Column length detection was improved
* SSH tunnel: jump server support was added
* Tasks management view: task folders were added
* Navigator: show tables from different schemas in a single list (optional)
* Connection driver settings: problem with non-editable properties was fixed
* Data editor:
- Toolbar commands enablement handler was fixed
- Detached text/binary editor was fixed
- Row coloring: LIKE and REGEX filter value editor was fixed
* SQL editor:
- Extraction of queries from source code on paste: problem with line feeds was fixed
- Multibyte unicode numbers handler was improved (app hang fixed)
- Main windows title now shows proper information about the current editor
* Greenplum: stored procedures auto-completion and navigation was fixed
* PostgreSQL:
- Multi-column foreign keys navigation was fixed
- Auto-completion for quoted identifiers was improved
- Active schema detection was fixed
- Floating point numbers formatting was fixed
* Redshift:
- Data transfer performance was significantly increased (up to x10000)
- Tables and procedures DDL was improved (security definer was added)
- Stored procedures search and auto-completion was fixed
- Timestamp value editor was fixed (in native date formatting mode)
* Snowflake: driver configuration was fixed (JNA dependencies)
* Many minor UI and database-specific bugs were fixed
* Mon Aug 16 2021 ecsos <ecsos@opensuse.org>
- Update to 21.1.5
* ERD editor:
- Properties panel was added for diagram elements
- Diagram drag tool was added
- Entity search UI was improved
- Diagram refresh now asks confirmation
- Table column navigation was fixed
- GraphML export was improved (notes, styles)
- Arrange diagram now respect grid alignment
- Export ERD in XML (.erd) format was added
- Cross-project entity drag-n-drop was restricted
* Data editor:
- Row insert with default values was improved
- Data filter popup now visualizes loading process
- Pin column now works for multiple selected columns
- Filters dialog now supports column pin/unpin
- Auto-complete in grouping panel was fixed
- Plaintext record mode switch was fixed
- Excel import was fixed (NULL cells support was added)
* SQL editor: action buttons tooltips were fixed (keyboard shortcuts)
* SQL Server: user management was added
* Oracle: View triggers read was fixed
* PostgreSQL:
- Additional PostGIS data type support was added
- Connection user role handle was fixed
* Procedure body read now re-established connection on demand
* Shell commands now support quoted parameters (Linux, MacOS)
* Debian/RPM package installers now use different directories for community and commercial versions
* Simple schema compare wizard UI was fixed
* SQL queries which contains passwords were removed from logs
* Driver editor dialog enhancements
* Minor UI bugfixes
* Mon Aug 2 2021 ecsos <ecsos@opensuse.org>
- Update to 21.1.4
* Data transfer:
- Multi-row insert support was added
- Data transfer performance significantly improved
- Unnecessary commit/rollback in source connection were removed
- Table/column name case conversion was fixed
- Ambiguous column name mapping was fixed
* Data viewer:
- Data filter for enum data types was fixed
- Data edit support for queries with joins
- Row insert with default values support was added
- Timestamp value render: timezone configuration was added
- Value transformers: save last transformer configuration
- Cell color highlight add/reset was fixed
- Data refresh was fixed in multi-row record mode
* MySQL:
- TLS 1.0 and 1.1 support added
- User password change was fixed
* PostgreSQL:
- Bit string editor was fixed
- PG 13 backup/restore support was added
- Column rename DDL was fixed
- INSERT queries for OID data types were fixed
- Composite data type edit was fixed
* SQL Server: active schema selector was fixed
* Several minor UI bugs were fixed
* Wed Jul 21 2021 ecsos <ecsos@opensuse.org>
- Update to 21.1.3
* SQL editor:
- Output/Execution Log panels layout was changed
- Variables/parameters management panel was added
- SQL template variables completion was fixed
- Command for assigning query results to variable was added
* Data transfer:
- Custom transformations were added for table column mapping
- Referential integrity disablement was added for MySQL, SQL Server and Exasol
- Column mappings page supports reordering now
- Data export task editor was fixed (task re-configuration support)
- Query based data export task now supports query editing
- Export in HTML format was fixed (extra line breaks)
- Columns auto-assign button behavior was fixed
- Execute process after data transfer supports multiple tables export now
- Mixed case columns auto-mapping was fixed
- Several problems with NullPointerException during editor opening were fixed
* Navigator:
- Open file: last opened folder is saved between app launches
- Object filter: special characters escaping was added
* MySQL:
- Data import performance was significantly improved
* Oracle:
- View indexes reading was fixed
- TNS aliases resolution was improved
- Data export in SQL format was fixed
* PostgreSQL:
- Database backup/restore in custom format was fixed
- Database backup validates output file existence
* Firebird: query execution plan explain was fixed
* Several minor UI bugs were fixed
* Sat Jun 26 2021 ecsos <ecsos@opensuse.org>
- Update to 21.1.1
* Navigator:
- Quick search now supports multiple object names
- Entity editor preferences for active tab configuration were improved
- Object rename dialog was fixed
- Metadata refresh UI was fixed
* Data editor:
- Row coloring now supports LIKE and other operators
- Read-only columns mark was redesigned
- Confirmation dialog was added for column filters
- References panel UI was fixed (rows highlighting)
- Spatial data viewer now remembers selected SRID for particular columns
* Data export:
- special characters escape was fixed in HTML and JSON formats
* SQL editor:
- Problem with active schema reset after connection invalidate was fixed
- Problem with focus lost on query execution was fixed
- Auto-completion for quoted identifiers was fixed
- Embedded SQL editors performance was greatly improved
- Problem with @set command was fixed
- Problem with Find/Replace window and NullPointerException was fixed
- Several problems with hanging UI after complicated SQL execute were fixed
* Greenplum:
- materialized views DDL was fixed
* MySQL:
- foreign key edit support was added
* Oracle:
Table DDL was fixed (missing semicolons)
Timestamp columns editor was fixed
Function-based indexes column read was fixed (duplicated rows removed)
Package loading performance was greatly improved
* PostgreSQL:
- Column data type editor was redesigned
- Infinity timestamps handler was fixed
- Array and interval data types editor was fixed
- Foreign tables DDL was fixed (missing OPTIONS)
- Cross-schema references rendering was fixed
* Redshift:
- Permission editor was added
- Problem with case-sensitive object names was fixed
* SQL Server:
- Cross-schema foreign keys support was fixed
- Detailed triggers metadata read was added
* Teradata:
- triggers and procedures DDL was fixed (extra linefeeds were removed)
* Taiwan localization was added (thanks to @ralic)
* Test connection dialog now shows connection detailed information
* Last workspace location is now restored after DBeaver version upgrade
* Redundant P2 plugins were removed from the standalone version
* TLS 1.0 and TLS 1.1 support configuration was fixed
* Wed Jun 9 2021 ecsos <ecsos@opensuse.org>
- Update to 21.1.0
- Connection recovery was improved. SSH tunnel infinite reopening cycle was fixed
- Data transfer:
- Insert/replace method configuration was fixed
- Cross-database column data type mapping was improved
- Project settings: corrupted folders configuration fix was added
- Legacy status icons were updated
- Application launch time was reduced
- SQL Editor:
- Problem with results tab collapse was fixed
- Dummy NullPointerException and StackOverflowError errors were fixed
- Data editor: LOB viewer shows error dialog on data load errors now
- CLI: reuseWorkspace parameter handler was fixed
- SQL Server:
- Extended properties editor was added
- New row insert for tables with calculated columns was fixed
- Oracle: synonyms search is now configurable
- PostgreSQL:
- User password change feature was added
- Domain arrays support was fixed
- Role DDL now contains permissions information
- Sequences DDL was fixed
- VARBIT data type support was fixed
- Default database switch was fixed
- MySQL: user rename feature was added
- Exasol: schema refresh was fixed
- Informix:
- Table statistics feature was added
- Function parameters read was fixed
- Snowflake: metadata read was fixed for case-sensitive schema names
- BigQuery: driver version was upgraded
- Bundled Java updated to version 11.0.11
- Many minor UI bugs were fixed
- Changes from 21.05
- Navigator:
- Boolean properties editor behavior was redesigned
- Broken shortcuts (F2, F4, etc) in object editor were fixed
- Redundant help icons removed from standard dialogs
- Language change validation and documentation was added
- Quick filter now supports triggers
- SQL Editor:
- Auto-completion was fixed for table aliases, joins and asterisks
- Smart commit now ignores EXPLAIN statements
- Big updated row count (>2gb) support was added
- Output log enable/disable button was added
- Data editor:
- Selected rows highlight was fixed
- Bug with overlapping timestamp and FK values was fixed
- Find/replace dialog now respects number formatting
- ERD viewer: property view support was fixed, entity/attributes context menu was fixed
- PostgreSQL:
- Constraints and indexes support was added
- Problem with constantly growing search_path was fixed
- Fully-qualified table names in foreign keys DDL was fixed
- PGPASS authentication now can be used with empty user name
- NaN and Infinity numbers formatting was fixed
- Data transfer: ON DUPLICATE query generation was fixed
- Database size statistics was added (configurable, off by default)
- CREATE DOMAIN DDL was fixed
- DB2: BEGIN/END blocks support was added
- Greenplum: DDL for replicated tables was fixed
- Oracle:
- Procedure body formattign was fixed (for encoded procedures)
- Procedures/triggers/packages DDL statements processing was fixed
- Redshift: view columns metadata read was fixed, extra data type aliases were added
- Vertica:
- Table columns read was fixed for older Vertica versions
- Sequences support was added
- BigQuery driver version was upgraded
- Eclipse plugin: bug with redundant .dbeaver folders was fixed
- System notifications support was added on Linux
- Jar code sign certificate was updated
- Big number of minor bigfixes
* Fri May 7 2021 ecsos <ecsos@opensuse.org>
- Update to 21.0.4
* Fri Apr 23 2021 ecsos <ecsos@opensuse.org>
- Update to 21.0.3
- Dark theme support was improved (Windows 10 and GTk)
- Data viewer:
- Copy As: format configuration editor was added
- Extra configuration for filter dialog (performance)
- Sort by column as fixed (for small fetch sizes)
- Case-insensitive filters support was added
- Plaintext view now support top/bottom dividers
- Data editor was fixed (when column name conflicts with alias name)
- Duplicate row(s) command was fixed for multiple selected rows
- Edit sub-menu was returned to the context menu
- Columns auto-size configuration was added
- Dictionary viewer was fixed (for read-only connections)
- Current/selected row highlighting support was added (configurable)
- Metadata search now supports search in comments
- GIS/Spatial:
- Map position preserve after tiles change
- Support of geometries with Z and M coordinates was added
- Postgis: DDL for 3D geometry columns was fixed
- Presto + MySQL geometry type support was added
- BigQuery now supports spatial data viewer
- Binary geo json support was improved
- Geometry export was fixed (SRID parameter)
- Tiles definition editor was fixed (multi-line definitions + formatting)
- SQL editor:
- Auto-completion for objects names with spaces inside was fixed
- Database objects hyperlinks rendering was fixed
- SQL Server: MFA (multi-factor authentication) support was added
- PostgreSQL: array data types read was fixed
- Oracle: indexes were added to table DDL
- Vertica: LIMIT clause support was improved
- Athena: extra AWS regions added to connection dialog
- Sybase IQ: server version detection was improved
- SAP ASE: user function loading was fixed
- Informix: cross-database metadata read was fixed
- We migrated to Eclipse 2021-03 platform
- Many minor bug fixes
* Fri Apr 9 2021 ecsos <ecsos@opensuse.org>
- Update to 21.0.2
- SQL Editor:
- Configuration of open editor action was added
- Smart auto-completion of column values was improved
- Problem with ambiguous column name resolution was fixed
- Hyperlinks detection was fixed
- Problems with SQL templates view freeze was fixed
- SQL formatter of case and conditional operators was improved
- Syntax highlighting for single and double quotes was fixed
- SQL folding state is now saved for each script
- Trim spaces command was added
- Problem with double save/commit confirmations was fixed
- Database navigator:
- Quick schema filter was fixed
- Metadata changes save: single transaction processing was improved
- Delete object(s) dialog UI was improved
- Data transfer:
- Export to flat files now supports columns configuration
- BOM support was added to CSV import
- Data viewer:
- BLOB viewer now respects content type of cell value
- Grouping panel: queries with trailing comment now handled properly
- Custom resultset ordering support was fixed
- PostgreSQL:
- Serial data types selector was fixed
- Column default value editor was fixed
- Numeric arrays rendering was fixed (number formatting removed)
- SAP HANA (thanks to @wernerdaehn):
- Smart completion was improved
- Public synonyms read was added
- Metadata object search was redesigned
- SQL Server:
- Default delimiter was changed to ; instead of GO
- Synonyms support was improved
- Check constraints added to table DDL
- Unicode string literals generation was fixed
- Informix: SQL error position detector was added
- Snowflake: active catalog/schema selector was fixed
- DB2 LUW: extra embedded routines support added
- Google Spanner driver configuration was updated
- MariaDB: TIME data type support was fixed
- Vertica: column comments read and update support was added
- Redshift: table permissions read in table DDL was fixed
- APM Jenifer driver configuration was added
- Automatic version upgrade: app restart procedure was improved
- Application icons were updated
* Fri Feb 26 2021 ecsos <ecsos@opensuse.org>
- Update to 7.3.5
* Tue Feb 2 2021 ecsos <ecsos@opensuse.org>
- Update to 7.3.4
* Mon Dec 21 2020 ecsos <ecsos@opensuse.org>
- Update to 7.3.1
* Sun Dec 6 2020 ecsos <ecsos@opensuse.org>
- Update to 7.3.0
* A lot of improvements for MacOS:
- Problem with toggle checkboxes was fixed
- Problems with inline value editors were fixed
- Problem with connection editor open on single click was fixed
- Problem with metadata viewer in BigSur was fixed
* SQL editor:
- Complex SQL queries parser was improved
- Query folding now respects active SQL dialect
- Problem with focus loss after query execute was fixed
* Data transfer:
- Imports from CSV/XLS: date columns support was added
- Export in SQL INSERT format: support of various INSERT/REPLACE/UPSERT dialects was added
- Problem with active schema switch during task execute was fixed
- Export from query: task UI configuration was fixed (active schema select)
* ERD: table copy-paste was fixed
* Project delete now requires confirmation of project files delete
* Command line: connection credentials now can be passed along with connection name/id
* SSH: private key format conversion was improved (Linux)
* SQL INSERT query generator now skips auto-generated columns
* PostgreSQL:
- Table DDL was fixed (serial columns)
- Role members/permissions viewer was fixed
- Permission editor now supports sequences and materialized views
- Bug with partition list read was fixed
* SQLite: table column delete feature was added
* Teradata: active schema selector was added
* Firebird: problem with missing views was fixed. View source editor was fixed
* Exasol: table index create UI was fixed
* SQL Server: index create UI was improved (index type selector)
* Hive: SQL dialect was improved (extra keywords)
* MySQL/MariaDB: privileges editor UI was fixed
* Oracle:
- PL/SQL parser was significantly improved
- View DDL read was fixed
- Session manager now supports Oracle 9 and 8
* BigQuery:
- Problem with missing resultsets was fixed
- Driver version was upgraded
* HANA: triggers metadata reading was fixed (bug with wrong schema)
* Many minor UI bugs were fixed
* Tue Oct 6 2020 ecsos <ecsos@opensuse.org>
- Update to 7.2.2
* Tue Sep 22 2020 ecsos <ecsos@opensuse.org>
- Update to 7.2.1
* Thu Jul 23 2020 ecsos <ecsos@opensuse.org>
- Update to 7.1.3
* Wed Jul 8 2020 ecsos <ecsos@opensuse.org>
- Update to 7.1.2
* Tue Jun 2 2020 ecsos <ecsos@opensuse.org>
- Update to 7.1.0
* Database navigator:
- Statistics view (table sizes) was added
- Connection coloring was redesigned
- Connection host name tip was added
* Data viewer:
- Ref cursor panel viewer was added
- Columns sort settings save/load was added
- Data export in HTML format was fixed (styles)
* SQL editor:
- Function call formatting was improved
- Table alias generation was fixed (for unicode/numeric table names)
* PostgreSQL:
- Ref cursors refresh support was added
- Table and schema statistics was added
- Table comment and rules were added to DDL
* Oracle:
- Metadata search was fixed
- Java source read was fixed
* ODBC driver download was fixed
* Exasol: metadata edit dialogs were redesigned
* Clickhouse: table statistics was added
* Firebird: view editor was fixed
* Plain HTTP driver repositories (Maven or direct links) were replaced or removed
* Big number of minor UI and database-specific bugs were fixed
* Tue May 19 2020 ecsos <ecsos@opensuse.org>
- Update to 7.0.5
* Thu May 7 2020 ecsos <ecsos@opensuse.org>
- Update to 7.0.4
* Wed Apr 22 2020 ecsos@opensuse.org
- Update to 7.0.3
* Thu Apr 9 2020 ecsos@opensuse.org
- Update to 7.0.2
* Tue Mar 24 2020 ecsos@opensuse.org
- Update to 7.0.1
* Thu Mar 5 2020 ecsos@opensuse.org
- Update to 7.0.0
* Tue Feb 18 2020 ecsos@opensuse.org
- Update to 6.3.5
* Tue Feb 4 2020 ecsos@opensuse.org
- Update to 6.3.4
* Tue Jan 21 2020 ecsos@opensuse.org
- Update to 6.3.3
* Wed Jan 8 2020 ecsos@opensuse.org
- Update to 6.3.2
* Wed Dec 25 2019 ecsos@opensuse.org
- Update to 6.3.1
* Tue Dec 3 2019 ecsos@opensuse.org
- Update to 6.3.0
* Wed Nov 20 2019 ecsos@opensuse.org
- Update to 6.2.5
* Tue Nov 5 2019 ecsos@opensuse.org
- Update to 6.2.4
* Tue Oct 8 2019 ecsos@opensuse.org
- Update to 6.2.2
* Tue Sep 24 2019 ecsos@opensuse.org
- Update to 6.2.1
* Tue Sep 10 2019 ecsos@opensuse.org
- Update to 6.2.0
* Sun Aug 25 2019 ecsos@opensuse.org
- Update to 6.1.5
* Mon Aug 5 2019 ecsos@opensuse.org
- Update to 6.1.4
* Wed Jul 10 2019 ecsos@opensuse.org
- Update to 6.1.2
* Tue Jun 25 2019 ecsos@opensuse.org
- Update to 6.1.1
- We have migrated to Java11 (Windows and MacOS bundled JRE is OpenJDK 11.0.3)
- ERD: diagram refresh fixed (do not re-layout elements)
- ERD: support of zoom with mouse wheel was added
- PostgreSQL: ref cursor data type support was fixed
- Oracle: bootstrap queries execute was fixed
- DB2 for iSeries, DB2 for z/OS: schema list reading was fixed
- SQLite: datetime columns support was fixed
- SAP HANA: triggers support was added (read-only)
- Data views: calc panel was fixed (min/max functions evaluation)
* Tue Jun 11 2019 ecsos@opensuse.org
- Update to 6.1.0
* Data viewer:
- Spreadsheet column-based coloring support was added
- Copy as HTML now uses html clipboard format
- Focus loss bug was fixed (MacOS)
* Data transfer:
- Export to XLSX format: performance was greatly improved
- Table truncate confirmation was added
- Plaintext export was fixed (datetime data types formatting)
* SQL editor:
- SQL execution plan save/load support was added
- Bug with keywords in comments was fixed
- Active connection/schema selectors were fixed in the main/context menus
- Workbench/J formatter was fixed
* ERD diagram: Dark theme support was improved
* Database navigator:
- New object create context menu redesigned
- Duplicated nodes bug was fixed
* Spatial viewer:
- Coordinates inversion was fixed (MySQL)
- Column SRID and coordinates flip settings are now saved between sessions
* Oracle:
- Constraints metadata reading was fixed (fixes table editor as well)
- Indexes DDL reading was added
* PostgreSQL:
- Backup of "quoted" schemas and tables was fixed
- Functions' dependencies information was added
- Struct data types parser was fixed (boolean fields extraction)
* MySQL:
- BEGIN keyword handler was fixed
- View DDL was fixed (extra delimiters)
* SQL Server: drop index qury was fixed
* Eclipse plugin installer was fixed (missed bundles)
* Many minor UI bug fixes
- Changes from 6.0.5
* Database navigator:
- Create 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
* Many minor UI bug fixes
* Mon May 6 2019 ecsos@opensuse.org
- update to 6.0.4
- Data editor:
- Value transformers for custom queries and pseudo columns
- Advanced data coloring configuration
- Logical entity structure editor
- Gradient colors for numerical/datetime columns
- Navigate to FK/references: multiple rows support
- Extra shortcuts were added
- Spatial (GIS) viewer:
- CRS (SRID) transformations support was added
- Inverted coordinates support was added
- Support of geography data type was added
- Support of curved geometries was added
- Open map in browser command
- Maximum geometry objects limitation was added
- Numerous bug fixes (tooltips, actions)
- SQL editor:
- Indentation was fixed (keyword-based indents were disabled)
- Process @set commands in data export
- “Format” context menu was fixed
- Schema selector toolbar was fixed (missing database name)
- Global native clients configuration was added
- Shortcuts for connection/schema selectors were fixed
- PostgreSQL:
- Full schema DDL generation was added
- Function create was fixed (function body)
- Trigger create support was added
- Columns DDL was added
- MySQL: query metadata extraction was fixed (bug with wrong database name)
- Oracle: metadata reading was fixed
- SQL Server:
- Procedures auto-completion was fixed
- Support of older Azure versions was added
- Redshift: external tables (spectrum) data reading was fixed
- Clickhouse additional array data type support was added
- Korean localization was added (thanks to Seongbae Chang)
- Many minor UI bug fixes
- Changes from 6.0.3
- Connection/schema selector toolbar was redesigned
- Create object context menu was redesigned
- Data viewer:
- Panels UI was redesigned
- “Copy As” command was added (CSV, HTML, JSON, etc)
- IN filter UI was improved (previous selection save)
- Statistics view was improved (proper view of multiline queries)
- SQL editor: auto-indent was fixed
- GIS spatial data viewer beta version (PostgreSQL, MySQL/MariaDB):
- Viewer panel was redesigned, special results presentation was added
- Multiple objects viewing support was added
- Copy/save as picture, print, SRID selector
- Data transfer:
- Export progress monitoring was fixed
- Export from custom SQL queries performance was improved (using fetch size)
- Split output file feature was added
- Reset UI settings menu item was added
- Backup/restore wizards: native client configuration was added in the dialog
- MacOS X installer was updated (JRE version update)
- PostgreSQL:
- Schema/tables backup wizard was fixed
- Triggers enable/disable tool was added
- Greenplum: tables reading for GP 4.x was fixed
- SQL Server:
- Use TOP to limit queries fetch size
- Dynamic parameters binding bug was fixed
- Table triggers enable/disable tool was added
- Support of special characters in object names was added
- Oracle:
- New config option for metadata reading performance fix
- Subpartitions browser was added
- PL/SQL blocks parser was improved
- Configuration of system views usage was added
- DDL reading was fixed (problem with string truncate with some driver versions)
- Many minor UI bug fixes
- Changes from 6.0.2
- Eclipse 2019-03 is now the default platform
- Embedded editor activation problem fixed (Linux)
- SQL editor:
- SQL errors now shown in results panel instead of modal dialog (configurable)
- Certain long strings visibility problem was fixed
- Auto completion was fixed for CALL/EXEC keywords
- Tables/schemas were removed from columns proposals
- Context menu was improved (redundant items were removed)
- Numerous NPE errors were fixed
- Multi-statements scripts formatter was improved (adding statement delimiters)
- Database-specific named parameters prefix was added
- SQL formatting was fixed
- Morph delimited list formatter was fixed (spaces in tokens)
- Data editor:
- Unnecessary focus changing was fixed
- Calc panel: strings/numbers aggregation toggle was added
- Data transfer: fetch size was added in export settings (may significantly improve performance)
- ERD (custom diagrams):
- Additional styles were added for notes (colors, transparency, border, font settings)
- Notes now can be connected with entities
- Dashboards:
- Timeseries dashboards rendering was fixed.
- New dashboards extraction model was added (statistics reading by intervals)
- Exasol dashboards were added
- PostgreSQL:
- Alpha version of GIS/spatial data viewer (maps) was added
- Explain for queries with parameters was fixed
- Database description reading was fixed (PG < 9.4)
- Greenplum: tables reading for GP 4.x was fixed
- Oracle:
- Public synonyms in auto-completion
- Session manager now shows instance ID (for clusters)
- MySQL/MariaDB:
- New database dialog now uses server charset/collation defaults
- Native client was updated (problems with dump/restore compatibility)
- MS SQL Server/Azure: driver version was updated, support of AD MSI authentication was added
- Elasticsearch: metadata reading was fixed (schema/table names escaping)
- Pervasive SQL driver configuration was added
- MySQL NDB cluster driver configuration was added
- Google BigQuery driver was updated
- Numerous localization bugs were fixed
- Many minor UI bug fixes
* Wed Mar 27 2019 ecsos@opensuse.org
- update to 6.0.1
- Eclipse 2018-12 is now the default platform
- 32-bit versions were obsoleted
- Charts colors configuration
- Navigator resource folders visibility configuration
- Mock data: new random texts generators were added
- Data editor: inline editor focus handler was fixed
- Plaintext format: show Western European characters
- Data transfer: new connection close fix
- Snowflake: tables and columns comments edit support was added
- Oracle:
- Session manager now tracks global sessions (RAC)
- Procedures/packages save/compile command was fixed
- PostgreSQL:
- Multi-tenant databases support was improved
- Database description reading was added
- MySQL: execution plan build fix
* Tue Feb 5 2019 ecsos@opensuse.org
- update to 5.3.4
* Wed Jan 9 2019 ecsos@opensuse.org
- update to 5.3.2
* Tue Dec 11 2018 ecsos@opensuse.org
- update to 5.3.0
* Tue Nov 20 2018 ecsos@opensuse.org
- update to 5.2.5
* SQL Server (MSSQL) database extension was added:
- Native SQL Server metadata
- Table/columns/indexes/constraints editor
- View/edit objects' comments
* Connection invalidate/reconnect action was redesigned (now forces reconnect always)
* Data viewer:
- Cell rendering was fixed in the plaintext view
- Data save/reject key bindings were fixed
- Support of right align for numbers and dates in plaintext view was added
* SQL editor:
- Tabs management was redesigned (now all tabs are pinnable and closeable)
- SQL completion was significantly improved/fixed
- Additional configuration for SQL formatter
* Object editor:
- Problem with "jumping" focus was fixed
- Links rendering was fixed
- Checkboxes are now grouped together
* Data transfer: problem with multiple tables mappings was fixed
* Read-only connections now restrict metadata edit
* Driver properties editor UI was improved (password properties masking)
* Project explorer UI was fixed (header column sizes)
* PostgreSQL:
- View and functions rename support was added
- PostGIS support improved (now supports creation of new geometry values)
- Data type DDL was added
- Functions DDL was improved (comments)
- JDBC driver default version changed to 42.2.5
* MySQL:
- Multiple/excluding schema filters were fixed
- Presto: table elements reading was fixed (performance)
- DB2 z/OS: driver config was fixed (foreign keys reading)
- A lot of minor UI fixes
- changes from 5.2.4
* Results viewer:
- Ordering confirmation config was fixed (issue with “unsortable” results fixed)
- Toolbars layout was changed
- Grid presentation: columns width stretching (fit screen/value) commands were added
- Plaintext presentation: tabs support was fixed
* SQL editor:
- Associated connection info can be placed in the first line of script (can be shared between different users)
- Unnecessary objects information reading was disabled (completion performance was greatly improved)
- Auto-completion was fixed (identifier replacement)
- Use different syntax for store functions and procedures invocation
- Fix for the “Search inside names” option support
* Object editor:
- Property editor form was redesigned/fixed
- Glitch with jumping cursor fixed
- Grid visibility config was added
* Read-only connections detection was fixed
* Light theme is now default DBeaver theme (instead of Classic)
* Preferences pages were reorganized. SQL scripts processing pref page was added.
* Driver selection page: new design (optional)
* Linked folder/file handling was fixed (do not delete broken links)
* Data transfer wizard: progress monitor was fixed
* Greenplum:
- Functions header/footer was added to DDL
- Table DDL generation was enhanced
* SQL Server: procedure names fixed in auto-completion
* AWS Athena: connection page was fixed
* ORacle: do not use DBA_* views by default
* Mock data generation wizard was improved:
- Possibility to skip columns
- Column generator settings save/load was fixed
- Skip auto-generated columns by default
* Darkest Dark theme support was fixed
* German language localization update (thanks to Bullnados)
* Chinese language localization update (thanks to fengchao)
* Maven configuration was redesigned (now Maven project nature can be used in Eclipse)
* A lot of minor UI fixes
* Wed Oct 24 2018 ecsos@opensuse.org
- update to 5.2.3
* Object (tables, columns, etc) editor was redesigned
* Statistics/misc tab was added to object editors
* Data transfer supports document-oriented databases now
* Table rename procedure is available from the table editor (MySQL, PG, Oracle, DB2)
* Long operations canceling was fixed
* "Tip of the day" popup was added
* Java 11 support was added
* Azure SQL driver was added
* AWS Athena support was significantly improved
* AWS Redshift:
- Spectrum and external tables support was added
- Columns and foreign keys metadata reading was fixed
* Cockroach: foreign keys reading was fixed (for ERD)
* Vertica: performance for data reading from big tables was improved
* PostgreSQL: support transactions in tools (Truncate and others) was added
* Oracle: TIMESTAMPTZ and TIMESTAMPLTZ data types support was fixed
* Greenplum: session manager was added
* SQL Server: sequences info reading was fixed
* Clickhouse: GROUP BY/ORDER BY functions in grouping panel were fixed
* Eclipse 2018-09 is now the default platform.
* Extra command line parameters were added
* German and Russian localizations were significantly improved
* A lot of minor UI fixes
* Tue Oct 16 2018 ecsos@opensuse.org
- update to 5.2.2
* Google BigQuery extension was added
* DBF files driver was added
* SOCKS proxy: support for proxies on localhost
* New version release checker was fixed (NPE)
* SQL editor:
- Selection occurrences highlighting was improved
- Auto-completion: fuzzy completion is now used for all database objects
- Extra formatting configuration was added
- Active query tab switch bug was fixed
- SQL joins auto-completion was fixed (quote column names)
* Results viewer:
- Filtering + ORDER BY was fixed
- All long string editors now support xml/json formatting
- Native date/time formatting support was added
- Date/time columns justify config was added
- Bit string values support was fixed
* Data transfer:
- Max string column length is respected when generating DDL
- TXT format support was fixed (column widths)
* Query/long tasks canceling was improved (configuration)
* Connection default transaction isolation level configuration was fixed
* Driver version selector was fixed (MacOS)
* Apache Hive/Spark/Impala:
- Table data edit support was added
- Table/view source reading was implemented
- Driver version was upgraded (2.6.5)
* Firebird: table columns rename/reorder/edit is now supported
* PostgreSQL:
- Indexes predicate support was added
- Domain data types (timestamp) resolve was fixed
* Oracle 11: NULL timestamp bug was fixed
* Clickhouse: driver config was fixed (catalogs)
* SQL Server: native driver version upgrade (7.0.0)
* Generic driver connection page UI was fixed (long URLs problem)
* Many minor UI fixes
* Tue Sep 25 2018 ecsos@opensuse.org
- update to 5.2.1
* SQL editor: highlighting all occurrences of selected word (configurable)
* DBeaver extensions installer was improved: admin permissions are not required any more
* Color Theme extension support was added including Solarized Dark/Light themes
* Problem with upgrade from DBeaver 3.x was fixed
* Server session manager was improved:
- UI was redesigned
- Session manager is now present in Tools menu
- "Explain execution plan" tab was added
- Long operations panel was added
- Oracle: many additional session properties were added
* RPM package was fixed (with newer RPM packager)
* Data transfer: option "Selected columns/rows only" were fixed
* "Read data in SQL console" behaviour was fixed (use SQL scripts instead of console)
* Extra commands were added to Database navigator context menu: for data edit, ERD, etc
* Grouping panel was improved: default ordering, duplicates finder, SQL Server syntax support
* UI for the connection selection dialog was improved
* Procedures editor was fixed (Generic driver)
* Results viewer:
- Columns widths resize issue was fixed
- Row deletion for custom SQL without unique key was fixed
* SQL Editor:
- Paste from source code
- formatting was improved (line feeds)
- SQL indentation was fixed (DDL statements)
- Formatter preferences page was redesigned
- SQL Workbench formatter was added
* ERD editor: note delete command was fixed
* Generic connections (Impala and some others) create was fixed (buttons enablement)
* Oracle: "Connections has timed out" error was fixed
* SQL Server: IPv6 hosts support was added
* Vertica: tables metadata reading performance was greatly increased
* PostgreSQL: generic (Legacy) driver metadata reading was fixed
* Redshift/PostgreSQL: array data types support was improved (NULL arrays)
* Added localization for many UI strings
* Many minor UI fixes
- drop rpmlintrc
- use dbeaver.desktop from upstream
- changes from 5.2.0
* New connection wizard was significantly simplified
* Database navigator now loads long table lists by segments (configurable)
* Problem with data transfer wizard and connection wizard auto-resize was fixed
* Results viewer:
- Show error when cell value can’t be read from a database (instead of NULL)
- Plaintext renderer was fixed (NULL values render)
- Actions enable/disable state was fixed
- Export to Excel now respects filters and orderings
* Mock data:
- Wizard was fixed (error with missing native client)
- Batch size configuration was added
- UUID data type support was added
- String generator was fixed
* CSV import:
- Column mappings were fixed
- Support literal for NULL mark
* SQL editor:
- Problem with procedures/views editor cursor reset on save was fixed
- SQL formatter was fixed (spaces after brackets)
- Completion of fully-qualified names was fixed
- Error position highlight was improved
* Long LOB values editor fix
* New version check dialog can be suppressed for a particular version
* ERD: show table/constraint comments
* CockroachDB extension was added
* PostgreSQL:
- Active database switch was fixed
- Native client selector was fixed. Binaries were upgraded to PG 10.5 version.
- Improved support of PostgreSQL 7.x and 8.x
- Allow to select directory in restore wizard
* MySQL:
- Problem with zeroDatetimeBehavior property was fixed
- Duration data type support
* Elasticsearch: driver version updated to 6.4
* Redshift:
- Native Redshift table DDL generator was added
- Driver version update to 1.2.16 (now use Maven artifact)
* SQLite: custom unique key editor was fixed
* Vertica: SELECT INTO limit problem was fixed
* H2: schema browser was fixed
* MSSQL and Generic driver: support filters for procedures/packages
* Misc minor UI problems were fixed
* Tue Aug 28 2018 ecsos@opensuse.org
- update to 5.1.6
* Generic driver: new objects creation was fixed
* Foreign keys creation was fixed
* Schema loading was fixed (Generic driver)
* Native client download feature was added
(MySQL, MariaDB, PostgreSQL)
* Database objects search was fixed
* Long CLOB value editor was fixed
* Configuration for edit toolbar visibility was added
(toolbar is disabled by default)
* Keyboard shortcuts activation was fixed
* Security:
- SSH tunnel initialization fix (NPE)
- SSH keyboard-interactive method: now use saved password
- Advanced security (BouncyCastle) is now used for
SSL/SSH cryptography by default (if present)
- ed25519 support was updated
* SQL editor:
- Auto-completion was improved (fully-qualified names)
- Source code paste transformer was improved
- Indentation was fixed
* Redshift:
- PostgreSQL driver is used for connection
- Data editor was fixed (read-only state)
* Vertica: table list loading performance issue was fixed
* MySQL: zeroDateTime configuration was fixed
(solves performance issue)
* PostgreSQL:
- Table DDL was fixed (GRANT commands)
- Foreign table DDL was fixed (OPTIONS clause)
* SQL Server: BIT data type editor was fixed
* SQLite: datatime/numbers formatting support was added
* Many minor UI fixes
* After all we have reverted to Eclipse 4.7 platform. There were
too many bugs and problems with latest version.
Especially with Linux platforms
* Tue Aug 14 2018 ecsos@opensuse.org
- update to 5.1.5
* Data import from CSV was added
* Connection edit dialog was redesigned (General page)
* SSH tunnel:
- Support of SOCKS proxy for tunnel connections was added
- Support of 'keyboard interactive' authentication was added
* Results viewer:
- SQL script generation was fixed
- Number -> Epoch time transformer was fixed
- Plaintext presentation render was fixed
- Tab name detection for new tabs was fixed
- Panel and dialog value editors now use monospace font
* SQL and ERD editors glitch was fixed on Linux (GTK)
* SQL editor:
- File rename glitch was fixed
- Auto-complete was fixed (string replace)
- Parameters binding dialog additional configuration was added
* Configuration for connection/schema selectors was added
* Metadata search page was fixed
* Basic edit actions toolbar was added
* Data export in plaintext format was added
* PostgreSQL:
- Database create function was fixed
- Databases refresh function was fixed
- Error position extraction was fixed for localized client
drivers
- Dump restore (from directory) option was fixed
* SQL Server: synonyms reading was added
* Hive: driver was updated (get rid of huge and unstable
Maven driver)
* Vertica: connection page was fixed
* Snowflake:
- Connection page was fixed
- Valid table/view DDL extraction was added
* SQLite connection dialog was updated
(get rid of user/password fields)
* All jar files are now signed with code-sign certificate
(important for Eclipse plugin version)
* Meta-information (appdata) was added in Debian packages
* Big number of minor UI and localization fixes
- changes from 5.1.4
* Data viewer:
- Foreign keys/references navigation was improved
- Unique key detection was changed (ROWID is used only if no
natural key was found)
- String filter editor was fixed
* Full-text search history navigation was fixed
* SQL formatter was fixed/improved
* ERD: self-referencing tables rendering was fixed
* Error dialog was enhanced (scrollable text for all errors,
default focus is on Ok button)
* Database navigator double-click behavior was extended
(open new editor)
* Database driver search was improved (search in descriptions)
* Snowflake connection configuration UI was added in CE
* Elastic Search driver configuration was added
* AWS Athena driver configuration was added
* Exasol extension now relies on v6 driver
* PostgreSQL:
- Multiple databases filter was fixed
- Active database detection was fixed
- Function list reading was fixed for PG < 8.4
- Foreign server user mapping was added (thanks to @johnatanDM)
- Permission editor UI was fixed
- Many minor UI fixes
* MariaDB/Galera: users editor was improved
* MySQL/MariaDB: view creation was fixed
* Oracle:
- DATE data type support was fixed
- Table statistics/storage information was added
- Synonyms support was added in metadata extraction
- Extra columns were added to Explain Plan nodes
- Multiline editor for table/column comments
* Firebird: sequences and triggers reading was fixed for older
FB versions
* Phoenix: metadata reading bug was fixed
(databases with single schema)
* Shortcuts with Ctrl+Alt were changed on Ctrl+Shift
* DBeaver was migrated to Eclipse 4.8 platform. Besides other
improvements this fixes a few old UI bugs on MacOS and Linux
- changes from 5.1.3
* Database objects search fixed (GoTo object dialog)
* Database full-text search was improved
(state loading, bug were fixed, search history was fixed)
* Default error dialog was redesigned
(allow message copy-paste and scrolling)
* Drivers download errors was fixed
(missing Maven artifacts handling)
* ERD looks-and-feel was fixed. Extra configuration was added.
* SQL editor:
- Query comments processing was fixed
- Left toolbar rendering was fixed (background color issue)
- SQL formatter for sub-selects was fixed
* Results viewer:
- Presentation switch error was fixed
- Sorting by ambiguous columns was fixed
- Visualize read-only columns in grid header
(different background color + tooltip)
- Value view panel read-only state handling was fixed
- Search in value view panels was added
- Execution log and output panel toggle shortcuts were changed
* PostgreSQL:
- Driver version updated to 42.2.3
- Multi-database support was improved
(no need to switch active database on access)
- Foreign table DDL was fixed
- Materialized view DDL was fixed
- Domain data types resolution was fixed
(problems with date/time types)
- Debug perspective switch was fixed
* MySQL:
- New driver for MySQL 8.x was added
- Timestamp time zone issue was resolved
* Oracle:
- Tablespace storage information was fixed
* Yellowbrick driver configuration was added
* Timescale driver connection page was fixed
* SAP HANA: activate database switch was added
* Data export in SQL: null table name issue was fixed
* Data transfer by segments + table truncate was fixed
* Database output log contents filtering was added
(zero characters)
* Database navigator: icons position was fixed
* New table columns rename was fixed
* MacOS installer was fixed (CE and EE version on the same
machine issue)
* Debug logging was fixed (do not log secure information)
* Many minor UI fixes
* Wed Jul 4 2018 ecsos@opensuse.org
- update to 5.1.2
* SQL editor:
- Commands toolbar was redesigned
- SQL formatting for JOINs was fixed
- Indentation in auto-formatter was fixed
- Vertical editor selection bug was fixed
- Support multiple values in @SET command
- Command shortcut processing was fixed
* Results viewer:
- Filter editor behavior was fixed (Enter key processing)
- Glitch with text edit panel (CLOBs) was fixed
- Column (row) drag-n-drop in record mode is now supported
* ERD:
- Entity render was improved
- Associations (foreign keys) resolution was fixed
* PostgreSQL:
- Active database switching was fixed
- Metadata editor was improved (materialized views tablespace,
table extra options)
- Materialized views refresh tool
- Explain plan conditions formatting was added
- Index columns view was improved
* MariaDB/MySQL:
- Server time zone selected add in connection edit page
(MySQL only)
- Show view algorithm in metadata viewer
- Save view was fixed
- Save Trigger was fixed
- Permissions grant was fixed for HISTORY privilege (MariaDB)
* Oracle:
- Show used/available space for tablespaces
- View source extraction was fixed (extra semicolon issue)
- Procedures auto-completion was fixed
- DB2: sequence creation was fixed
- SQLite: sequence reading was fixed
- SAP HANA: procedures and functions were separated
- Timescale: driver configuration was added
- GoTo database object dialog: connection health checking was
added
- Row count calculation for custom queries was fixed
- Metadata editor supports dialog with multiline editor for
comments/remarks
- Output log viewer auto-clear option was added
- Connection invalidate was fixed (do not show notifications for
alive connections)
- Many minor UI and localization fixes
* Sat May 19 2018 ecsos@opensuse.org
- update to 5.0.5
- PostgreSQL procedures debugger was added in CE
- Search in query history feature was added
- Query manager view was redesigned
- DBUnit data export format support was added
- Eclipse Mars (and earlier) support was fixed
- Foreign key values browser was improved
(progress visualizing, values ordering)
- Results viewer/editor key bindings activation was fixed
- Results viewer now respects database navigator filters
(default column visibility)
- Results viewer shortcuts (fetch page/fetch all) were changed
to avoid conflicts with Linux def shortcuts
- XLS data exporter was improved (column comments support)
- SQL formatter was fixed (special characters processing)
- SQL Editor: auto-completion was fixed for Generic driver
(including SQL Server and Informix)
- Connect, disconnect and invalidate timeouts were added
- PostgreSQL: view comments and permissions support was added
- PostgreSQL: asynchronous server output reading is now supported
- PostgreSQL: schema create was fixed
- MariaDB: packages support was added, procedures read was fixed
- DB2: table columns create/edit supports was added
- Oracle CASE statement parsing was fixed
- Misc minor UI bugfixes
- changes from 5.0.4
- Different action icons were fixed (results viewer, SQL editor,
file operations)
- Results viewer: context menu was redesigned (compacted)
- Results viewer: scrolling shortcuts were changed
- HighDPI support: composite icons rendering was fixed
- Data export: SQL INSERT format support for custom SQL queries
- Mockdata: commands contributions (menu and toolbar) was fixed
- SQL editor: object search now can search inside object names
- SQL editor: auto-indent was fixed (identifier replace issue)
- SQL editor: “to upper case/to lower case” command shortcuts
were fixed
- SQL editor: bold font style configuration
- Bookmarks drag-n-drop inserts real object name
- Database objects create: mixed case identifiers support was
fixed
- Database aliases support was added (DB2, Oracle)
- Diagram viewer: support aliases drag-n-drop
- Diagram viewer: tables/columns copy action was added,
context menu was redesigned
- Table truncate support (for data transfer,
mock data generators, etc)
- Oracle: default driver version changed to 12.2
- Oracle: expired passwords change UI
- Oracle: DROP INDEX was fixed
- PostgreSQL: permissions reading was redesigned
- PostgreSQL: table columns permissions view/edit support was
added
- PostgreSQL: create function dialog redesign
- PostgreSQL: schema DDL support was added
- PostgreSQL: schema comments edit support was added
- PostgreSQL: tablespace edit support was added
- PostgreSQL: constraint indexes support
- PostgreSQL: default schema change was fixed
- PostgreSQL: trigger attribute view
- MySQL: enum columns parser was fixed
- SQLite: read-only connections support was added
- Firebird: driver version was updated. 2.x driver was removed.
- Firebird: SET TERM command evaluation was fixed
- Vertica: tables, projections and columns comments support was
added
- Clickhouse: metadata read fix
- Misc minor UI bugfixes
* Tue Apr 17 2018 ecsos@opensuse.org
- update to 5.0.3
- Event notification UI was added (commit/rollback/reconnect events)
- Results viewer: status bar update fixed (re-layout)
- Results viewer: filters reset action enablement was fixed
- Results viewer: ordered UUID transformer was added
- Results viewer: support of grid columns drag-n-drop in text editor was added
- Results viewer: filter dictionary reading was fixed (include NULL values)
- Results editor: script generation was improved (column values are now correctly rendered)
- Results editor: complex data type (structures, arrays) editor UI was fixed
- SQL editor: autocomplete was fixed (word replacement)
- SQL formatter: keyword case configuration UI was fixed
- PostgreSQL: function permissions editor was added
- PostgreSQL: active schema switching was fixed (search_path patching)
- PostgreSQL: support of PG <= 8.4 (data types info reading)
- PostgreSQL: table comments added in DDL
- Oracle: synonyms reading was fixed (include broken synonyms)
- Oracle: NUMBER data type scale/precision editor was added
- Oracle: convert query line feeds for ORacle <= 10
- SQL Server: procedures drop was added
- SQL Server: table comments reading was added
- Connection invalidate job was fixed (disable disconnect on first failure)
- Connection editor was fixed (folder list)
- Autocommit toolbar button state refresh was fixed (on editor switch)
- CLI: connections duplications bug was fixed
- Query manager colors configuration was added
- Data transfer: extra output file name template variables were added
- Global column filters support was added
- ERD: fully qualified table names option was added
- ERD: export in GraphML was fixed (column data type)
- XLSX exporter was improved (configuration UI)
- SSHJ extension was repackaged
- Full text searcher UI was fixed (messages)
- Mockdata wizard UI was improved
- RPM package dependencies fix (Java 8)
- Misc minor UI fixes
- changes from 5.0.2
* SQL editor:
- Empty script close behavior config was enhanced
- Resources leak (thread + memory) was fixed
- Results viewer: plaintext + record mode error was fixed
* PostgreSQL:
- Permission grants in table DDL
- Constraints comments support was added
- Foreign keys comments support was added
- Sequences support (v10) was fixed
- Sequences comments support was added
- Functions permissions UI was added
- Triggers DDL was added
- Inherited tables DDL was fixed
- Foreign servers DDL was added
- Foreign wrappers DDL was added
- Database rename support was added
* Oracle:
- DBA views resolve was fixed
- Standard function names highlight was fixed
- Exasol: table row count support was added
- SQL Server: URL generation (explicit port value) was fixed
- Greenplum driver configuration was added
- Data export: XLS format (NULL cell values, column comments) was fixed
- Minor UI bugfixes
- changes from 5.0.1
- Data export: markdown (wiki, confluence) format support
- Data export: extra configuration for CSV format
- Data export: auto-size clumns in XLS
- Mockdata generator: UI redesign, extra configuration
- Connection selector dialog was redesigned
- ERD: save to image was fixed (image bounds)
- SQL generate: queries unwrap (configurable)
- SSH tunnel: external SSHJ implementation (ed25519 support, bouncy castle)
- Generic driver configuration was fixed
- PostgreSQL: table DDL fix (include table comment)
- MySQL: global server privileges edit fixed
- Oracle: PL/SQL parser was fixed
- Oracle: float data type support was fixed
- ERD in SVG format support was fixed
- Many minor UI fixes
- changes from 5.0.0
- Mock data generator extension release. UI changes, lots of bugfixes.
- PostgreSQL debugger (beta version)
- PostgreSQL: constraints DDL was fixed
- PostgreSQL: PostGIS support was fixed (array of geometry type)
- Vertica: UDF support (read-only)
- Vertica: flex tables support (read-only)
- Oracle: include comments in view DDL
- Auto-reconnect after connection failure feature was added (configurable)
- Auto-refresh for sessions and transaction lock views was added
- SQL editor: auto-complete for JOIN was fixed/improved
- Metadata search was fixed (NPE)
- Results viewer: grid background colour shows cells state
- Results viewer: column header render was fixed
- Excel export: support of column descriptions in header
- Settings for the page switch saving on the connection page were fixed
- Keyboard shortcuts for the SQL editor opening were fixed
- Entity editor save/revert changes actions were fixed (refresh contents)
- Decimal part rendering is now configurable for the numeric data type
- Command line handling (-con) was fixed (drivers search)
- Fixes for the driver editor dialog were implemented: NPE fixes, show driver ID
- Edit connection dialog was fixed (dialog layout glitch)
- Dialog for errors was fixed – now default button is Stop
- Numerous localization fixes
- Many minor UI fixes
- changes from 4.3.5
- Full UI localization (Chinese, Russian, German, French)
- Mock data generator: additional generators and bug fixes
* Changes for SQL Editor:
- JOIN table/condition auto-complete
- SQL Editor: UI for results/editor/panels switching was fixed
- “open editor” and “switch panels” shortcuts were changed
- warning on the “Execute in separate tabs” command for big scripts was added
- “extract SQL from source code” command was fixed
* Changes for Result viewer:
- icon visibility options were added
- rendering of floating point numbers was fixed (fraction digits are shown according to column scale)
- JSON/XML panel editor was fixed (dirty mark on text selection)
- Driver editor dialog was fixed (custom jars for Maven-enabled drivers)
* Changes for MacOS X installer (pkg):
- support of CE and EE versions on the same machine
- allows to install DBeaver extensions
* Changes for PostgreSQL:
- Postgis support was added
- HStore support was fixed (in string form)
- UI for permission management was fixed
- table DDL (costraints) was fixed (constraint name)
* Changes for MySQL:
- support of geometry (GIS) types was added
- session manager view was improved
- triggers DDL was fixed: trigger creation now omits database name
* Changes for Impala:
- driver configuration was fixed
- SQL dialect/syntax highlighting was fixed
- Many minor UI fixes (edited)
- changes from 4.3.4
- Mock data generator extension (beta version)
- Import/export/script wizard allows multiple run
- SQL formatter was fixed (comments and expressions)
- Data export in SQL INSERT format was fixed (auto-increment columns)
- SQL generator: JOIN support
- Results viewer: “Fetch All” command was fixed
- Content editor: value saving/activation was fixed
- ERD editor: context menu was enhanced (populated with standard table commands)
- SQL Server 2000 and earlier: schema reading was fixed
- Sybase: procedure body reading was fixed
- Sybase: database metadata reading was fixed
- PostgreSQL: database switch support was added
- PostgreSQL: identity column support was added
- PostgreSQL: sequence management
- PostgreSQL: default driver version was updated (42.2.0)
- PostgreSQL: permission management was improved (sequences support) and fixed (role name escaping)
- PostgreSQL: index comments were added to DDL
- PostgreSQL: trigger name column was added
- Oracle: view definition reading was fixed
- MySQL: table filters were fixed
- MySQL: database restore wizard was fixed (UTF encoding)
- Firebird: stored procedure execution was fixed
- Snowflake driver config was added
- A few icons were fixed
- Keyboard shortcuts were fixed (commit, rollback, results panels toggle)
- Many minor UI fixes
- changes from 4.3.3.1
- Fix of NSIS installer (install in Program Files with Admin privileges)
- Fix of SQL processor for PostgreSQL dialect (NPE)
- changes from 4.3.3
- SQL editor: query extraction was fixed (trailing delimiter)
- SQL editor: variables support was added (${varName}, configurable)
- SQL editor: embedded mode was fixed (UI freeze on editor refresh)
- Results viewer: column drop-down filter was added
- Numeric cell value dialog editor was fixed
- Ref cursor cell value dialog viewer was fixed
- Main toolbar was fixed (now it is visible only in DBeaver perspective)
- UI of checkbox inline editor was fixed
- Environment variables substitution now works for all network configurations
- External Eclipse extension installer was fixed
- Git integration was implemented with Eclipse Git plugin
- External plugin repository list was enhanced (Office, SVG, Git, Eclipse Oxygen)
- Command line support was fixed (-con + connection properties)
- CSV export: value quoting config was added
- PostgreSQL: syntax highlighting was improved
- MariaDB: default column value editor was fixed
- SQL Server: schema list reading was fixed
- SQL Server: procedures source reading was fixed
- Oracle: view definition (truncated) reading was fixed
- Sybase: error handling was fixed (for queries with multiple results)
- Firebird: 3.x driver configuration was fixed (default encoding is UTF-8)
- Windows installer was improved
- “All Users” mode was removed
- /S and /D options were fixed
- Controls internationalization was improved
- Chinese, Russian and French localizations were improved
- Many minor UI fixes
* Sat Jan 20 2018 ecsos@opensuse.org
- update to 4.3.2
- UI language selector was added in preferences
- Active schema selector UI was enhanced (filter)
- Foreign/ref key navigation icon render was fixed
- String cell value can be opened in a separate text editor
- Plaintext rendering was enhanced (NULL values, delimiters)
- Data export: export of selected columns/rows is now supported
- SQL editor: support backslash escape in SQL strings/quoted identifiers
- DB2: connection properties dialog was fixed (settings load)
- SQL Server: Windows authentication option was added
- Sybase/SQL Server: schema list read/filter was fixed
- Sybase/SAP ASE: native jConnect driver configuration was added
- MySQL/MariaDB: big query results fetching was fixed (for complex custom SQL)
- PostgreSQL: procedure creation was fixed
- PostgreSQL: role create/drop actions
- PostgreSQL: permission management UI was added
- PostgreSQL: table DDL generation was fixed (column comments)
- Redis: connection properties dialog was fixed (settings load)
- Extra CLI options for MySQL/PostgreSQL native export/import wizards
- French localization was added (thanks to madcollector)
- Chinese localization was updated
- Many minor UI fixes
* Sun Jan 7 2018 ecsos@opensuse.org
- update to 4.3.1
- New custom DBeaver icon set was added.
- 32x32 icons for HighDPI minotors
- Entity editor UI was improved (properties panel)
- Stored procedures execute console
- Referencing tables navigation fix
- Unique key create dialog was fixed
- Quick filter for procedures
- Object delete dialog was improved (CASCADE delete support)
- Main menu localization was fixed
- SQL Server/Sybase: schema list read was fixed
- PostgreSQL: child tables navigation was fixed
- PostgreSQL: money data type support
- PostgreSQL: table DDL generate fix
- Oracle: table DDL generate fix
- Oracle: queues metadata (read-only)
- Firebird: separate drivers for 2.x and 3.x
- HANA: views/procedures DDL extraction
- Generic: show all table triggers in catalog/schema
- Main window title rendering was fixed (confiruable)
- Minor UI fixes
- update to 4.3.0
- UI localizations (Chinese, Russian, German) were added back
- Database navigator: new objects (tables, views, columns) create was fixed
- SQL Editor: active query extraction/parse was fixed
- SQL Editor: proposals auto-activation was fixed
- SQL Editor: compact SQL formatter was added
- Results viewer: data types coloring support was added
- Results viewer: cell value editor
- Results viewer: dictionary edit dialog was fixed (custom criteria)
- Driver manager dialog was improved (driver copy, sorting)
- Main toolbar was slightly redesigned
- Support environment variables in connection properties
- Navicat connections configuration import was added
- Some icons were updated (application, SQL editor)
- Find/replace dialog was added in text edit fields (from context menu)
- PostgreSQL: basic partitions and inheritance support in database navigator
- PostgreSQL: view edit/create was fixed
- Vertica: 7.x-9.x driver configuration
- Neo4j driver configuration was added
- update to 4.2.6
- Results view: referencing tables view (ctrl+1)
- Results view: plain text presentation configuration
- Results view: column ordering shortcut (ctrl+0)
- Results view: boolean value editor was fixed (MacOS)
- Results view: editor activation fix (caps lock handle)
- SQL editor: auto-complete was fixed
- SQL editor: query extraction was fixed (parameters position)
- SQL formatter fix
- MacOS installer with bundled JRE
- Active schema switcher command (ctrl+shift+a)
- Navigator: connections color render was fixed
- SQL query row count function was fixed (SQL transformation)
- Older Eclipse version support was fixed (API invocations)
- Vertica: new metadata browser (projections, nodes, sequences, procedures source)
- PostgreSQL: constraints DDL reading was fixed, access methods model was fixed
- PostgreSQL: database restore command line parameters fixed
- PostgreSQL: array value render eas fixed
- PostgreSQL: data export fixed (multi-row format)
- Oracle: show expressions for function-based indexes
- Oracle: DATE data type render was fixed
- DB2: DECIMAL parameters binding was fixed
- SQL Server: sequences viewer was added
- SQL Server: fix autocompletion for table with @ and # characters
- Apache Solr driver was added
- Internationalization and localization (Chinese) were enhanced.
- Misc UI fixes
- update to 4.2.5
- Connection/schema selectors UI was improved
- Shortcuts for connection schema select (CTRL+9, CTRL+0)
- SQL error handle was fixed (error type detection, reconnect activation)
- SELECT COUNT(*) transformer was fixed
- SQL completion: multiple bug fixes
- SQL editor: single line comment toggle was fixed
- SQL editor: script execution UI config (editor pane maximize is now configurable)
- SQL editor: support association with connections from another project
- Database editor: auto-save doesn't affect data editors
- Results viewer: varchar to binary column view transformer
- Results viewer: status label was fixed
- Results viewer: timestamp value editor was fixed
- PostgreSQL: view DDL was fixed (for alter view)
- MySQL/MariaDB: quoted schema name handle fixed
- Oracle: DATE data type support was fixed
- Oracle: execution plan for queries with parameters
- Oracle: sessions SQL read was improved
- SQL Server: native timestamp format fixed
- Data search: UI was fixed (performance)
- MetaData search: UI was fixed (tree structure)
- ER diagrams: datasource info in project explorer
- SSH tunnel config enhanced (local port number)
- i18n model enhancement
- Chinese localization
- Hex editor UI was fixed (hex panel stretching, preferences)
- Keyboard shortcuts were fixed (conflicts with other Eclipse solutions)
- Cloudera Impala driver config was added
- CUBRID driver config was added
- Office and SVG extensions moved to separate update sites (marketplace)
- Misc UI fixes
* Tue Oct 31 2017 mardnh@gmx.de
- Update to version 4.2.4
- specfile cleanup
Sat Feb 6 00:00:00 UTC 2016 - Mad-Soft
- updated to 3.5.9
Sun Nov 15 00:00:00 UTC 2015 - Mad-Soft
- updated to 3.5.3
Sat Nov 15 00:00:00 UTC 2014 - Mad-Soft
- updated to 3.0.2
