DBGate Sample 01 - Basic Features

Light Theme Dark Theme

This example demonstrates basic DBGate features:

Select data from tables, views, and stored procedures.
Save data changes back to a database.

Choose a platform: SQL Server MySQL PostgreSQL Oracle Database

DBGate supports the following methods for saving changes:

Save changes directly to target tables or views.
Use procedures for insert, update, and delete operations.
Utilize cell change handler procedures to save changes.

Try these examples:

cashbook Simple plain table
view_cashbook Simple view, editable by default
usp_cashbook Simple stored procedure, editable by default
usp_cashbook2 Stored procedure saved by _insert, _update, and _delete procedures
usp_cashbook3 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 your browser's developer tools.

Find the definition of any object using the code browser below.
Check out the procedures used to save changes; they are straightforward.

DBGate generates the metadata model by automatically reading the database metadata under the user's account.

This means users only see the objects and features available to them. Explore the metadata for power user1 and restricted user2.

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

Code Browser

Choose an object:

Object definition:

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

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