DBGate Sample 01 - Basic Features

Light Theme Dark Theme

This example shows basic DBGate features:

You can select data from tables, views, and stored procedures.
You can save data changes back to a database.

You can choose a platform: SQL Server MySQL PostgreSQL Oracle Database

DBGate supports the following ways to save changes:

You can save changes to the target tables or views directly.
You can save changes using procedures for insert, update, and delete operations.
You can save changes using the cell change handler procedures.

Try these examples:

cashbook Simple plain table
view_cashbook Simple view editable by default
usp_cashbook Simple stored procedure editable by default
usp_cashbook2 Simple stored procedure saved by _insert, _update, and _delete procedures
usp_cashbook3 Simple stored procedure with editable cells saved by a _change stored procedure
usp_cash_by_months Report stored procedure with editable cells saved by a _change stored procedure

You can analyze requests and responses using the browser developer tools.

You can find the definition of any object using the code browser below.
Take a look at the procedures used to save changes. They are simple.

Note that DBGate generates the metadata model, automatically reading the database metadata under the user's account.

So, a user gets only available objects and features. Take a look at metadata for power user1 and restricted user2.

Note that DBGate requires a username and a password to connect to a database in a production environment.
These samples do not require credentials for demo purposes.

Code Browser

Choose an object:

Object definition:

DBGate creates the web forms automatically based on underlying database objects.
For example, it creates the cashbook form using the s01.cashbook declaration only.

You can download samples for any supported database platform with the SaveToDB SDK.