DBGate Sample 21 - Tab Framework

This sample shows how business users can create feature-rich database and web applications.

Database and web developers can use it to prototype applications easily.

To use these features, install the Tab Framework into your database.

You can install it using the SaveToDB add-in Application Installer or using the source code from the SaveToDB SDK.

Note that you can use such applications in DBGate, ODataDB, DBEdit, and Microsoft Excel with the SaveToDB add-in installed.

You configure applications once and can use it in different platforms.

All the tables below are interactive.

Configuring Applications

Define the required application tables in the tab.tables table in the first step.

For example, here are configured tables of the sample application to record money transactions.

In the second step, define the required columns and column properties in the tab.columns table.

The Tab Framework creates auto-increment primary key columns automatically. So, you do not need to create columns like id.

You can specify the source tables of column values, like account_id, item_id, and company_id in the sample.

Also, you can specify columns to use as filter parameters.

Once configured, populate your list tables.

Below is the s21.accounts table. It does not support adding or deleting rows as the protect_rows column checked in the tab.tables table.

Here is the s21.items table:

Below is the s21.companies table:

And finally, below is the cashbook table.

Try to change filter parameters and table data including columns like item_id or column_id.

The Tab Framework contains two roles: tab_developers and tab_users.

Tab_developers can configure applications. Tab_users can view and edit data.

Ask your database administrators to configure database users first.

Then you can manage application users yourself using the Actions menu (select a user and click the right-most button).

The Tab Framework allows localization of table and column names, and list table items.

Define the supported languages in the first step.

Then add the translation. To support translating list table items, check the translation_supported column in the tab.columns table.

Your business users can choose the desired language and regional settings using language-specific URLs like

The Tab Framework allows business users to create multi-user applications themselves.

Users can view and edit data in a browser, DBEdit desktop app, or Microsoft Excel.

You can download the Tab Framework with the SaveToDB SDK for Microsoft SQL Server.