Directory Lister 歷史版本列表 Page2

更新時間：2020-12-21
更新細節：

What's new in this version:

Installers:
- Windows installer packager was reworked
- MacOS PKG installer was deprecated, DMG installer now includes JDK
- Linux installers (DEB and RPM) now include JDK
- All zip archives now include JDK

MacOS (BigSur):
- Problem with lines disappear in SQL Editor was fixed
- Problem with connection driver properties editor were fixed
- Problem with data filter history dropdown was fixed
- Native client selector was fixed (MySQL, MariaDB, PostgreSQL)

Data transfer:
- Data import now supports INSERT OR REPLACE mode (Oracle, MySQL, PostgreSQL, SQLite, Firebird)
- Column mapping is now saved between different runs (no need to make the same assignments multiple times)

Data editor:
- Resultsets ordering configuration was added (client/server side or smart mode)
- Columns pin flag now saved across different data filters

SQL editor:
- Tabs management was redesigned and improved (naming, pins, reordering)
- SQL folding performance was significantly improved
- SQL auto-completion was improved for procedures
- Problem with unicode characters in script file names was fixed
- Problem with parameters binding dialog was fixed (bad performance during parameter value change)
- SQL generation: extra options were added

PostgreSQL:
- Permission grant queries were fixed
- New schema + new table + new column create UI was fixed

Oracle:
- Session manager now supports Oracle 9
- Dependencies information was added for tables, views and packages
- Redshift: geometry/geography types support was added
- SQL Server: user data type list was fixed (redundant types were removed)
- Firebird: procedure parameters domain type names were fixed
- Popup errors during theme change were fixed
- New connection driver selector was improved (performance)
- DBeaver was migrated to Eclipse platform 2020-12
- DBeaver build system was migrated to Tycho 2.0
- Many minor UI bugs were fixed
- Note: if you experience any problems starting dbeaver after the version upgrade - please try to reset workspace

更新時間：2020-11-30
更新細節：

What's new in this version:

- 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)
- <ySQL/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

更新時間：2020-11-15
更新細節：

What's new in this version:

SQL Editor:
- Folding support was improved and enabled by default
- Current/seleted word highlighting support was improved
- SQL formatting was fixed for DDL queries (like CREATE TABLE)
- "Find in Google" command was added
- SQL-related preference pages were redesigned
- Parser of complex SQL blocks (e.g. PL/SQL) was significantly improved
- Problem with missing query results for some DDL queries was fixed

Data editor:
- ROWID columns support was fixed
- Binary values copy-paste support was added
- Column auto-completion in the filter panel was fixed

Data transfer:
- Automatic columns mapping added for CSV without header column
- Import from CSV/XLS: timezone parameter was added for date/time columns
- Export from SQL query with custom variables: UIX was improved

- Boolean value editor UI was changed (text instead of icons)
- User authentication UI was fixed when "Save password" option is off
- SSH: private key format transform was improved on Linux

PostgreSQL:
- Arrays edit support was fixed
- Inet and other custom data types edit was fixed
- "Generate SQL" action for varchar arrays was fixed
- Create/alter trigger functions were fixed
- Partition create/drop/alter actions were added

Hive:
- Indexes metadata read was added
- Index create/drop functions were added
- Column add/delete support was added
- Table rename support was added

Oracle:
- Extra metadata read performance options were added
- Foreign key metadata read was fixed (ON DELETE rules)
- View DDL was fixed (column comments)
- Many other minor bugs were fixed

更新時間：2020-11-02
更新細節：

What's new in this version:

Data transfer:
- REPLACE/UPSERT support was added in SQL export format
- Target format selector was fixed (Linux)
- Bug in dump/restore credentials save was fixed

Data viewer:
- Contrast color now used as foreground color
- Bug with results fetch size disable was fixed
- Preference pages structure was re-organized (get rid of Eclipse legacy)

Database navigator:
- SQL editor context menu was enhanced
- "Link wit editor" command was fixed for SQL scripts
- Problem with empty/redundant tooltips was fixed

- SQL editor: active query cancel on editor close
- ER diagrams: table comments loader was fixed
- Sample database now can be created from the main menu
- Transaction deadlocks viewer was fixed

PostgreSQL:
- Data type handler detection was fixed (uuid, name and other types)
- Array editor was fixed (proper array item type discover).

Oracle:
- Oracle 8 support was fixed (metadata read queries)
- Ref cursors support was added
- Multi-row INSERT support was added (for export in SQL format)
- View and materialized view DDL was fixed (comments)

MySQL:
- Dump/restore credentials override option was added
- "Disable foreign key checks" option was added in database restore wizard

- SQL Server: national charsets support was added for table/column comments
- Informix: check constraints read was added
- Hive: LIMIT clause support was added
- Intersystems IRIS driver was added
- Number of minor bugs were fixed

更新時間：2020-10-18
更新細節：

What's new in this version:

Data transfer:
- Data preview was fixed for custom SQL queries
- Binary format mapping was fixed (BLOB->binary)
- Target table name mapping was improved
- Context data context menu item visibility was fixed
- SQL format: extra options were added (including INSERT OR REPLACE support)
- HTML format: additional export options were added
- DbUnit format support was improved

SQL editor:
- "Auto-save on edit" option was added
- Procedures auto-completion was improved (use signature or parameter names depending on context)
- Query cancel on editor close was fixed
- Disable auto-formatting inside comments
- Data viewer: minimum fetch size now limited by 100 rows
- SSH configuration: bug with variables in connection parameters was fixed
- Column reordering UI was fixed

PostgreSQL:
- Serial data types support was improved
- Trigger DDL was fixed
- $$ rule parser was fixed

Informix:
- Driver was updated to the latest version
- Schemas/tables metadata extraction was fixed
- Error in database switch in transactional mode was fixed

MySQL:
- Zerofill flag support was added
- NULL values of "text" type rendering was fixed

Oracle:
- Expired password change feature was fixed
- Connectivity problem ("ONS configuration failed") was fixed

- SQLite: column drop feature was added
- SQL Server: data read from clustered tables was fixed
- Number of minor bugs were fixed

更新時間：2020-10-04
更新細節：

What's new in this version:

Database navigator:
- View only connected data sources filter was added
- Quick search in connections/schemas options were added
- Multiple objects delete confirmation dialog was redesigned
- Tooltips visibility configuration was added in preferences
- Windows installer: shortcuts for "All Users" were fixed

SSH tunnels:
- Support for OpenSSH key format was added
- Problem with dobule password prompt was fixed

Data viewer:
- Grouping panel now supports column reordering
- Column modifier icons (key, read-only) were updated
- JSON/XML viewer performance was significantly improved
- SQL editor: toolbar buttons enablement was fixed

Data transfer:
- Native client selector was fixed
- Extra file name pattern variables were added
- Native date/timestamp format support was added to the SQL INSERTS export
- Extra formatting options were added to the SQL INSERTS format
- MySQL: user credentials of mysqldump overwrite local configuration now

SQL Server:
- SSL support was added
- Database create/drop/rename features were added

PostgreSQL:
- Interval data type DDL was improved
- Table storage parameters were added to DDL
- "Connect as role" option was added in the connection settings
- Materialized view comment edit was fixed
- Trigger comment editor was added

- Oracle: extra NLS parameters were added on the connection settings page
- Snowflake: active schema set command was fixed
- Derby: unique indexes metadata read was implemented
- SQLite: column autoincrement option support was added
- Firebird: data types information read was fixed
- Several other minor UI bugs were fixed

更新時間：2020-09-21
更新細節：

What's new in this version:

- Preference pages structure was reorganized (in the standalone and plugin versions)

Database navigator:
- Filters now support masks escape (_ and % characters)
- Connection state icons were replaced and adapted to dark themes
- SQL Editor: editor tab title now can include active database/schema name
- MySQL: driver "MySQL 8" is now the default driver. "MySQL 5" driver can be used for older server versions.
- Oracle: tables/views load performance was improved on some systems

PostgreSQL:
- Latest PostGIS driver mapping was added
- Geometry data types export was improved (proper SQL format + SRID)
- Hidden databases can be loaded in the database navigater
- CockroarchDB: role manager was fixed
- DB2: runstats utility support was fixed (wrong syntax)
- SQL Server: extra T-SQL dialect keywords were added
- CUBRID driver configuration was fixed
- Several UI freeze issues were fixed (deadlocks)

Import from CSV/XLSX:
- Wrong rows can be skipped (with disabled "Batch import" option)
- Import parameters documentation was updated
- Several minor bugs were fixed (NPE and UI glitches)

更新時間：2020-08-31
更新細節：

What's new in this version:

- Simplified database structure view was added
- Database maintenance tools can be saved as tasks now
- Table and schema size statistics were added in the database navigator
- Import from multiple CSV files was added. Files can be imported into new or existing tables
- Many problems with UI freeze on disconnect or query cancel were fixed
- Database navigator rendering was redesigned
- A number of problems with keyboard shortcuts were fixed
- Git integration was improved: now we show file status in the Project Explorer view
- New database drivers were added: YugabyteDB and SQreamDB
- Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server)
- Metadata editor: edit property form rendering was improved (non-applicable fields are hidden)
- Performance for table statistics reading was improved

Data viewer:
- Column ordering was fixed (for custom SQL queries)
- UUID transform: version 2 support was added

- Default database name and default user name were added for many database drivers
- Data export: custom data type formatting support was fixed

PostgreSQL:
- Cursor fetch was fixed
- Native client was upgraded to version 12
- Table OID support was fixed (PG 12)
- PgPass parser was improved (support for escaped characters was added)

Oracle:
- Materialized view comment editor was fixed
- View definition reading was fixed (for non-DBA users)
- Table reading now uses DBA views (optional)
- Profile resources metadata reading was fixed

- MariaDB/MySQL: table column resolving was fixed
- CockroachDB: connectivity problem was fixed

Greenplum:
- Metadata search was fixed (for procedures)
- Table metadata reading was fixed

- Dark theme support was improved (tab folders, toolbars)
- A large number of minor UI bugfixes

更新時間：2020-08-17
更新細節：

What's new in this version:

Data transfer:
- Import from multiple CSV files was added
- Import from files into new tables
- Data import preview dialog was added
- Target table create/alter DDL now supports database-specific options
- Virtual columns are ignored in SQL INSERTs export
- Problem with data transfer wizard and Darkest Dark theme was fixed
- Problem with timestamp format for CSV/XLSX export was fixed
- Case sensitive table/column names resolution was fixed

Database navigator:
- Statistics render was fixed for MacOS and Linux
- Database size statistics was added for PostgreSQL, MySQL, SQL Server, DB2

Team work:
- Problem with empty Git Repositories view was fixed
- Git integration was added in project navigator view

PostgreSQL:
- Native client version was upgraded to version 12 (Windows)
- Check constraints read was fixed (PG 12+)
- SQL results limit was fixed (for queries with LIMIT/OFFSET/FETCH clauses)
- Object DDL generator was improved (comments, permissions)
- Support of case insensitive full-text search was added
- Table partitions statistics was added

Oracle:
- TNS names search was fixed
- Connection info was fixed for TNS/custom URL connections
- Variables are now supported in custom JDBC URL
-
MysQL:
- Problem with check constraints read was fixed
- Table copy was fixed (bug with redundant indexes was resolved)
- Redshift: problem with read-only resultsets was fixed
- Snowflake: SQL dialect support was fixed ($$ comments)
- A large number of minor UI improvements and bugfixes

更新時間：2020-08-03
更新細節：

What's new in this version:

Database navigator:
- Connection status icons and tooltips were redesigned
- Icon decorations added for Git-integrated projects
- Navigator view options were added in the context menu
- Simple view support was improved (redundant objects removed from the navigator tree)
- Icons for "Create new objects" action were fixed

Data editor:
- Unique key detection was fixed (for data editor)
- Advanced paste of multiple rows was fixed (redundant rows create was removed)
- Column filter dialog move/resize was fixed on Linux
- Grid data rendering performance was improved
- Auto-complete of column names was fixed in the filter panel

SQL editor:
- Search/replace/undio/redo shortcuts were fixed in embedded editors (view/procedure sources)
- Parameter binding was fixed for multiple occurrences of the same parameter
- Smart commit mode behavior was fixed for PostgreSQL (post-error transaction recovery)
- Delete indent with single backspace was enabled by default
- Server log panel now works for data modification triggers
- Extract query from source code now shows notification popup
- Multiple queries execution is now allowed (in separate tabs)

ERD editor: extra coloring was added for multi-schema diagrams

Oracle:
- Metadata read performance was increased (Tables, materialized views)
- Columns and constraints were added in materialized view editor
- Numeric data type precision read was fixed
- Support of implicit cursors in query results was added
- View DDL reading was improved (view comments are included in DDL)

PostgreSQL:
- Default schema detection and search_path overwrite was fixed
- Multi-dimension arrays support was added
- Table DDL for inherited tables was fixed

MySQL:
- Active database change in read-only connections was fixed
- CHECK constraints support was added
- Table copy operation was fixed
- User password management was improved (to avoid FLUSH PRIVILEGES)

Sybase:
- Support of text editing in views was added
- Schema indexes reading was fixed
- New table columns create was fixed

- CockroachDB: direct table data edit support was fixed
- HSQLDB: UUID data type support was added
- Query cancelling was improved (force cancel for hanging connections)
- Transaction isolation level settings save was fixed
- Error and debug logging was fixed
- A large number of minor UI improvements and bugfixes