Firebird SQL Database Development
There are plenty of different SQL databases out there. But when it came to selecting one for Tech Solutions to specialize in, our criteria was pretty strict:
|
 |
So we went out searching. We reviewed MySQL, Microsoft SQL Server, PostgreSQL,
Oracle and many others. We had years of Sybase experience also from
past years. But not one database option ticked all the boxes for us.
Until we found Firebird.
Firebird offers a high-end database solution, similar in capability to Oracle or other higher end commercial SQL databases. Firebird is the open source port of Interbase, a SQL database engine that has been in the market since the mid 1980s.
In 2000, Borland gave the Interbase SQL database to the open source community, and a year or so later, Firebird 1.0 was born. Since then Firebird has gone from strength to strength due to the incredible talent of its developer community.
Available in both Server installations as well as embedded single user versions, the one Firebird SQL database can work either as a single user application or as a high-end multi-user server based platform with thousands of concurrent users. Firebird embraces the latest in record versioning technology meaning that a well developed application using Firebird can take advantage of multiple users accessing the same records without major restrictions on what can be done to the data records.
And being totally ODBC compliant, Firebird databases can be easily used with decision support and data warehousing tools such as Crystal Reports, Brio query, etc.
Firebird runs on Windows, Mac & Linux environments with little or no difference between the platforms, making it an ideal choice for environments that use different hardware and operating system technologies. It also takes advantage of features critical in high end SQL design such as a rich stored procedure language, triggers, views and database shadowing. And through the hundreds of 3rd party tools out there, database synchronization and administration is a breeze.
The best part is that unlike its counterparts, Firebird is basically a 0% adminstration database. No need for expensive DBAs to keep the database live. It has all the built in 'smart technology' to take care of its own maintenance, so you can forget about having to do anything major with it (except backing it up of course).
So with all of these great reasons to use Firebird, we do. And these days we feel pretty confident in knowing more about this wonderful technology than most. Its for these reasons, we prefer to use Firebird over any other SQL database.
Back to Software Development Services
