Change Handlers with DBGate

DBGate reads configuration from handler tables and views.

It supports the following features:

• Change Handlers Using Stored Procedures
• Change Handlers Using SQL
• Change Handlers Using Tables
• Change Handlers Using Views

DBGate creates API endpoints for each change handler and publishes them in the metadata under the CHANGE_HANDLERS properties of objects and columns.

You can explore online samples here:

• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/usp_cashbook3/$metadata
• https://dbgate.savetodb.com/api/mssql-023/en-us/s02/view_cashbook3/$metadata

The built-in JavaScript client and SaveToDB 8+ read the DBGate metadata and execute POST commands for every cell change.