Details

Database-driven web applications provide significant value to many businesses.  This is because a well-designed application can significantly improve an organization's efficiency by enabling information sharing and updates among all who need access.

The Problem

The problem with these web applications is that they are expensive to build and maintain.  Some reasons for the complexity and expense are:

• Multiple application layers, each with its own function: storage, security, presentation...
• Each layer uses different technologies: SQL, Java, PHP, C#, JavaScript, CSS...
• Each layer has specific knowledge about the business: structures, business rules, layout...

Because of these costs, many application requests are rejected or abandoned.  This can lead to dissatisfied departments or staff starting their own shadow IT projects.

The dbFront difference

At dbFront, we recognized that by approaching the problem differently, we could meet the needs of many database-driven web applications flexibly and cost-effectively.  Therefore, we designed dbFront from the ground up so that:

• It would use the database as the source of knowledge about the business,
• It would encapsulate the technical complexity of a web application,
• It would dynamically build a powerful but simple-to-use interface.
• It would remain flexible and configurable.

The result is the ability to build out complex and dynamic systems that continue to remain easy to upgrade and maintain.

How it works

In the world of data storage, there is a well-known standard for structuring data called Third Normal Form (3NF).  A benefit of this standard is that it results in databases that are structured in a consistent and descriptive pattern.

In addition, database servers designed to store relational data have several tools available to help protect their data.   Between field types, column constraints, enforced relationships,  and triggers, most databases can effectively enforce their business rules.  

dbFront understands these databases and, with a few hints, builds an intuitive and powerful user interface based on the structure, rules, and data.

dbFront also allows an administrator to tweak various settings, such as selecting the tables and fields that are visible and editable.  dbFront can also be set up with custom buttons that can trigger a variety of different actions based on the current record.

Because dbFront does most of this work dynamically and automatically, the result is a web application that is:

• easy to implement,
• easy to update,
• easy to upgrade, and
• easy to use.

You need to see our video tutorials to see dbFront in action.

Limitations

With dbFront, there will always be a clear relationship between the data and structure in your database and the generated user interface.  Where some see only limitations, we see opportunity...  to significantly reduce unnecessary complexity and cost.

The purpose of dbFront is to get you to the point of Good Enough quickly.