TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    CouchDB

    Score6 out of 10
    N/AApache CouchDB is an HTTP + JSON document database with Map Reduce views and bi-directional replication. The Couch Replication Protocol is implemented in a variety of projects and products that span computing environments from globally distributed server-clusters, over mobile phones to web browsers.N/A

    SQLite

    Score9.6 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
    CouchDBSQLite
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    CouchDBSQLite
    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
    CouchDBSQLite
    Considered Both Products
    Apache
    No answer on this topic
    Open Source
    Chose SQLite
    SQLite is already better known in the market. Developers already know how to implement and use good practices.
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    100%
    Would buy again
    9 Answers
    Delivers good value for the price
    No answers on this topic
    100%
    Delivers good value for the price
    9 Answers
    Happy with the feature set
    No answers on this topic
    100%
    Happy with the feature set
    9 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    88%
    Lived up to sales and marketing promises
    7 Answers
    Implementation went as expected
    No answers on this topic
    100%
    Implementation went as expected
    9 Answers
    Features
    CouchDBSQLite
    NoSQL Databases
    Comparison of NoSQL Databases features of Apache CouchDB and SQLite
    Feature
    Apache CouchDB
    7.9
    2 Ratings
    11% below category average
    SQLite
    -
    Ratings
    Performance8.02 Ratings00 Ratings
    Availability8.52 Ratings00 Ratings
    Concurrency8.52 Ratings00 Ratings
    Security6.02 Ratings00 Ratings
    Scalability8.02 Ratings00 Ratings
    Data model flexibility7.02 Ratings00 Ratings
    Deployment model flexibility9.02 Ratings00 Ratings
    Best Alternatives
    CouchDBSQLite
    Small Businesses
    Redis Software
    Score8.3 out of 10
    MariaDB Platform
    Score9.9 out of 10
    Medium-sized Companies
    IBM Cloudant
    Score7.4 out of 10
    PostgreSQL
    Score8.2 out of 10
    Enterprises
    IBM Cloudant
    Score7.4 out of 10
    MySQL
    Score8 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    CouchDBSQLite
    Likelihood to Recommend
    9.0
    (10 ratings)
    10.0
    (13 ratings)
    Likelihood to Renew
    9.0
    (9 ratings)
    -
    (0 ratings)
    Usability
    8.0
    (1 ratings)
    9.0
    (1 ratings)
    Support Rating
    -
    (0 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
    CouchDBSQLite
    Likelihood to Recommend
    Apache
    Great for REST API development, if you want a small, fast server that will send and receive JSON structures, CouchDB is hard to beat. Not great for enterprise-level relational database querying (no kidding). While by definition, document-oriented databases are not relational, porting or migrating from relational, and using CouchDB as a backend is probably not a wise move as it's reliable, but It may not always be highly available.
    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
    Apache
    • It can replicate and sync with web browsers via PouchDB. This lets you keep a synced copy of your database on the client-side, which offers much faster data access than continuous HTTP requests would allow, and enables offline usage.
    • Simple Map/Reduce support. The M/R system lets you process terabytes of documents in parallel, save the results, and only need to reprocess documents that have changed on subsequent updates. While not as powerful as Hadoop, it is an easy to use query system that's hard to screw up.
    • Sharding and Clustering support. As of CouchDB 2.0, it supports clustering and sharding of documents between instances without needing a load balancer to determine where requests should go.
    • Master to Master replication lets you clone, continuously backup, and listen for changes through the replication protocol, even over unreliable WAN links.
    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
    Apache
    • NoSQL DB can become a challenge for seasoned RDBMS users.
    • The map-reduce paradigm can be very demanding for first-time users.
    • JSON format documents with Key-Value pairs are somewhat verbose and consume more storage.
    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
    Apache
    Because our current solution S3 is working great and CouchDB was a nightmare. The worst is that at first, it seemed fine until we filled it with tons of data and then started to create views and actually delete.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Usability
    Apache
    Couchdb is very simple to use and the features are also reduced but well implemented. In order to use it the way its designed, the ui is adequate and easy. Of course, there are some other task that can't be performed through the admin ui but the minimalistic design allows you to use external libraries to develop custom scripts
    Incentivized
    Read full review
    Open Source
    I have had a wonderful experience with SQLite because in my every project I use SQLite in the development phase because it's really fast, doesn't crash and very easy to maintain as well. It saves a lot on physical memory and dedicated server usage. It has all the basic functionality you would need to get the job done and that too at no cost at all. What more could you ask for !!!
    Incentivized
    Read full review
    Support Rating
    Apache
    No answers on this topic
    Open Source
    I haven't needed support yet.
    Incentivized
    Read full review
    Implementation Rating
    Apache
    it support is minimal also hw requirements. Also for development, we can have databases replicated everywhere and the replication is automagical. once you set up the security and the rules for replication, you are ready to go. The absence of a model let you build your app the way you want it
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    Apache
    It has been 5+ years since we chose CouchDB. We looked an MongoDB, Cassandra, and probably some others. At the end of the day, the performance, power potential, and simplicity of CouchDB made it a simple choice for our needs. No one should use just because we did. As I said early, make sure you understand your problems, and find the right solution. Some random reading that might be useful: http://www.julianbrowne.com/article/viewer/brewers-cap-theorem https://www.couchbase.com/nosql-resources/why-nosql\ https://www.infoq.com/articles/cap-twelve-years-later-how-the-rules-have-changed
    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
    Apache
    • It has saved us hours and hours of coding.
    • It is has taught us a new way to look at things.
    • It has taught us patience as the first few weeks with CouchDB were not pleasant. It was not easy to pick up like MongoDB.
    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