Reviewed on 16/11/2018
Perfect for small-group enviroment and Delphi developing
We are developing a software for restaurants in Delphi (pascal) enviroment since 15 years.
(That is a very complex and raw enviroment with heat, breaking PCs, power-outage, low budget, high demands, etc.)
Collected some experience with other DB systems too, but yet Firebird was the ONLY engine with all necessary skills detailed before.
In those 15 years: 300 DB, on 2000 PCs, used by 1-20.000 users, adding and querying millions of records >> with 1x dataloss only! (Not counting when a HDD chipset fried by lightning and they had no backup.)
- single file Database ! (Easy deployment and restoration)
- easy version upgrade from 0.9-2.5 in these years. (Sadly 3.0 broke the continuity... still waiting to fix it.)
- nice integration into Delphi enviroment
- MINIMAL installation overhead. (Perfect for mass-deployment.) =7MB
- on-the-fly backup (commited transactions), N-backup
- shadow file (=secondary realtime backup-file on a separate disk)
- old (20y+) PC support too! (Win2000+)
- no special enviroment-/installation / depencecy necessary (like .NET)
- no registration required to DOWNLOAD the installer And since v3.0 stable is out >>
- it can be easily scaled to handle Terrabyte-sized DBs with shared-RAM-caching.
- can encrypt the communication protocol and the DB file itself too
- Android supprt From v4.0:
- finally introduced different "transacion timeout" skills to drop broken connections or cancel any queries running too long.
- hard to influence the engine-developers about development-directions
- many open (bug- and important request-)tickets are still not resolved after many years
- limited error handling (does not explaining what the error is... if you have a bad syntax, etc.)
Reviewed on 08/05/2018
Es un RDBMS muy poderoso, que me dio muy buenos resultados para desarrollar proyectos, y es gratuito
Comments: It was of great benefit to me in the use of the database material, it was very useful to develop the projects implemented in the field
What I like is that it is multiplatform, capable of handling small and large databases. Being open source does not require licensing, and has full support for Stored Procedures and Triggers. Supports Transactions 100% ACID, Referential Integrity, in addition Complete internal language for stored procedures and triggers (PSQL), Support for External Functions (UDFs). Virtually no configuration required. Multi-generational architecture and low resource consumption. It has many ways to access the database: native / API, dbExpress drivers, ODBC, OLEDB, .Net provider, native JDBC driver type 4, Python module, PHP, Perl, among others.
Native support for all major operating systems, including Windows, Linux, Solaris, MacOS. By oter part allows incremental security copies
Availability of binaries in 64bit architecture
Complete implementation of cursors in PSQL and Monitoring Tables
Triggers at Connection and Transaction level, and use of Temporary Tables. It has an official page and communities where documentation can be obtained
Cons: what I like the least is that it was left as a bit abandoned, so it started to get complicated to get updates and documentation, although it was already challenged and are the last versions already in circulation
Reviewed on 04/09/2017
Solid, reliable, fast and has met our needs for the past decade.
Comments: Free, fast, reliable and accurate database system.
Pros: Database speed is great. It has the ability to handle multiple concurrent connections. Works well with .NET framework. Has fantastic libraries and great UDF support. Have worked on it for over a decade, and it is well supported.
Cons: Security is a bit lacking when compared to other database management systems. Roles can be better. A single file storage system could be seen as a pro or a con, depending on your business needs.
Reviewed on 22/05/2018
It is a lightweight and easy to install database
María elena B.
Comments: It was very useful during my apprenticeship in data base management for being of open coding
Pros: What I like the most is its ability to manage small and large databases and since it is open source it does not require a license, it does not consume much resources and practically does not require configuration, it has many ways to access the database: ODBC, OLEDB, .Net provider, native JDBC driver type 4, Python module, PHP, among others. It has an official page and communities where documentation can be obtained. On the other hand, it allows incremental backups.
Cons: What I do not like is that they stopped publishing their updates, in a few words they stopped releasing new versions which means that this application has already been abandoned.
Reviewed on 31/05/2018
Oh! How to forget it, if it was the first database manager that I learned to use.!
Maria v G.
Comments: The first database manager I learned to use. I have used it in multiple projects. Great
GREAT. With this database management system you can create, modify, backup and maintain your relational databases in a simple way. It uses the SQL language, apart fundamentally is MULTIPLATAFORMA and open source.
Easy to install on equipment with minimum requirements.
There is a lot of documentation about its functionalities.
It is powerful and fast. You can use it with many programming languages for the realization of your applications.
Cons: In general lines you can use it without any problem for your projects. Recommended for the realization of your information systems.
Reviewed on 09/04/2019
large experience with firebird
Comments: my experiences is more than 10 years with solving different projects and in all I have not had any problem
excellent community support
protection in remote transactions without problems
has no replication
secure in the weak information
Reviewed on 15/05/2019
DATABASE WITH FIREBIRD
Comments: WITH THIS SOFTWARE I HAVE BEEN ABLE TO HAVE HEALTHY MY DATABASES AND THOSE OF MY CLIENTS
Pros: IT IS A SOFTWARE THAT HAS MANY FUNCTIONALITIES THAT FACILITATE THE USE OF IT TO BE ABLE TO HAVE A HEALTHY DATABASE
Cons: IT IS DIFFICULT TO FIND SUPPORT VIDEOS THAT HELP YOU LEARN TO USE THAT SOFTWARE
Reviewed on 12/05/2019
Firebird is an open source relational database management system. unlike the SQL server, this software is also used in Mac and Linux system.
It's essay to learn because the syntax is vet easy of query.
Cons: The auto suggestions of variable and keywords some time not provided.