Supported Database Servers
dbFront currently supports MySql 4+, Microsoft SQL Server 2000+, and Oracle 10+.
dbFront currently supports MySql 4 through MySql 6. Although MySql is not as powerful and feature rich as some relational databases, yet MySql is an excellent and speedy database that is free, open source, and for the most part, unencumbered by license usage or functionality restrictions. MySql is now owned by Oracle.
The supported versions of MySql are:
- MySql 4 - 6, and beyond..
To use MySql with dbFront you need to download and install the MySql connector:
Microsoft SQL Server
SQL Server comes in a variety of versions with a variety of license restrictions. A very significant advantage is that for the most part the different versions are completely compatible.
The express versions of SQL Server are free but with the primary limitation that the database can't exceed 4 gig. This means you can take advantage of the programmabilty and functionality of SQL Server and only upgrade when necessary. This makes it an excellent candidate for smaller web focused databases that still want to be able to take advantange of the advanced programability found in TSQL and SQL Server and even .net.
The supported versions of SQL Server are:
- SQL Server 2000 - 2016, and beyond..
- Express, Standard, Advanced, etc...
Most systems will already have all the components installed that dbFront needs to connect to a SQL Server database.
Oracle is still the king when it comes to database servers but it comes at a price. One of the many aspects of Oracle that make it such a strong contender is that PL/SQL is designed to allow for the creation of packages. Packages make it much easier to build and manage a block of related business logic. This is excellent for systems like dbFront that want to off-load the majority of their business specific logic to the database.
The supported versions of Oracle are:
- Oracle 10g - 12c
To connect to an Oracle database you will need to install either the Oracle instant client or the full Data Provider:
Business Logic Placement
Although there is disagreement about where you should put business logic, the benefits of placing your business logic within the database server are very significant.
- The business logic will run much faster on the database then elsewhere because it has better access to the data it needs.
- Having the business logic on the database means that the database is in a much better position to protect it's data and ensure that all the business rules are consistently applied regardless of how the data is accessed and updated.
- Databases packages and components are much easier to change, test, and migrate.
Because of this, Database servers that have a stronger programming model can provide a significant advantage.
It is our intention to extend the database support within dbFront to cover other relational databases but we first want to deepen the support and functionality for the current databases.