Database Builder
Seamless database design utilizing a visual editor.
The Database Builder offers a visual, code-free way to define tables, making it accessible for business analysts to create application structures without SQL knowledge.
The entity tree displays table relationships, while each field's metadata supports automatic form generation and validation. The builder follows best practices, with foreign keys, indexes, and naming conventions automatically optimized for performance. Security is integrated through role-based permissions for CRUD operations at the table level.
The builder can also auto-generate application screens for data interaction, along with CRUD APIs for each entity. This enables a rapid development cycle, allowing new fields to be added and used in seconds.
|
Database Builder
|
Description
|
|
Visual Builder
|
Tables are defined in a visual editor. It doesn’t require any SQL knowledge. At a high level, an entity tree displays the relationship between tables. This is a popular feature amongst business analysts that use it to build the barebone of the app instead of writing specs.
|
|
Extended Metadata
|
Each field has extended metadata that allows the system to automatically generate the proper forms and perform validation
|
|
Robust Architecture
|
The database builder generates tables that follow best practices in terms of foreign keys, index keys and naming conventions which are automatically determined from field metadata. This results in optimal performance being implemented out-of-the-box.
|
|
Security
|
Role-based permissions for CRUD operations at table level can also be defined in the visual editor.
|
|
Application Screens
|
The Database Builder can auto-generate all the application screens to visualize and operate with the data. It uses capabilities such as the form builder or the data grid that are detailed further down
|
|
APIs
|
Every entity gets CRUD APIs automatically generated.
|
|
Fast Feedback Loop
|
It takes 10 seconds to add a new field to a table and start using it in the application.
|
42