SaveToDB Framework History
Version 10.8, January 9, 2023
Updated copyrights
Version 10.6, December 13, 2022
The SaveToDB frameworks and examples are licensed under the MIT license.
Impovements:
- The SelectPeriod handler allows customizing the behavior of date fields and parameters.
Version 10.4, October 13, 2022
Views and procedures designed to control access to application configuration are separated from SaveToDB Framework 10.4 into a separate SaveToDB Framework Extension package.
The base SaveToDB Framework 10 is therefore fully compatible with previous versions.
This allows you to upgrade configurations from previous versions to version 10 without any additional steps.
The SaveToDB Framework Extension package can be installed separately if you want to restrict user access to application configuration.
If you have already installed SaveToDB Framework 10.0, which includes it, you can uninstall the extension using the Application Install Wizard.
Version 10.0, July 5, 2022
New Features:
- SaveToDB Framework 10 includes a set of views to use instead of the tables.
Such views show configuration objects in schemas for which the user has permissions.
The framework includes a set of procedures for switching the configuration between views and tables (as in SaveToDB Framework 9.12). - SaveToDB Framework 10 includes a set of procedures to manage framework users via Excel, DBEdit, DBGate, and ODataDB.
- The Developer Guide includes a complete description of the SaveToDB Framework and many usage examples.
- The framework includes a new table, xls.columns, to configure REST queries.
Version 9.9, July 20, 2020
Impovements:
- The xls.xl_actions_generate_handlers procedure generates typed parameters for cell number and datetime values.
- The xls.handlers.EVENT_NAME column includes new values available in SaveToDB 9.9: DefaultValue and JsonForm.
Bug Fixes:
- The SaveToDB Developer Framework installation script has a bug related to dependency on xls.view_framework_objects.
- The Actions menu of the SaveToDB Developer Framework does not show the @MySqlStyle parameter.
- The xls.usp_database_permissions procedure of the SaveToDB Administrator Framework does not show the CREATE PROCEDURE permission.
Version 9.8, June 23, 2020
Impovements:
- The xls.handlers.EVENT_NAME column includes new values available in SaveToDB 9.8:
DataTypeBit, DataTypeBoolean, DataTypeDate, DataTypeDateTime, DataTypeDateTimeOffset,
DataTypeDouble, DataTypeInt, DataTypeGuid, DataTypeString, DataTypeTime,
DoNotSort, and DoNotTranslate. - The SaveToDB Developer Framework includes a new view, xls.view_framework_objects.
The view uses the same code as the SaveToDB Add-In, DBEdit, ODataDB, and DBGate to detect configuration objects. - The xls.view_all_translations view excludes the framework objects.
- The xls.usp_translations procedure has a new parameter, @is_complete, to filter completed and uncompleted translations.
- The xls.xl_actions_generate_procedures procedure generates typed parameters for cell number and datetime values.
Bug Fixes:
- The SaveToDB Developer Framework installation script has a bug related to the GO command.
Version 9.6, February 27, 2020
Impovements:
- The xls.handlers table includes a new Format EVENT_NAME value.
Version 9.5, January 17, 2020
The copyright changed to Gartle LLC, former Gartle Technology Corporation.
Version 9.4, October 17, 2019
New Features:
- SaveToDB SDK uses a new installer based on a new dbsetup.exe tool instead of gsqlcmd.exe.
The new free tool is designed for installing, uninstalling, and updating databases.
Impovements:
- SaveToDB Frameworks use a single script to update any previous version starting 9.0 to the latest one.
- The EVENT_NAME column of the xls.handlers table includes new values: BitColumn, Information, and RegEx.
- Updated SaveToDB Administrator Framework for SQL Server
You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to manage permissions. - Updated SaveToDB Developer Framework for SQL Server
You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to generate views and stored procedures to select and edit data.
Bug Fixes:
- SaveToDB Developer Framework has fixed issues with generated SQL code output with the MSOLEDBSQL provider.
Version 9.3, September 17, 2019
Impovements:
- The EVENT_NAME column of the xls.handlers table includes new values: AddHyperlinks and License.
- The xls.queries view excludes procedures with usp_insert_, usp_update_, and usp_delete_ prefixes.
Version 9.1a, November 7, 2018
Impovements:
- The HANDLER_TYPE column of the xls.handlers table includes new values: SHOWSHEETS, HIDESHEETS, SELECTSHEET
- The xls.queries view excludes xls.objects objects with the xl_ prefix.
You may use this prefix for defined SQL code objects used in the xls.handlers table as handlers.
Version 9.12, July 5, 2022
Impovements:
- The xls.translations.LANGUAGE_NAME column changed to varchar(10) to support Chinese Simplified and Chinese Traditional.
We recommend using languages codes like zh-hans and zh-hant. - The xls.handlers table contains the updated configuration of the SaveToDB Framework objects.
- The xls.formats table includes the updated formats of the SaveToDB Framework objects.
Version 9.1, July 17, 2019
Impovements:
- The xls.handlers table includes a new DynamicColumns EVENT_NAME value.
- The SaveToDB Framework for Oracle supports Oracle Database 18c and includes the improved XLS.QUERIES view.
- SaveToDB Developer Framework allows generating code in MySQL style like column_name instead of ColumnName.
- Updated SaveToDB Administrator Framework.
Version 9.0a, September 10, 2018
New Features:
- The xls.xl_actions_generate_procedures procedure allows generating ready-to-use objects:
- SELECT views and procedures, from tables and views;
- procedures for INSERT, UPDATE, and DELETE operations;
- Change event handler procedures. - The xls.xl_actions_generate_handlers procedure allows generating template procedures of event handlers:
- Actions;
- ContextMenu;
- DoubleClick;
- SelectionChange;
- ParameterValues. - The Actions menu includes menu items for generating objects described above.
To disable this feature, set the DENY SELECT permission on the xls.view_developer_handlers view. - The xls.xl_actions_generate_constraints procedure allows generating primary, unique, and foreign keys.
Use the xls.view_primary_keys, xls.view_unique_keys, and xls.view_foreign_keys views to check and generate keys using the context menu. - The xls.usp_translations procedure allows translating object names, fields, and parameters.
- The xls.view_all_translations view allows translating names into several languages at once.
- The xls.usp_role_members procedure allows managing user roles.
- The xls.xl_export_settings and related import procedures allow exporting and importing settings.
- The xls_formats role includes the permission to save table formats into the xls.formats table.
To add or remove users from a role, use a form based on the xls.usp_role_members procedure. - The xls.xl_actions_set_role_permissions procedure sets permissions for the framework roles.
- The Application Workbooks wizard includes the new SaveToDB Framework 9 configuration workbook.
- The Actions menu includes updated links to the SaveToDB add-in documentation and SaveToDB Framework objects
Version 9.0, February 5, 2019
New Features:
- SaveToDB Framework 9.0 and 9.1 of 2018 renamed to 9.0a and 9.1a.
New SaveToDB Framework 9.0 for SQL Server has the same version as frameworks for other platforms.
SaveToDB Framework 9.1a split into three parts:
- SaveToDB Framework
- SaveToDB Developer Framework
- SaveToDB Administrator Framework
SaveToDB Framework 9.2 is a complete copy of SaveToDB Framework 8.19.
It is a run-time part available on all supported database platforms.
SaveToDB Developer Framework includes objects to support application development. It contains most of the objects added in SaveToDB Framework 9.0.
SaveToDB Administrator Framework contains objects to manage database permissions.
The updated SaveToDB Application Installer 9.0 allows choosing frameworks to install and uninstall.
So, you may install all frameworks into a development database and only a framework run-time into a production database. - SaveToDB SDK contains a universal SaveToDB Application Installer 9.0.
The installer allows installing, uninstalling, and checking any application and framework using source codes for any supported database platform.
The installer suggests step-by-step confirmation to install or remove the desired components.
It supports the following frameworks:
- SaveToDB Frameworks 7, 8, 9
- SaveToDB Developer Framework
- SaveToDB Administrator Framework
- Change Tracking Framework
- Database Help Framework
The installer requires the free gsqlcmd 5.0 command-line utility.
Of course, you may install and uninstall any application or framework with source codes using your favorite tool. - SaveToDB Administrator Framework includes new procedures for managing permissions:
- xls.usp_database_permissions
- xls.usp_object_permissions
- xls.usp_principal_permissions
The framework includes a new role, xls_admins, that allows executing these procedures and the xls.usp_role_members procedure.
Adding users to this role is safe. The procedures are executed in the user context. So, users can execute GRANT, DENY, and REVOKE if they have permissions only. - The xls.workbooks table has an additional TABLE_SCHEMA column.
This column allows filtering and exporting the desired schemas.
The column must be in the last position. Otherwise, SaveToDB 8.18 and prior cannot detect this configuration table.
Impovements:
- The validation list of xls.handlers.EVENT_NAME field includes new types: AddStateColumn, KeepFormulas, DoNotKeepFormulas, UpdateEntireRow, UpdateChangedCellsOnly
- xls.workbooks contains new workbook definitions for the Application Workbooks wizard.
- SaveToDB Framework 8 and 9 have the following file names:
- savetodb-framework-install.sql
- savetodb-framework-remove.sql
SaveToDB Framework 7 has the file names with the -en suffix:
- savetodb-framework-install-en.sql
- savetodb-framework-remove-en.sql
Contents
- Version 10.8, January 9, 2023
- Version 10.6, December 13, 2022
- Version 10.4, October 13, 2022
- Version 10.0, July 5, 2022
- Version 9.12, July 5, 2022
- Version 9.9, July 20, 2020
- Version 9.8, June 23, 2020
- Version 9.6, February 27, 2020
- Version 9.5, January 17, 2020
- Version 9.4, October 17, 2019
- Version 9.3, September 17, 2019
- Version 9.1a, November 7, 2018
- Version 9.1, July 17, 2019
- Version 9.0a, September 10, 2018
- Version 9.0, February 5, 2019