dbFront: Your Database Front-End Solution

Embrace simplicity and power with dbFront, your ideal tool for building dynamic client applications. Ready to experience seamless database application management?

Download Now

A RAD Tool Designed for DBAs and Analysts

dbFront is a RAD (Rapid Application Development) tool specifically designed for use by DBAs and Analysts. dbFront allows you to quickly build client applications from your existing databases that are immediately useful. For more details see: How dbFront Works

Benefits of using dbFront

Simple

No Code / Low Code for most common functionality.
Simple to Administer and Straight-forward for users.
Dynamically updates itself as your database structure changes.
Built-in template-based Quick Reports which is great for Ad-hoc reports and exports.

Secure

Satisfies security-conscious Network Admins with its multiple security layers.
Installs locally or hosted and integrates with your existing network security (Active Directory, Single-Signon).
Ensures compliance by leaving you in full control of your critical data. No outsourcing required.
Averts additional backup requirements since the same data is shared by all systems.

Powerful

Full Access to stored procedures, stored functions, triggers, views, etc.
Eliminates synchronization issues by connecting directly to your existing data.
Support for PDF Forms, Excel Templates, Crystal Reports, etc...
Simple, Advanced, Full-Text and Custom search functionality.

To see how this is possible please look at our video tutorials or examine the product details.

Adventure Works - Product Table

The following interface was created from the product table in Microsoft's sample database

Expense Reporter - Home

A free and open source dbFront application that allows your employees to submit expense reports which would pass through management and finance for approval and processing. Implements: Workflow, Auditing and a TodoList

Depreciation Calculator - Home

Depreciation Calculator is a simple open source dbFront application that allows you to maintain a simple list of Assets and calculate the yearly depreciation for each item.

Responsive Design

Support for everything from a small smartphone to a 4K monitor and beyond

Simple or Distributed Setup (DMZ)

A simple setup allows for everything to be installed on a single server. The most secure setup is to spread the Database, Application Server and Web Application over three servers. dbFront allows for any combination.

Child Tables (1-M)

Regular (1-M) child tables appear in separate tabs, each with a grid and form

Child Tables (1-1)

A child (1-1) relationship will appear without a grid

Single-Select Foreign Keys (1-M)

Simple Lookup to Store Table

Multi-Select Foreign Key (M-M)

Multiselect Lookup to Credit Card Table (intermediate associate table)

Configure Relationship Details

Arrange, Rename or Hide related tables

Reporting - Quick Reports

Template based reporting allows regular users to simply, quickly and safely create their own reports. Administrators can save these reports to enable single click reports with optional prompts for search fields or output choices.

Reporting - Invoice Template

Invoice Template setup on the Adventure Works Sales Table

Reporting - Sample Item Listing

This is a simple listing of selected records. Users can easily create these listings and either print or export the results.

Reporting - Crystal Reports

dbFront has the ability to directly process and print SAP Crystal Reports. Users can optionally choose to print to a server-attached printer, view it as a PDF or download the output as either CSV, DOC, PDF, RTF, TSV or XLS.

Advanced Search

Below every table is a configurable and collapsible panel with a list of fields that you can search on individually. This allows advanced access to range and other custom searchs.

Row Level Security

Row Level Security is applied using SQL expressions that evaluate to true or false. The expression syntax is similar to a regular where clause. Select, Update, Delete and Insert permissions are supported.

Stored Procedures

Stored Procedures can be triggered by an Action Button and can be used perform any process and then dynamically return results that can be used to drive a report or export. Multiple recordsets are supported.

Table Views

Database views can be added to tables and their fields can be used everywhere that a regular table field can be used. This includes Reports, Exports, Row Security Expressions, Dropdown Columns, everywhere...

Workflow in Database

Workflow is implemented within the Database using a status and workflow table with dbFront providing the UI. A fully functional example is provided in the Expense Reporter Application.

Layered Security for Defence in Depth

Security is a thorny issue when building database-driven web applications. With dbFront, we have and will take this problem seriously which is why we designed dbFront with the view of defence in depth.

Database Compatibility

Oracle 10+, Microsoft SQL Server 2000+ and MySQL 4+

•••••••••••••••••••••

Compatibility with Major Databases

dbFront is designed to run on a Microsoft web server (IIS) and is compatible with Oracle 10+, Microsoft SQL Server 2000+ and MySQL 4+. For more compatibility and setup information see our setup details.

Flexible Licensing & Support

All dbFront licenses are perpetual (non-expiring) and come with a year of Support & Maintenance. Support & Maintenance ensures you live and priority technical support including access to new releases of dbFront. The first year of Support & Maintenance is included when you purchase a new dbFront license.

	Trial	Free	Pro	Enterprise	Site
	Free	Free	249	749	1499
Expiry	30-day	No expiry	No expiry	No expiry	No expiry
Databases	∞	1	∞	∞	∞
Users	∞	3	100	∞	∞
PDF Forms (Export / Import)	∞		3 Export No Import	∞	∞
Full-Text Search	Yes			Yes	Yes
Single Sign-on	Yes			Yes	Yes
Support	30 days	Q/A Site	1 year included 83 renewal	1 year included 249 renewal	1 year included 499 renewal
Webservers	1	1	1	1	3
License Type	Server	Server	Server	Server	Site
Liability	Limited	Limited	Limited	Limited	Limited

	Start Trial	Start Trial	Purchase	Purchase	Purchase

* Canadian Pricing converted for your convenience.

CAD EUR GBP USD

For more information see our licensing details.

Our Satisfied Customers

About dbFront

Big Ideas Computing Ltd. is a privately-held company founded in 2015 and incorporated as Big Ideas Computing Ltd. in 2020. We are committed to building innovative solutions at reasonable prices.

We are a small company with the big idea of creating a super popular web interface for internal business data. If you think we're dreaming then you're absolutely right! But having been in the database development industry for more than 25 years, we know how painful and annoying it can be to stand up a truly functional and solid interface for existing data. It should be easy, but it never is.

Try dbFront for Free

dbFront offers a 30-day free trial so that you can download, install and test it in your environment. After the trial you can continue to use the FREE version of dbFront for up to 3 users. Please review the video tutorials and plan to start a free trial today. We believe you will be impressed.

Start Free Trial View Live Demo