DBEdit Change History

Version 3.8, May 5, 2025

Improvements

• Enhanced the opening of help pages.

Version 3.7, April 30, 2025

Licensing Changes

• Introduced a dual licensing model:
• The free edition is now licensed under the MIT License.
• The Standard and Enterprise editions are licensed under the updated End-User License Agreement (EULA).
• The free edition now supports saving changes to database tables.

Breaking Changes

• Removed the local CHM help file; use the online documentation instead.
• Discontinued support for DB2, NuoDB, and SQL Server Compact.

Improvements

• Updated application examples for 2025.
• Updated data providers: MySqlConnector, Npgsql, Oracle Database, and SQLite.

Bug Fixes

• Fixed an issue where DBEdit for .NET did not open external URLs.

Version 3.6, April 30, 2024

Bug Fixes

• Resolved issues with MySqlConnector and Npgsql data providers.

Version 3.5, April 29, 2024

Improvements

• Added High DPI support.
• Enhanced DoNotAddValidationLists handlers to prevent adding parameter value lists.

Version 3.4, July 12, 2023

Bug Fixes

• Fixed an issue where DBEdit could not save data to Snowflake tables with primary keys but no identity fields.
• The registration wizard now correctly displays the names of available languages.

Version 3.3, April 10, 2023

Improvements

• DBEdit now supports empty usernames and passwords for DSN connections using external authenticators.
• DBEdit can handle MySQL objects with empty schemas, defaulting to the schema of the active connection.
• Improved performance when loading SQL Server metadata.
• DBEdit can detect the target database server of absent DSNs by identifying specific keywords in DSN names.
  Detected keywords include: SQLSERVER, MSSQL, ORACLE, ORA_, MYSQL, MARIADB, POSTGRE, PGSQL, SNOWFLAKE, and SQLITE.

Version 3.2, February 21, 2023

New Features

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

Improvements

• DBEdit now uses the MySql.Data.MySqlClient data provider installed on the system instead of the bundled version.
  This allows for the installation and use of the latest provider version:
  https://dev.mysql.com/downloads/connector/net/
• DBEdit dynamically replaces the missing MySql.Data.MySqlClient data provider with the built-in MySqlConnector provider.
• Enhanced performance for loading MySQL 8 metadata.
• The ODBC connection dialog now displays the entire connection string.
• The Snowflake connection dialog includes Snowflake-specific ODBC options.

Bug Fixes

• Fixed various exceptions thrown when connecting to MySQL 8 using MySql.Data.MySqlClient.

Version 3.1, January 23, 2023

Improvements

• Updated DBEdit examples for 2023.
• Updated .NET and .NET Framework data providers for Snowflake.
• Updated the registration wizard.
• Updated the auto-update tool.

Version 3.0, December 13, 2022

New Features

• The registered free edition of DBEdit now allows saving changes to databases on local computers.
• DBEdit is now compatible with .NET Desktop Runtime 6.0.
• Added support for filtering operations.
• Introduced search and replace functionality.
• Supports saving and restoring table views, including loading from the database.
• Introduced a row editor task pane.
• Added a new task pane for selecting values from lists.
• Included a task pane for displaying table descriptions.
• Added context task panes for displaying tabular data, text data, and images.
• Supports SelectionChange handlers that can be toggled via the context menu.
• Allows showing and hiding of zero values.
• The status bar now displays the number of cells, sum, and average of selected ranges.

Improvements

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

Version 2.1, August 17, 2022

Breaking Changes

• DBEdit no longer allows saving changes for views, procedures, and SQL code objects that join multiple tables.
  To save changes for these objects, manually set the target table in the xls.objects table.

Bug Fixes

• DBEdit disables saving by procedures if the _change handler is set.
• Fixed an issue where DBEdit did 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.

Key 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 now available in Portuguese, Simplified Chinese, Traditional Chinese, Japanese, and Korean.
• Supports language codes up to 10 characters.
  For example, you can use zh-cn, zh-hans, and zh-hans-cn. Prefer zh-hans and zh-hant for Chinese.
• Includes a completely new Developer Guide.
• Supports JSON forms.
• Supports JSON parameters for edit procedures.
• Supports a single bulk update procedure or SQL code specified in the UPDATE_PROCEDURE field.
• Supports merge mode when only one INSERT_PROCEDURE is specified.
• Allows editing connection strings in configuration files.
• Enables opening files with environment variables, such as %APPDATA%.
• Includes an auto-update tool that checks for updates automatically.
• Supports the Microsoft.Data.SqlClient provider.

Improvements

• DBEdit no longer adds @-fields of 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.
• Supports SaveToDB Framework 10.
• Improved table appearance.
  We recommend using Calibri 11pt as the default font, which can be selected via a new button in the DBEdit Options dialog.
  You can switch between classic and flat styles for drop-down lists in the Options dialog.
• The Tools menu now includes a separate item to open the Appearance tab of the Options dialog.
• Improved connection wizard.
• Allows setting table-level line height in pixels using conditional formats.
• Detects parameter data types for SQL commands.
• Updated SQLite provider to version 1.0.113.0.
• The dbedit.exe executable now embeds language files.

Bug Fixes

• Fixed an issue where DBEdit did not detect SQL Data Warehouse objects.