Softpedia >Windows >Internet >Servers >Database Utils >DBeauty >  Changelog

DBeauty Changelog

What's new in DBeauty 10.0

Sep 24, 2020
  • Java 7 support was dropped in favor of reduced development overheads.
  • Third party libraries and JDBC drivers have been upgraded accordingly.

New in DBeauty 9.5.6 (Sep 20, 2020)

  • New CLI tool for printing the closure of subject tables. https://github.com/Wisser/Jailer/issues/34
  • The command line interface has been cleaned up and simplified.
  • An error in the HTML rendering of a data model was corrected.

New in DBeauty 9.5.5 (Sep 13, 2020)

  • Fix for "Need help understanding delete script"
  • https://sourceforge.net/p/jailer/discussion/700499/thread/b3685a49/
  • (A further release was necessary, as this was not completely corrected at first)
  • improved CSV-handling

New in DBeauty 9.5.4 (Sep 9, 2020)

  • Deactivated dependencies had no effect on topological sorting. This was corrected. https://sourceforge.net/p/jailer/discussion/700499/thread/b3685a49
  • Fix for "NoClassDefFoundError was not logged, Jailer failed without showing reason #33" https://github.com/Wisser/Jailer/issues/33

New in DBeauty 9.5.3 (Sep 3, 2020)

  • Improved Connection Settings Wizard.
  • Some diagnostic means have been added.
  • Minor fixes.

New in DBeauty 9.5.2 (Aug 10, 2020)

  • Fix for "[Bug] firebird database - No suitable Inline-View Style known #32"
  • Fix for "Delete Reduction is not deleting rows"

New in DBeauty 9.5.1 (Aug 4, 2020)

  • Fix for "[jailer:bugs] #43 PostgreSQL: Export of inet and interval"
  • Fix for "[jailer:bugs] #44 not a proxy instance if WorkingTableScope.LOCAL_DATABASEand Tomcat jdbc pool"

New in DBeauty 9.5 (Jul 2, 2020)

  • Increased initial responsiveness of the Data Browser.
  • Extensive internal redesigns since the last major release.

New in DBeauty 9.4.3 (Jun 17, 2020)

  • Fixed issue "Error when running sql script"

New in DBeauty 9.4.2 (Jun 3, 2020)

  • Improved database metadata management.
  • Increased initial responsiveness of the Data Browser.

New in DBeauty 9.4.1 (May 21, 2020)

  • Improved database metadata management.
  • Increased initial responsiveness of the Data Browser.

New in DBeauty 9.4 (May 7, 2020)

  • The new "Degree view" allows quick and easy editing of the associations of tables with the highest connectivity.

New in DBeauty 9.3.6 (Apr 29, 2020)

  • "#66 Avoid plain text passwords on the command line"
  • Minor improvements to GUI of the data browser.

New in DBeauty 9.3.3 (Mar 20, 2020)

  • Fixed: Characters in bookmark names that are not valid in file names caused errors when saving the bookmarks.
  • Minor improvements to the GUI of the data-browser.

New in DBeauty 9.3.2 (Mar 2, 2020)

  • Fixed "Conditions with () have leading and trailing parans removed" https://github.com/Wisser/Jailer/issues/28
  • Fetching results from MySQL/MariaDB is now based on a cursor. This prevents out-of-memory errors with large amounts of data.

New in DBeauty 9.3.1 (Feb 19, 2020)

  • Fixed "Syntax error creating tables in PostgreSQL" https://github.com/Wisser/Jailer/issues/27
  • Modifications to the connection properties in the "Connection" dialog were sometimes retained after a "cancel".
  • "About" dialog now also shows system properties.

New in DBeauty 9.3 (Jan 28, 2020)

  • The number of rows of a subject table to be exported can now be limited taking into account a possible column order.
  • Nullable primary key columns could lead to incorrect results under certain circumstances.
  • In the data browser, the user interface sometimes blocked when the acquisition of database metadata took a long time.

New in DBeauty 9.2.2 (Jan 1, 2020)

  • When deleting rows, an IllegalStateException sometimes occurred incorrectly.
  • Improved performance of deletion script generation.
  • Progress dialog for exporting is no longer modal.

New in DBeauty 9.1.8 (Nov 27, 2019)

  • Fixed https://github.com/Wisser/Jailer/issues/22
  • Updated the SQLite JDBC driver.
  • A new wizard for JDBC URL settings has been created.

New in DBeauty 9.1.7 (Nov 13, 2019)

  • Fixed NullPointerException in Data Browser.

New in DBeauty 9.1.6 (Nov 10, 2019)

  • Support for data type datetime2 in MS SQL.
  • The -schemamapping option was not used correctly for the statements of a delete script.
  • Formatting of dates/timestamps during export no longer takes place synchronized.
  • This improves performance when multiple threads are used.
  • Minor improvements to the "Export Data" dialog.

New in DBeauty 9.1.5 (Nov 6, 2019)

  • Support for data type datetime2 in MS SQL.
  • The -schemamapping option was not used correctly for the statements of a delete script.
  • Formatting of dates/timestamps during export no longer takes place synchronized.
  • This improves performance when multiple threads are used.

New in DBeauty 9.1.4 (Oct 31, 2019)

  • Deadlock prevention in PostgreSQL.
  • Support for PostgreSQL type "bpchar".

New in DBeauty 9.1.3 (Oct 28, 2019)

  • Improved display of errors in the data browser.
  • More robustness if primary keys are not specified correctly.

New in DBeauty 9.1.2 (Oct 20, 2019)

  • Fetching results from PostgreSQL is now based on a cursor. This prevents out-of-memory errors with large amounts of data.

New in DBeauty 9.1.1 (Oct 15, 2019)

  • Performance improvements.
  • The animation of the data model view in the desktop did not work.
  • When the DDL is generated for a table, it is also generated for the indexes.
  • HiDPI display support.

New in DBeauty 9.1 (Oct 8, 2019)

  • Hover & See function in the data browser to easily see which row is related to which other rows.
  • Added configuration information for MariaDB.
  • Fix for Issue "Gui: NPE after renaming model file (*.jm)"
  • https://github.com/Wisser/Jailer/issues/16
  • The initial base folder of the data models was incorrect if the installer was used on Windows.
  • The minimum requirement for the number of available database connections has been reduced to a single one.
  • Extensive internal redesigns since the last major release.

New in DBeauty 9.0 (Oct 2, 2019)

  • Hover & See function in the data browser to easily see which row is related to which other rows.
  • Added configuration information for MariaDB.
  • Fix for Issue "Gui: NPE after renaming model file (*.jm)"
  • Extensive internal redesigns since the last major release.

New in DBeauty 8.8.8.4 (Sep 25, 2019)

  • Hotfix release for Issue "Gui: NPE after renaming model file (*.jm)"

New in DBeauty 8.8.8 (Sep 20, 2019)

  • Avoid NPE if there is no default scheme.
  • Import filters did not work correctly when a foreign key column with a filter was exported, but not the corresponding primary key column.
  • In the condition editor, scalar subqueries for columns of adjacent tables can now be generated.
  • Minor fixes.

New in DBeauty 8.8.7 (Sep 11, 2019)

  • Upsert statements in PostgreSQL format could fail due to missing explicit conversion of bytea literals.
  • The data model editor is now more robust against errors in the data model files.
  • Minor improvements to the GUI and bug fixes.

New in DBeauty 8.8.6 (Sep 5, 2019)

  • https://github.com/Wisser/Jailer/issues/14
  • "[new feature] add command line options to bypass the data model selection dialog"
  • https://github.com/Wisser/Jailer/issues/13
  • "Multiple table selection"
  • The model selection dialog has been improved. Recently used connections/sessions/bookmarks can be reopened with a single click.
  • The sorting settings of table browsers in bookmarks are recorded and restored.
  • New feature "Find Column..." of the data browser makes it easy to find a column in a wide table.

New in DBeauty 8.8.5 (Sep 2, 2019)

  • [New feature] add command line options to bypass the data model selection dialog"
  • "Multiple table selection"
  • The model selection dialog has been improved. Recently used connections/sessions/bookmarks can be reopened with a single click.

New in DBeauty 8.8.4 (Sep 2, 2019)

  • Fixed a bug that caused a Liquibase export not to work for Postgres TEXT columns.
  • SQL Console didn't work with SQLite.
  • Improved validation of CLI arguments.
  • The "Upsert" statements are generated for more compact.
  • Feature Request 65. https://sourceforge.net/p/jailer/feature-requests/65/
  • Importing C/BLOBs did not work without write permission on the working directory.

New in DBeauty 8.8.3 (Aug 19, 2019)

  • Fixed a bug that caused a Liquibase export not to work for Postgres TEXT columns.
  • SQL Console didn't work with SQLite.
  • Improved validation of CLI arguments.
  • The "Upsert" statements are generated for more compact.
  • Feature Request 65. https://sourceforge.net/p/jailer/feature-requests/65/

New in DBeauty 8.8.2 (Aug 5, 2019)

  • The layout optimizer of the export progress dialog has been improved.
  • The tutorial has been improved.
  • Minor fixes and improvements.

New in DBeauty 8.8 (Jul 16, 2019)

  • New feature "Check Primary Keys" makes it possible to check the user-defined primary keys for uniqueness.
  • A warning message appears if the number of collected rows differs from the number of exported ones.
  • The performance of the preparation for the subsetting-process has been improved.
  • Extraction models can now be loaded from the "Data Model Manager" dialog.
  • It was not possible to pass user / password via cli when it starts with '-'
  • Updated local database to H2 1.4.199.
  • The fonts selection in the GUI has been standardized.
  • Improved error handling in the data browser. If the same error occurs multiple times because it affects multiple table browsers, it will be displayed only once.

New in DBeauty 8.7.8 (Jul 4, 2019)

  • Fixed a bug that caused the creation of a delete script to generate syntactically incorrect SQL statements when a table without a primary key exists.

New in DBeauty 8.7.7 (Jun 28, 2019)

  • New feature "Check Primary Keys" makes it possible to check the user-defined primary keys for uniqueness.
  • A warning message appears if the number of collected rows differs from the number of exported ones.
  • The performance of the preparation for the subsetting-process has been improved.
  • UI improvements.

New in DBeauty 8.7.6 (Jun 28, 2019)

  • New feature "Check Primary Keys" makes it possible to check the user-defined primary keys for uniqueness.
  • A warning message appears if the number of collected rows differs from the number of exported ones.

New in DBeauty 8.7.5 (Jun 21, 2019)

  • Fix for ticket 39 "Oracle queries are going failed". https://sourceforge.net/p/jailer/bugs/39/
  • Minor bug fixes.

New in DBeauty 8.7.4 (Jun 15, 2019)

  • Fix for ticket 39 "Oracle queries are going failed". https://sourceforge.net/p/jailer/bugs/39/

New in DBeauty 8.7.3 (Jun 15, 2019)

  • Fix: the working table scope "local" did not work correctly with PostgreSQL.
  • Cursor-based result sets have been activated under PostgreSQL.
  • Retrieving the entire ResultSet at once led to out-of-memory errors.

New in DBeauty 8.7.2 (Jun 6, 2019)

  • Selected tables are automatically scrolled into the visible area of the display.
  • Fix: not all associations between two visible tables were always displayed.

New in DBeauty 8.7.1 (Jun 4, 2019)

  • SQL Console is now robust against outdated metadata.
  • Fixed: Associations between visible tables were not always visible.

New in DBeauty 8.7 (May 21, 2019)

  • Modal dialogues were replaced by non-modal ones.
  • Creation of the data model files has been revised.
  • Execution plans for DB2 LUW.
  • Fixed "ERROR: failed to find conversion function from unknown to text" that could occur with PostgreSQL in connection with the "local database" scope.

New in DBeauty 8.6.2 (May 3, 2019)

  • View execution plans for DB2 LUW.
  • Fixed "ERROR: failed to find conversion function from unknown to text" that could occur with PostgreSQL in connection with the "local database" scope.

New in DBeauty 8.6.1 (Apr 30, 2019)

  • View execution plans for DB2 LUW.
  • Fixed "ERROR: failed to find conversion function from unknown to text" that could occur with PostgreSQL in connection with the "local database" scope.

New in DBeauty 8.5.6 (Apr 11, 2019)

  • Minor bug fixes.

New in DBeauty 8.5.4 (Mar 29, 2019)

  • The table from which the navigation starts can now be changed at any time in the data browser.
  • Improved data browser performance.

New in DBeauty 8.5.3 (Mar 22, 2019)

  • Column order in the display can be defined not only globally but also for each table.

New in DBeauty 8.5.1 (Feb 27, 2019)

  • Undo/Redo functionality.
  • Improved HiDPI Support.

New in DBeauty 8.5 (Feb 21, 2019)

  • Undo/Redo functionality.
  • Improved HiDPI Support.

New in DBeauty 8.4.3 (Feb 20, 2019)

  • Transactional import did not roll back the transaction in case of an error.
  • improved HiDPI Support
  • Minor bug fixes.

New in DBeauty 8.4.2 (Feb 18, 2019)

  • Transactional import did not roll back the transaction in case of an error.
  • Improved HiDPI Support
  • Minor bug fixes.

New in DBeauty 8.4 (Feb 11, 2019)

  • Undo/Redo functionality.
  • Fixed an error in the analysis of views.

New in DBeauty 8.3 (Feb 3, 2019)

  • New "Model Migration Tool" allows you to easily find and edit the newly added associations
  • if the data model has been extended after the last change to this extraction model.

New in DBeauty 8.2.6 (Feb 3, 2019)

  • Fixed "#37 PostreSQL: transactional execution"
  • Fixed "#36 Data Export Dialog: Some settings are 'lost' between Exports"
  • FR "#62 subsequent Analyze database, new links fate", only the new "parent-> detail" relationships will be disabled.
  • FR "#61 Information about exported rows"
  • Issue 10, "Export to SQLite - Boolean values", https://github.com/Wisser/Jailer/issues/10

New in DBeauty 8.2.5 (Feb 3, 2019)

  • Improved livelock prevention.
  • feature-requests:#61] "Information about exported rows"
  • bugs:#36] "Data Export Dialog: Some settings are 'lost' between Exports"
  • Fixed NPE in "explain" feature.
  • Minor bug fixes.

New in DBeauty 8.2.4 (Dec 31, 2018)

  • Improved error handling.

New in DBeauty 8.2.3 (Dec 29, 2018)

  • Implemented "#57 Analyze database convenience". UPK is formed exclusively for the tables related to the subjects.
  • Implemented "#58 receipt += times"
  • Fixed "#34 Possible Performance-Improvement in CellContentConverter.toSql"
  • Fixed "#59 Retry Deadlock?"
  • Automatic adjustment of the number of database connections.
  • URL of forum and manual pages on sourceforge have been corrected.

New in DBeauty 8.2.1 (Dec 6, 2018)

  • Intra-database export: automatic fallback to MERGE on tables without PK has been removed.
  • Increased SQL import performance + progress bar also for compressed files.
  • Logging did not work if the working directory is read-only.
  • Improved error handling.
  • Minor bug fixes.

New in DBeauty 8.2 (Nov 27, 2018)

  • Fixed "SQLite JDBC: inconsistent internal state" during database analysis.
  • Fixed "#32 SQL analyzer: duplicate associations".
  • Implemented "#51 Reduce transaction sizes"
  • Implemented "#54 Number thousand separators"
  • New option to set the isolation level.
  • Bookmark feature in data browser

New in DBeauty 8.1.5 (Nov 19, 2018)

  • New export option "check primary keys" allows checking the validity of manually defined primary keys.
  • New export option "limit transaction sizes" reduces transaction sizes. (Feature request 51)
  • Improved indexing of working tables.
  • JSQLParser has been updated to version 1.3.
  • Fix for bug 32 "SQL analyzer: duplicate associations"

New in DBeauty 8.1.4 (Nov 16, 2018)

  • New export option "check primary keys" allows checking the validity of manually defined primary keys.
  • New export option "limit transaction sizes" reduces transaction sizes. (Feature request 51)
  • Improved indexing of working tables.
  • JSQLParser has been updated to version 1.3.
  • Fix for bug 32 "SQL analyzer: duplicate associations"

New in DBeauty 8.0.1 (Oct 5, 2018)

  • Foreign key columns can be set to null if parent row is not exported.
  • Increased responsiveness and performance of the data browser GUI.

New in DBeauty 8.0 (Sep 20, 2018)

  • The new "PathFinder" feature allows elaborate finding of association paths between tables in complex data models.

New in DBeauty 7.11.1 (Sep 5, 2018)

  • Closing a root table did not work properly in the data browser.
  • Minor bug fixes

New in DBeauty 7.11 (Sep 3, 2018)

  • Database analysis not only finds primary keys and foreign keys for tables, but also for views and synonyms by analyzing the underlying tables.
  • Fixed a memory leak in data browser.

New in DBeauty 7.10.9 (Aug 31, 2018)

  • Database analysis not only finds primary keys and foreign keys for tables, but also for views and synonyms by analyzing the underlying tables.

New in DBeauty 7.10.8 (Aug 23, 2018)

  • Data browser improvements
  • Improved layout strategy in the data browser.
  • New layout feature: "align table horizontally with predecessor"
  • Improved row-to-row-link rendering performance.
  • Feature Request "Improve the usability of the Data Model Editor" (partially)

New in DBeauty 7.10.7 (Aug 16, 2018)

  • Zoom in / out using the mouse wheel in the data browser

New in DBeauty 7.10.3 (Jul 20, 2018)

  • Fix for "Can't connect to SOCKS proxy

New in DBeauty 7.10.2 (Jul 6, 2018)

  • Fix for "Can't connect to SOCKS proxy:http" https://github.com/Wisser/Jailer/issues/8
  • Added context menu to columns view of results table.

New in DBeauty 7.10.1 (Jul 6, 2018)

  • Added context menu to columns view of results table.

New in DBeauty 7.10 (Jun 21, 2018)

  • Comprehensive usability improvements of the data browser.
  • Animated row-to-row links.
  • Increased rendering quality of row-to-row link.
  • Automatic layouting of data browser desktop.
  • Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks.
  • Update of SQL keyword catalog to SQL 2003 standard.

New in DBeauty 7.9.2 (May 31, 2018)

  • Feature to define the rendering position of a column.
  • Rendering of row-to-row links as bezier curves.

New in DBeauty 7.9.1 (May 22, 2018)

  • Fixed statement leak.
  • Minor GUI Improvements and bug fixes

New in DBeauty 7.9 (May 15, 2018)

  • Comprehensive usability improvements of the data browser.
  • Fix for "#25 Invalid SQL when exporting for H2 dialect"
  • Minor bug fixes.

New in DBeauty 7.8 (Apr 27, 2018)

  • The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions. This allows to reverse-engineer the data model based on existing SQL queries.
  • Improved render quality on high resolution screens.

New in DBeauty 7.7.1 (Apr 15, 2018)

  • SQL-Console:
  • new "Toggle Line Continuation" context menu item
  • "Substitute Variables" context menu item
  • Loading/Saving of SQL Script Files (with Drag & Drop support)

New in DBeauty 7.6.8 (Apr 10, 2018)

  • SQL-Console: GUI Improvements and bug fixes

New in DBeauty 7.6.6 (Mar 29, 2018)

  • Improved SQL Outline rendering.

New in DBeauty 3.7.7 (Dec 6, 2017)

  • data browser improvements
  • In-place editing of query results.
  • Column filtering in data browser.
  • Improved table search feature.

New in DBeauty 2.2.5 (Mar 25, 2015)

  • added support for ARRAY type

New in DBeauty 2.2.3 (Jan 8, 2015)

  • Fix for an exception that appears to have been introduced with version 2.2.2. When connecting both to an Oracle database (Oracle Thin connection with driver ojdbc16-11.2.0.3.jar) and a Microsoft SQL Server database (jTDS connection with driver jtds-1.2.5.jar), a logged exception in the Java console is received whenever one tries to execute a valid SQL select query in a new SQL browser. The same thing occurs when the Menu | Open Query Builder is selected from a table broswer and the pre-populated select statement is executed.

New in DBeauty 2.2.2 (Dec 17, 2014)

  • Bug fix: when a composite primary key is not in the same order than the columns of the table, then when we navigate from the table without where criteria to one of its parents, we have 0 rows as result

New in DBeauty 2.2 (Sep 6, 2014)

  • Data Browser has been improved.
  • Fixed a performance issue related to ResultSet#getMetaData and Postgresql 9.1 JDBC driver

New in DBeauty 2.1.3 (Jul 31, 2014)

  • added support for postgresql UUID type.

New in DBeauty 2.1.2 (Jun 17, 2014)

  • fixed an incompatibility with Java 8.

New in DBeauty 2.1.1 (May 16, 2014)

  • fixed a bug concerning the determination of the universal-primary-key.
  • fixed a bug in file chooser window (thanks to oliver45)

New in DBeauty 2.1 (Dec 5, 2013)

  • added support for Postgres HStore data type.
  • internal refactorings.

New in DBeauty 2.0.12 (May 20, 2013)

  • Added support for high-resolution mouse-wheels.

New in DBeauty 2.0.11 (Sep 17, 2012)

  • Fixed a bug concerning BLOB/CLOB support for MS SQL

New in DBeauty 2.0.10 (Aug 11, 2012)

  • Workaround for ORA-08176.

New in DBeauty 2.0.9 (Jul 20, 2012)

  • Fixed a bug where FlatXMLTransformer would produce invalid XML when table names were quoted

New in DBeauty 2.0.8 (Jul 3, 2012)

  • fixed a bug concerning pre-populated alias fields for tables with quoted names in the QueryBuilder-UI.
  • minor GUI improvements

New in DBeauty 2.0.7 (Jul 3, 2012)

  • improved display-name-concept. Quoted table names will now be displayed unquoted.

New in DBeauty 2.0.6 (May 19, 2012)

  • Java 6 compatibility

New in DBeauty 2.0.5 (May 2, 2012)

  • Fixed a bug concerning multi-line VARCHARs in Oracle.

New in DBeauty 2.0.4 (Mar 7, 2012)

  • Fixed a bug concerning multi-line VARCHARs in DB2.