SaveToDB Framework History

SaveToDB Framework History

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 incompleted 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.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:

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