I have had a great experience using SingleStore. It can ingest massive amounts of change events from Kafka and keep up. It ingests this data within 3-5 seconds of update in our main application. Most of the queries we send to SingleStore come back within 5 seconds and work well with highly concurrent (thousands of customers) environments. For providing customer-facing dashboards and reporting, it is really fast and everything I expect. It also has a great ecosystem with its managed service running in AWS, Azure, and GCP, with support for customer-managed keys and other enterprise features we need. It also has cool newer features like database branching and fast JSON queries (it treats JSON like any other columnar data). It is like a really fast version of Snowflake or Databricks. It is easy to get up and going with SingleStore pipelines (no external tools like Kafka Connect or Apache Flink are required since they have SingleStore pipelines), and customer support is great too when I wasn't able to figure it out on my own. Review collected by and hosted on G2.com.

It isn't open source, which I prefer. Despite being proprietary, they do make it fairly easy to use their free version on Docker or their managed free forever solution (but quite limited). The sales/procurement process can be a bit onerous too. Review collected by and hosted on G2.com.

I like the scalability, versatililty in the product with architecture itself which can be used for multi models. Review collected by and hosted on G2.com.

I feel singlestore is not beginner friendly as early stage developer in AI era. Review collected by and hosted on G2.com.

Accessing and Loading relational data into tables is pretty efficient, reliable and fast.

Having Singlestore employee as a consultant in the organisation helped us get answers from Singlestore to resolve a lot of minor issues and questions we had with this product. Review collected by and hosted on G2.com.

It lacks replication product to replicate data on table by table basis from one cluster to another remote cluster.

We need a reject file created for all rejected rows during pipeline load of millions of rows of a table, instead of abending at the first rejected row. Review collected by and hosted on G2.com.

I use Singlestore daily, and it has great features. Their docs are very thorough, which makes it easy to find answers to question. Their support is very responsive. Review collected by and hosted on G2.com.

Some of things inherent with the implementation of SingleStore make some tasks tedious, such as updating an enum column. Review collected by and hosted on G2.com.

The fact that it's the best of both worlds of row store and column store. It's easy to use and setup. We've been using it for a lot of our high throughput use cases and it has worked wonders. Review collected by and hosted on G2.com.

A lot of the technology and functionality as it comes with a proprietary database is under the hood which makes is difficult to debug issues. And it takes a lot of back and forth with their support team to explain the issue and hopefully get a resolution. Review collected by and hosted on G2.com.

Query and Ingestion Speed at Scale over Multi-Model Storage w/ Simplicity . Review collected by and hosted on G2.com.

Medium UX for Self-Hosted versions and medium materialization features Review collected by and hosted on G2.com.

Singlestore has made our data processing much easier and faster with its tooling Review collected by and hosted on G2.com.

Pipelines can be slow and there's not very many logs around them Review collected by and hosted on G2.com.

Singlestore is a MySQL drop-in solution. It supports Mysql Protocol. This database cluster solution allows you to scale horizontally and also vertically. You can add aggregators to scale high concurrency or leaf nodes to shard your data (Singlestore can rebalance the data with just 1 SQL command). Singlestore supports a fast array of analytical functions. You can also ingest data from their pipeline feature. Using SQL, you can create pipelines to connect to S3, Kafka, HDFS, Azure, and more and consume data in real-time without locking tables. Review collected by and hosted on G2.com.

There are some limitations. You cannot use Foreign Keys (FK). Modifying clustered keys is not supported. Altering tables also has some limitations. Auto-incremental values are not always sequentials. Review collected by and hosted on G2.com.

I love how I'm able to use one database for transactional data (like storing users, and any associated data) alongside analytical data (like mass querying records).

Every other solution I looked at required me to maintain 2 seperate databases, certainly not ideal in any means.. Review collected by and hosted on G2.com.

Their managed solution starts out hefty, and I do wish they had cheaper options available. However they have a fantastic self-hosted version, which means there is no downsides to SingleStore. Review collected by and hosted on G2.com.

I really enjoyed using the SingleStore website! I found the tutorial and UI to be very clean and easy to use. The tutorial was helpful as well to some extent. The blogs/tutorials you guys write I think are instrumental in helping new users use your platform and follow along. More on this in another question. In terms of product, I liked being able to visualize the different parts of the node aggregation and seeing how the data was being inserted as well as its speed. I think being able to visualize the nodes working together was helpful in seeing the data being moved from one location to another. I think this is helpful in understanding where the costs are going as well, and what steps I can take in order to reduce cost while not hurting performance. Review collected by and hosted on G2.com.

Not too much - I disliked the tutorials/documentation surrounding the work (to some extent). They were slightly different than what I actually needed to do (according to the Upwork specs). I think tutorials are a vital way to onboard new people to the platform. Making sure that each step is perfectly clear and identical (or near identical) to what needs to be done is important since having the first-impression onboarding process be as frictionless as possible will really set a positive tone for using your service more. As a developer, clear documentation is everything! Review collected by and hosted on G2.com.