Couchbase Server vs. Apache Derby

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Couchbase Server
Score 7.9 out of 10
N/A
Couchbase Server is a cloud-native, distributed database that fuses the strengths of relational databases such as SQL and ACID transactions with JSON flexibility and scale that defines NoSQL. It is available as a service in commercial clouds and supports hybrid and private cloud deployments.N/A
Apache Derby
Score 7.0 out of 10
N/A
Apache Derby is an embedded relational database management system, originally developed by IBM and called IBM Cloudscape.N/A
Pricing
Couchbase ServerApache Derby
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Couchbase ServerApache Derby
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeOptionalNo setup fee
Additional Details
More Pricing Information
Community Pulse
Couchbase ServerApache Derby
Top Pros
Top Cons
Features
Couchbase ServerApache Derby
NoSQL Databases
Comparison of NoSQL Databases features of Product A and Product B
Couchbase Server
8.9
97 Ratings
1% above category average
Apache Derby
-
Ratings
Performance8.897 Ratings00 Ratings
Availability9.396 Ratings00 Ratings
Concurrency8.894 Ratings00 Ratings
Security8.994 Ratings00 Ratings
Scalability9.295 Ratings00 Ratings
Data model flexibility8.995 Ratings00 Ratings
Deployment model flexibility8.194 Ratings00 Ratings
Best Alternatives
Couchbase ServerApache Derby
Small Businesses
IBM Cloudant
IBM Cloudant
Score 8.4 out of 10
SQLite
SQLite
Score 9.0 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 8.4 out of 10
SQLite
SQLite
Score 9.0 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 8.4 out of 10
SQLite
SQLite
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Couchbase ServerApache Derby
Likelihood to Recommend
8.6
(100 ratings)
7.0
(3 ratings)
Likelihood to Renew
2.1
(3 ratings)
-
(0 ratings)
Usability
8.0
(1 ratings)
-
(0 ratings)
Performance
9.1
(95 ratings)
-
(0 ratings)
Support Rating
8.5
(5 ratings)
-
(0 ratings)
Product Scalability
7.3
(51 ratings)
-
(0 ratings)
User Testimonials
Couchbase ServerApache Derby
Likelihood to Recommend
Couchbase
Best suited when edge devices have interrupted internet connection. And Couchbase provides reliable data transfer. If used for attachment Couchbase has a very poor offering. A hard limit of 20 MB is not okay. They have the best conflict resolution but not so great query language on Couchbase lite.
Read full review
Apache
If you need a SQL-capable database-like solution that is file-based and embeddable in your existing Java Virtual Machine processes, Apache Derby is an open-source, zero cost, robust and performant option. You can use it to store structured relational data but in small files that can be deployed right alongside with your solution, such as storing a set of relational master data or configuration settings inside your binary package that is deployed/installed on servers or client machines.
Read full review
Pros
Couchbase
  • Couchbase performance is exceptional both for in-memory and persisted transactions.
  • Handling of node failures and cluster rebalancing (high availability).
  • Enterprise support from Couchbase themselves
  • Good documentation
  • Streaming of bucket (database) level mutations via their Database Change Protocol (DCP).
  • Replication of datasets between native clients and Couchbase buckets
  • Handling of simultaneous writes to the same record with performance penalties
Read full review
Apache
  • Apache Derby is SMALL. Compared to an enterprise scale system such as MSSQL, it's footprint is very tiny, and it works well as a local database.
  • The SPEED. I have found that Apache Derby is very fast, given the environment I was developing in.
  • Based in JAVA (I know that's an obvious thing to say), but Java allows you to write some elegant Object Oriented structures, thus allowing for fast, Agile test cases against the database.
  • Derby is EASY to implement and can be accessed from a console with little difficulty. Making it appropriate for everything from small embedded systems (i.e. just a bash shell and a little bit of supporting libraries) to massive workstations.
Read full review
Cons
Couchbase
  • The N1QL engine performs poorly compared to SQL engines due to the number of interactions needed, so if your use case involves the need for a lot of SQL-like query activity as opposed to the direct fetch of data in the form of a key/value map you may want to consider a RDBMS that has support for json data types so that you can more easily mix the use of relational and non-relational approaches to data access.
  • You have to be careful when using multiple capabilities (e.g. transactions with Sync Gateway) as you will typically run into problems where one technology may not operate correctly in combination with another.
  • There are quality problems with some newly released features, so be careful with being an early adopter unless you really need the capability. We somewhat desperately adopted the use of transactions, but went through multiple bughunt cycles with Couchbase working the kinks out.
Read full review
Apache
  • It may not scale as well as some more mature database products.
  • Used it primarily from the command line with openjpa and jdbc, and from third-party clients such as Squirrel.
  • May benefit by providing more sophisticated tools to optimize query performance.
Read full review
Likelihood to Renew
Couchbase
I rarely actually use Couchbase Server, I just stay up-to-date with the features that it provides. However, when the need arises for a NoSQL datastore, then I will strongly consider it as an option
Read full review
Apache
No answers on this topic
Usability
Couchbase
Couchbase has been quite a usable for our implementation. We had similar experience with our previous "trial" implementation, however it was short lived.
Couchbase has so far exceeded expectation. Our implementation team is more confident than ever before.
When we are Live for more than 6 months, I'm hoping to enhance this rating.
Read full review
Apache
No answers on this topic
Performance
Couchbase
One of Couchbase’s greatest assets is its performance with large datasets. Properly set up with well-sized clusters, it is also highly reliable and scalable. User management could be better though, and security often feels like an afterthought. Couchbase has improved tremendously since we started using it, so I am sure that these issues will be ironed out.
Read full review
Apache
No answers on this topic
Support Rating
Couchbase
I haven't had many opportunities to request support, I will look forward to better the rating. We have technical development and integration team who reach out directly to TAM at Couchbase.
Read full review
Apache
No answers on this topic
Alternatives Considered
Couchbase
The Apache Cassandra was one type of product used in our company for a couple of use-cases. The Aerospike is something we [analyzed] not so long time ago as an interesting alternative, due to its performance characteristics. The Oracle Coherence was and is still being used for [the] distributed caching use-case, but it will be replaced eventually by Couchbase. Though each of these products [has] its own strengths and weaknesses, we prefer sticking to Couchbase because of [the] experience we have with this product and because it is cost-effective for our organization.
Read full review
Apache
SQLite is another open-source zero-cost file-based SQL-capable database solution and is a good alternative to Apache Derby, especially for non-Java-based solutions. We chose Apache Derby as it is Java-based, and so is the solution we embedded it in. However, SQLite has a similar feature set and is widely used in the industry to serve the same purposes for native solutions such as C or C++-based products.
Read full review
Scalability
Couchbase
So far, the way that we mange and upgrade our clusters has be very smooth. It works like a dream when we use it in concert with AWS and their EC2 machines. Having access to powerful instances along side the Couchbase interface is amazing and allows us to do rebalances or maintenance without a worry
Read full review
Apache
No answers on this topic
Return on Investment
Couchbase
  • Great performance.
  • Leading Couchbase Lite capabilities for mobile use.
  • Developers' learning curve with replica reads and multi cluster can be long. Needs guidance and nurturing.
  • Cluster maintenance during OS patching, etc. has multiple ways to approach. Operational teams may need some guidance.
Read full review
Apache
  • Being Open source, the resources spent on the purchase of the product are ZERO.
  • Contrary to popular belief, open source software CAN provide support, provided that the developers/contributors are willing to answer your emails.
  • Overall, the ROI was positive: being able to experiment with an open source technology that could perform on par with the corporate products was promising, and gave us much information about how to proceed in the future.
Read full review
ScreenShots