ODataDB Sample 01 - Basic Features

Light Theme Dark Theme

This example demonstrates basic ODataDB features:

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

Choose a platform: SQL Server MySQL PostgreSQL Oracle

ODataDB supports several 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

Analyze requests and responses using your browser's developer tools.

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

ODataDB 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. Review the metadata for power user1 and restricted user2.

ODataDB 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:

ODataDB automatically creates web forms based on 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.