DBEdit Change History

DBEdit Change History

Version 3.4, July 12, 2023

Bug fixes:

  • DBEdit does not allow saving data to Snowflake tables with primary keys but with no identity fields.
  • The registration wizard does not display the names of the available languages.

Version 3.3, April 10, 2023

Improvements:

  • DBEdit allows using empty usernames and passwords with DSN connections that allows using external authenticators.
  • DBEdit allows using MySQL objects with empty schemas. In this case, it uses the schema of the active connection.
  • Improved performance of loading SQL Server metadata.
  • DBEdit detects the target database server of the absent DSNs using specific words in DSN names.
    The detected words: SQLSERVER, MSSQL, ORACLE, ORA_ DB2, MYSQL, MARIADB, POSTGRE, PGSQL, NUODB, SNOWFLAKE, and SQLITE.

Version 3.2, February 21, 2023

New features:

  • DBEdit generates value lists based on MySQL and PostgreSQL ENUM values.
  • DBEdit supports the MySQL SET data type.
  • DBEdit converts MySQL binary(16) and varbinary(16) data to GUID format when COLUMN_DEFAULT contains uuid_to_bin(uuid()), uuid_to_bin(uuid(),0) or uuid_to_bin(uuid(),1) functions.

Improvements:

  • DBEdit uses the MySql.Data.MySqlClient data provider installed on the system.
    Prior, DBEdit used the provider shipped with the application.
    This solution allows installing and using the newest version of the provider:
    https://dev.mysql.com/downloads/connector/net/
  • DBEdit dynamically replaces the missing MySql.Data.MySqlClient data provider with the built-in MySqlConnector provider.
  • DBEdit has an improved performance of loading MySQL 8 metadata.
  • The ODBC connection dialog box displays the entire connection string.
  • The Snowflake connection dialog box contains Snowflake-specific ODBC options.

Bug fixes:

  • DBEdit throws various exceptions when connecting to MySQL 8 using the MySql.Data.MySqlClient.

Version 3.1, January 23, 2023

Improvements:

  • DBEdit examples are updated for 2023.
  • The .NET and .NET Framework data providers for Snowflake are updated.
  • The registration wizard is updated.
  • The auto-update tool is updated.

Version 3.0, December 13, 2022

New features:

  • The registered free edition of DBEdit allows saving changes to databases on local computers.
  • DBEdit is available for .NET Desktop Runtime 6.0.
  • DBEdit supports filtering operations.
  • DBEdit supports search and replace.
  • DBEdit supports saving and restoring table views, including loading table views from the database.
  • DBEdit includes a row editor task pane.
  • DBEdit includes a new task pane to select values from lists.
  • DBEdit includes a new task pane to display table descriptions.
  • DBEdit includes context task panes to display tabular data, text data and images.
  • DBEdit supports SelectionChange handlers that can be enabled or disabled using the context menu.
  • DBEdit allows showing and hiding zero values.
  • The status bar displays the number of cells, sum and average of the selected ranges.

Improvements:

  • Improved appearance of query parameters.
  • Improved performance and memory usage with large numbers of records.
  • The DBEdit SDK includes new samples for Microsoft SQL Server (Budgeting, Orders, and Northwind).
  • The SaveToDB Framework examples and packages are released under the MIT license.

Version 2.1, August 17, 2022

Breaking changes:

  • DBEdit does not activate saving changes for views, procedures, and SQL code objects based on joining multiple tables.
    To save changes of such objects, you have to set the target table manually in the xls.objects table.

Bug fixes:

  • DBEdit disables saving by procedures if the _change handler is set.
  • DBEdit does not save JSON form data.

Version 2.0, July 5, 2022

Changes in End-User License Agreement:

DBEdit includes an updated End-User License Agreement.

The most important change:

"Consent to Be Included in the Client List: By purchasing the software on behalf of your company, you implicitly consent to the listing of your company name as our customer. You can revoke this consent at any time by submitting a request."

New features:

  • DBEdit is available in Portuguese, Simplified Chinese, Traditional Chinese, Japanese, and Korean.
  • DBEdit supports language codes up to 10 characters.
    For example, you can use zh-cn, zh-hans, and zh-hans-cn. zh-hans and zh-hant are preferrable in Chinese.
  • DBEdit includes a completely new Developer Guide.
  • DBEdit supports JSON forms.
  • DBEdit supports JSON parameters of edit procedures.
  • DBEdit supports a single bulk update procedure or SQL code specified in the UPDATE_PROCEDURE field.
  • DBEdit supports the merge mode when only the one INSERT_PROCEDURE is specified.
  • DBEdit allows editing connection strings of the configuration files.
  • DBEdit allows opening files with the environment variables, like %APPDATA%.
  • DBEdit includes the auto-update tool and allows checking updates automatically.
  • DBEdit supports the Microsoft.Data.SqlClient provider.

Improvements:

  • DBEdit does not add @-fields of the SQL pseudo-code to SELECT output fields.
    For example, it translates id, state, @country_id to SELECT id, state FROM ... WHERE country_id = @country_id.
  • DBEdit supports SaveToDB Framework 10.
  • DBEdit has an improved table look.
    We recommend using Calibri 11pt as a default font.
    You can select it using a new button in the DBEdit Options dialog box.
    You can switch between a classic and flat style of drop-down lists using the Options dialog box.
  • The Tools menu contains a separate menu item to open the Appearance tab of the Options dialog box.
  • DBEdit has an improved connection wizard.
  • DBEdit allows setting table-level line height in pixels using conditional formats.
  • DBEdit detects parameter data types of SQL commands.
  • DBEdit includes the updated SQLite 1.0.113.0 provider.
  • The dbedit.exe executable embeds the language files.

Bug fixes:

  • DBEdit does not detect SQL Data Warehouse objects.