Firebird

Firebird

Score 8.0 out of 10
FirebirdSQL

Overview

What is Firebird?

FirebirdSQL is an open-source database which can be embedded.
Read more

Recent Reviews

Free and Practical

5 out of 10
May 14, 2021
We use the Firebird open source relational database in a small piece of IT infrastructure designed for a specific task in the workplace …
Continue reading
Read all reviews

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Firebird, and make your voice heard!

Return to navigation

Product Details

What is Firebird?

FirebirdSQL is an open-source database which can be embedded.

Firebird Video

Firebird Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews

(1-5 of 5)
Companies can't remove reviews or game the system. Here's why
Pauline Harris | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Being able to perform well on standalone servers with higher data volumes with well-written SQL has made us utilize it to allow simultaneous connections seamlessly as this large supports our organization's needs. We use it to perform all staging activities as it can be deployed on Linux-based environments.
  • Taking back ups is easy.
  • It is an open source and free
  • Fast performance.
  • Clustering features require alot of attention.
  • Remote access can be quite slow.
It is able to handle simultaneous connections when using the embedded software version. It is well suited for organizations looking for standalone servers that can handle high data volumes and still perform well and which is also cost-effective database management system especially when they are working on a low budget.
  • Low maintenance
  • Its free
  • Easy to deploy, use and run.
  • Cost effective saving us from paid relational database.
  • Community support.
  • Efficiency in handling simultaneous connections.
It is cost-effective, maintenance-free, easy to deploy and use on Linux and Windows environments and it works steadily. It has an open-source license. Installing Oracle was quite difficult in comparison to Firebird.
Forescout Platform (CounterACT), Bitwarden, Avanan
Jane Carey | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
We use it to deploy on Linux based environment and perform all staging activities on it. It offers low-print relational database systems that suites all kinds of pc applications which is great for us. It is able to handle up to 1TB of data and thus can accommodate our organization's needs and it also supports SQL.
  • Performance is really fast.
  • It is portable and easy to take back ups.
  • Its open n source and free.
  • More attention is needed when it comes to high availability and clustering features.
  • No embedded version for android.
  • Remote access can be quite slow
When looking for low maintenance and a solution suited for all kinds of pc applications. It is great when you are looking to store physical files in folder locations and you can then reference the document in the database. It has an open-source community around it along with documentation for third-party drivers of the development environment.
  • Friendly and powerful SQL language.
  • Zero maintenance.
  • Full text search.
  • Cost effective as it's free.
  • Effeciency with some speed test availability.
  • Low maintenance has saved us on operational costs.
It came a time when the practice of SQLite was lagging behind and of course, we were looking at the cost that was being involved and so Firebird made the breakthrough for us from both. It has an open-source license and it is easy to deploy on Windows and Linux environments.
Score 8 out of 10
Vetted Review
Verified User
FirebirdSQL is a nearly zero maintenance, low footprint relational database system suited for all kinds of PC applications, since even an embedded version exists which doesn't require installation - just copy the files. It supports SQL and database sizes > 1 TB are no problem. It is fully Unicode compatible, drivers for various development environments are available either from the vendors of these environments or from 3rd parties and there exists a healthy open source community around it along with documentation.
  • In a test back when I started to use it it beat MySQL Hands down on some easy speed test.
  • While the included backup functionality of MySQL failed back then (don't remember the details) the one from Firebird did work out of the box and Delphi meanwhile even has easy to use components to use this from a program written in it.
  • It stores the user accounts in a central database and not in the database the self written application uses, at least up to V2.5.
  • Theres no embedded version for Android as far as I know.
  • Versions prior to V3.0 could always read the older file format versions. That has changed now, which makes upgrading an existing DB harder in some scenarious.
It is well enough suited for embedding it into an application and the embedded version can, as far as I know, nowadays even support multiple simultaneous users/connections. It will also perform well on a standalone server with higher data volumes, if the SQL is properly written. Quite a few 3rd party management tools with SQL query capability, DB design features etc. do exist so it is not only suited for command line purists!
  • Zero maintenance
  • Easy installation
  • Works stable
  • Can't really say that, as my application is most of the times given away for free. But if the RDBMS would cost money, giving my app away for free wouldn't have been done I guess.
Back then I evaluated Oracle 8, IBM DB2, Mimer, SAP DB, MySQL, Borland Interbase (not Embarcadero Interbase and that one has the same roots as Firebird) and most likely other RDBMS. Firebird was free, usage was ok, it was (for my application) maintenance free and speed was ok for me. And it didn't trash my system! Getting Oracle installed is quite some task in comparison! Meanwhile I also have used SQLite, while it works essentially (it was used on a mobile project) I don't really like that it doesn't care much about data types.
I don't know how many, everybody who installs my software and that are > 100. It's a configuration and monitoring software for technical products.
1
Skills required: knowledge of relational databases and general IT knowledge. As already written: the DB is in most scenarios zero maintenance!
  • Backend DB for my application
Because it is free and usually zero maintenance. Just the issue of more difficult format updates in the future lower the rating a bit.
No
  • Price
  • Product Features
  • Product Usability
Price: since the software which uses this DB is most of the time given away for free paying for licenses wouldn't be great...
I would maybe use a different test DB structure for testing.
  • Implemented in-house
No
Change management was minimal
There was nothing to change: it was only me who started a new development project anyway and that needed a database.
  • That not all tools were fully unicode compatible
  • That some FB version which introduced unicode support did it wrong in the first version
Even somebody just starting to use RDBMS himself should get it working quickly, at least if he's got a GUI tool and some SQL knowledge.
This is an open source project. It provides a fair amount of free documentation and I think forums somewhere...
Not sure if there's any and I didn't need that yet.
No
Usability has improved by unifying the architecture. The only thing's missing out of the box is a simple GUI DB tool for viewing DB contents and maybe running some SQL queries.
  • Any things which would lock data or whole tables in some other RDBMs systems as FB uses a multi generation architecture.
  • None that I know of.
No
Muddassar Inayat | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
We are using Firebird SQL with ECM Software named M-Files. it really made our life easy because it is easy to manage, take backups, import and export. Not only this but it allows us to perform all of kind of staging activates on it. it also allows us to deploy on the Linux based environments.
  • Reliable RDMS for the SMB's and we found its performance is really fast.
  • It allows us to store the physical files into the folder location and reference of the document in the database.
  • Easy to take back-ups, and portable.
  • Need to work on it to save GIS based data.
  • Although it is using third party admin tool but should have it own graphical interface
  • Needs more attention on High availability and Clustering features
Well, it is best suited where you need to deploy the solutions on cost effective database management system. since it is open source solution but if you are really looking for the professional way to handling the database oriented then you need to consider one the licensing like IPL and IDPL.

For the mission critical and large enterprise records and transaction based system you need to reconsider your decision while using it.
  • Powerful and friendly SQL language
  • logging
  • Full Text Search
  • Cost Effective Solution
  • Community Support
Because it is having Open Source License and easy to deploy on windows and linux environment.
Azure AI (Cortana), PowerApps, Microsoft SharePoint
May 14, 2021

Free and Practical

Score 5 out of 10
Vetted Review
Verified User
We use the Firebird open source relational database in a small piece of IT infrastructure designed for a specific task in the workplace where I work. I mean small here is not insignificant. Firebird RDMBS is critical for us, fulfilling an important task of our organization that needs to work 24/7.
  • It's free.
  • Open source.
  • No capacity restrictions (at least up to 950GB).
  • It works with low system resources.
  • It is seamless on many platforms. (Windows-Linux-FreeBSD-HpUX-Solaris-MacOS).
  • Documentation.
  • No GUI tool to view data.
  • Slow via remote access.
The reason we prefer Firebird is that it is fully compatible with the application platform, and it works stably in systems that can be used without licensing from large companies such as MS-SQL and Oracle. It is the software convenience it provides compared to other free versions. If the scenario is less suitable, we are careful not to use it in critical systems such as ERP or customer interaction.
  • Free.
  • Easy.
  • It does not require much maintenance.
  • Install, run and forget.
  • The return on investment was of course because it freed us from paid relational databases.
  • We have never experienced a negative situation.
As you know, the version of an application is very good for a period in the world of information technologies, it is the first in the performance / cost table. But some periods come and that practice lags behind. When Firebird made such a breakthrough, we preferred this application and we did not regret it.
Return to navigation