Couchbase vs SingleStore (formerly MemSQL)

• 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

• Return results of complex queries scanning TBs of data in sub-seconds.
• Customer support team answer tickets quickly and provide guidance.
• MySQL engine which allows to query using simple MySQL drivers from different clients.
• Queries profiling is easy to use and helps investigating performance.

Read full review

• 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

• We wish the product had better support for High Availability of the aggregator. Currently the indexes generated by the two different aggregators are not in the same sequential space and so our apps have more burden to deal with HA.
• More tools for debugging issues such as high memory usage would be good.
• The price was the one that kept us away from purchasing for the first few years. Now we are able to afford due to a promotion that gives it at 25% of the list price. Not sure if we'll continue after the promotion offer expires in another 2 years.

Read full review

• 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

• As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data.
• Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog.

Read full review