What users are saying about
8 Ratings
11 Ratings
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9 out of 100
11 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 5 out of 100

Likelihood to Recommend

Apache Derby

Derby is absolutely the best when it comes to needing a small, embeddable RDBMS in your applications. Certain jobs, like Risk Modeling, are perfect for a database that is small enough to fit into memory with no trouble then store data from various sources, and then allow a user to access those data sets quickly.
Anonymous | TrustRadius Reviewer

Firebird

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.
Anonymous | TrustRadius Reviewer

Pros

Apache Derby

  • Much easier to use and learn than most commercial databases.
  • Derby database errors are well documented.
  • Most complex queries supported as well as by other database vendors.
Renato Ermann | TrustRadius Reviewer

Firebird

  • 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.
Anonymous | TrustRadius Reviewer

Cons

Apache Derby

  • Not as well positioned in the market as the "big dogs" (Oracle, MSSQL)
  • Been around awhile, and not a lot of exposure. This I believe is primarily due to it's relation to the Apache Project (which is not bad, but they don't force big, lumbering corporate volume licensing on you), and thus people are a bit gun-shy about NOT throwing money at something
  • Java is still "slow" compared to C/C++, thus making Derby a bit slow too
Anonymous | TrustRadius Reviewer

Firebird

  • Documentation.
  • No GUI tool to view data.
  • Slow via remote access.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Apache Derby

For our particular use case, Apache was selected for its ease of use, in its ability to be installed, configured and embedded in our in-house application.
Anonymous | TrustRadius Reviewer

Firebird

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!
Anonymous | TrustRadius Reviewer

Return on Investment

Apache Derby

  • Saved money on database licensing.
Renato Ermann | TrustRadius Reviewer

Firebird

  • The return on investment was of course because it freed us from paid relational databases.
  • We have never experienced a negative situation.
Anonymous | TrustRadius Reviewer

Pricing Details

Apache Derby

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Firebird

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison