TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Firebird

    Score10 out of 10
    N/AFirebirdSQL is an open-source database which can be embedded.N/A

    SQLite

    Score8 out of 10
    N/ASQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is one of the most widely deployed databases in the world.N/A
    Pricing
    FirebirdSQLite
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    FirebirdSQLite
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    FirebirdSQLite
    Considered Both Products
    Open Source
    Chose Firebird
    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.
    Incentivized
    Chose Firebird
    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 …
    Incentivized
    Chose 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 …
    Incentivized
    Open Source
    Chose SQLite
    In a mobile project it is easier to use, but on desktop, Firebird might be the better choice and it also has an embedded version.
    Incentivized
    Chose SQLite
    SQLite has many types of queries to do CRUD operations. and even do manipulation to external files as well. it is fast and easy to implement compared to other Databases.
    SQLite support atomic behaviours, so app crash in any situation, the won't impact database or data within …
    Incentivized
    Key User Insights
    Would buy again
    100%
    Would buy again
    5 Answers
    100%
    Would buy again
    11 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    5 Answers
    100%
    Delivers good value for the price
    11 Answers
    Happy with the feature set
    100%
    Happy with the feature set
    5 Answers
    100%
    Happy with the feature set
    11 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    90%
    Lived up to sales and marketing promises
    9 Answers
    Implementation went as expected
    100%
    Implementation went as expected
    5 Answers
    100%
    Implementation went as expected
    11 Answers
    Best Alternatives
    FirebirdSQLite
    Small Businesses
    MariaDB Platform
    Score9.1 out of 10
    MariaDB Platform
    Score9.1 out of 10
    Medium-sized Companies
    PostgreSQL
    Score8.8 out of 10
    PostgreSQL
    Score8.8 out of 10
    Enterprises
    SQLite
    Score8 out of 10
    MySQL
    Score8.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    FirebirdSQLite
    Likelihood to Recommend
    8.3
    (4 ratings)
    8.0
    (14 ratings)
    Likelihood to Renew
    9.0
    (1 ratings)
    -
    (0 ratings)
    Usability
    8.0
    (1 ratings)
    8.0
    (2 ratings)
    Support Rating
    5.0
    (1 ratings)
    1.0
    (1 ratings)
    Implementation Rating
    9.0
    (1 ratings)
    -
    (0 ratings)
    Configurability
    -
    (0 ratings)
    10.0
    (1 ratings)
    Ease of integration
    -
    (0 ratings)
    10.0
    (1 ratings)
    User Testimonials
    FirebirdSQLite
    Likelihood to Recommend
    Open Source
    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.
    Incentivized
    Read full review
    Open Source
    SQLite is a lightweight and efficient database management system. With SQLite, performance increases as memory are added. It's reliable and well-tested before release. SQLite handles memory allocation and I/O errors gracefully. SQLite provides bug lists and code-change chronologies. All bugs are disclosed, and it's compatible with iOS, Android, MAC, and Windows. SQLite is open-source, allowing developers to tailor it to their specific needs.
    Incentivized
    Read full review
    Pros
    Open Source
    • Performance is really fast.
    • It is portable and easy to take back ups.
    • Its open n source and free.
    Incentivized
    Read full review
    Open Source
    • Our products are using SQLite in embedded Linux and in Windows software.
    • It is truly a stable cross-platform database.
    • The fact that it is a zero-configuration database engine, it is particularly a nice advantage when you work in the embedded world.
    • Being a single database file, it provides ease for those who need to quickly transfer data to someone else, or quickly browse data.
    Incentivized
    Read full review
    Cons
    Open Source
    • Documentation.
    • No GUI tool to view data.
    • Slow via remote access.
    Incentivized
    Read full review
    Open Source
    • Although it is excellent at what it does, you should be really careful and plan accordingly if you know that your database is going to scale at a huge level because it is not suitable of databases which are of Enterprise level and demands top-notch security and protection.
    • If your project involves multiple people working on the same database simultaneously, then that becomes a big problem, because it only allows single write at one time. You really need to be forward thinking in a manner to predict if this database will cater to all the needs of your project.
    • The most common difficulty with this is the lack of some of the basic functionality which is present in the other premier databases like Joints, Stored Procedure calls, Security and permission grants. If you do require all those things then you are better off not using this software.
    • Lastly, if you are using this in an Andriod App development cycle then also your options are limited because it does not integrate with PostgreSQL and MYSQL.
    Incentivized
    Read full review
    Likelihood to Renew
    Open Source
    Because it is free and usually zero maintenance. Just the issue of more difficult format updates in the future lower the rating a bit.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Usability
    Open Source
    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.
    Incentivized
    Read full review
    Open Source
    I have given this rating cause its irreplaceable in some of the areas like no more installation need except from a single library. I find dialect is simple in use cases. its suitable for any professionals with various skill levels. its easily connect with various os and devices. very less maintenance or administration required.
    Incentivized
    Read full review
    Support Rating
    Open Source
    This is an open source project. It provides a fair amount of free documentation and I think forums somewhere...
    Incentivized
    Read full review
    Open Source
    I haven't needed support yet.
    Incentivized
    Read full review
    Implementation Rating
    Open Source
    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.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    Open Source
    Because it is having Open Source License and easy to deploy on windows and linux environment
    Incentivized
    Read full review
    Open Source
    We looked at other traditional RDBMS products, but found them to be cumbersome to deploy. They take up more space, and consume more computing resources than SQLite does. While the performance or direct integration to our primary applications may have been better or easier if we had gone with a traditional RDBMS, the performance of SQLite has been more than acceptable. The performance and speed to deploy made SQLite a much more attractive option for us than a traditional RDBMS.
    Incentivized
    Read full review
    Return on Investment
    Open Source
    • Cost effective saving us from paid relational database.
    • Community support.
    • Efficiency in handling simultaneous connections.
    Incentivized
    Read full review
    Open Source
    • No licensing fees has a net increase on ROI
    • The active community has kept support costs low, further increasing ROI
    • The wide range of supported platforms and high level of compatibility has increased ROI by reducing time spent porting the database model to any platform specific solutions.
    Incentivized
    Read full review
    ScreenShots