Overall Satisfaction with SingleStore
We use SingleStore to ingest, store, and process data from our hardware player trackers. The challenge is the amount of data (hundreds of millions of rows) and being able to query it quickly.
- Fast ingest via Pipelines
- Standard SQL syntax
- Fast query times
- The dashboard should show a list of recent backups (you have to run a query to get this information right now)
- We could not run our application using a standard relational database, i.e. Product would not be feasible without SingleStore
- Our developers already know SQL, so nothing new to learn, lower cognitive load for our team
We have not taken advantage of this as we only use SingleStore on a greenfield project. That said, we are using SingleStore ONLY as a database AND session store. We would normally operate a separate Redis (Elasticache) instance for session storage.
We knew early on that MySQL (Amazon Aurora) would not be suitable for this workload as it cannot query our time series data as fast as SingleStore. We also use MongoDB Atlas for another application but we could not achieve the raw speed we saw from SingleStore. Our technical staff have used SQL for many years, if we used MongoDB they would need to learn the MongoDB query and aggregation syntax.
Do you think SingleStore delivers good value for the price?
Yes
Are you happy with SingleStore's feature set?
Yes
Did SingleStore live up to sales and marketing promises?
Yes
Did implementation of SingleStore go as expected?
Yes
Would you buy SingleStore again?
Yes