Cassandra vs SingleStore comparison

"The most valuable features of Cassandra are the NoSQL database, high performance, and zero-copy streaming."

"I am satisfied with the performance."

"The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-time updates is paramount."

"The time series data was one of the best features along with auto publishing."

"Cassandra has some features that are more useful for specific use cases where you have time series where you have huge amounts of writes. That should be quick, but not specifically the reads. We needed to have quicker reads and writes and this is why we are using Cassandra right now."

"Since I haven't had years of experience with it, it's still new to me. One valuable feature is its distribution, so I can run it partly in the cloud and part on-prem. That's a feature I'd like to use but haven't yet because we're trying to move to Azure. I don't know if or when that will happen. Ideally, we'd have it distributed over the cloud and on-prem simultaneously, so if something happens to our on-prem, we can keep going in the cloud, like a pay-as-you-go model with Azure."

"Can achieve continuous data without a single downtime because of node to node ring architecture."

"Cassandra is good. It's better than CouchDB, and we are using it in parallel with CouchDB. Cassandra looks better and is more user-friendly."

"The product's initial setup phase was pretty straightforward, with no complex processes."

"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."

"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."

"The product can automatically reinstall and reconfigure in case of a shutdown."

"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."

"The paramount advantage is the exceptional speed."

"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."

"The solution doesn't have joins between tables so you need other tools for that."

"Cassandra could be more user-friendly like MongoDB."

"There were challenges with the query language and the development interface. The query language, in particular, could be improved for better optimization. These challenges were encountered while using the Java SDK."

"The solution is limited to a linear performance."

"Depending upon our schema, we can't make ORDER BY or GROUP BY clauses in the product."

"Maybe they can improve their performance in data fetching from a high volume of data sets."

"Interface is not user friendly."

"The initial setup of Cassandra can be difficult in the configuration. There might be a need to have assistance. The implementation process can six months for connecting to certain databases."

"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."

"Having the ability to migrate servers using a single command would be extremely beneficial."

"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."

"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."

"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."

"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

"We don't get good discounts in Pakistan."

"I use the tool's open-source version."

"We are using the open-source version of Cassandra, the solution is free."

"There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly."

"We pay for a license."

"Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise."

"I don't have the specific numbers on pricing, but it was fairly priced."

"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."

"I would advise users to try the free 128GB version."

"SingleStore is a bit expensive."

"The product's licensing is not expensive. It is comparable."

"They have two main options: cloud installation and bare-metal installation, each with different pricing models."

"The price of the product is okay compared to the other available solutions in the market. SingleStore is a reasonably priced product, considering the functions it offers."