SingleStore outlook from a guy who handles infra , traffic and latencies
March 16, 2022
SingleStore outlook from a guy who handles infra , traffic and latencies
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with SingleStore (formerly MemSQL)
I am a DevOps Engineer and I work on Kubernetes, Cloud, I had a use case where I was working on creating a product that can calculate Kubernetes and cloud costs and represent it in that use case I was supposed to ingest data which was being populated in s3 to my database on which I can run queries, this using SingleStore could have been seem-less as it makes data ingestion from cloud simpler and since it helps running lot vol queries with smaller response time could have helped me lower the latency of my service.
- Compatibility with S3 and data formats such as Parquet, JSON, and CSV
- Can be Deployed on a Kubernetes Cluster and can be scaled seamlessly.
- Great UI and support documentation available to look and work around.
- Scale out capability
- Fast data ingestion and queries
- Can be used to lower the latencies of various services
- Did not find support for User Defined Functions.
- It opens a new query result tab and that feels irritating to me personally.
- Lot of RAM required while running Developer instances locally.
- Was easily scalable and was easy to deploy hence useful
- Fast data ingestion and queries
- Reduce the latency of my microservice
SingleStore I would say is easy to scale, deploy, and a future-ready database and I would recommend this to each and everyone in the DevOps community as it has got great capabilities to get deployed on the cloud and connect to your resources on the cloud makes it outstanding and a database for the future.
Well honestly, Initially I thought it would be just another SQL Relational Database Management System but when I actually signed up and use SingleStore, I was amazed to see such integration of intuitive and easy-to-use UI and such powerful performance. So, the CSV for cosmetic shop data was pretty big in size(415 MB extracted) containing records in million, was shocked to see how fast the queries were running on top of the data once loaded to SingleStore, I even tried running some queries on a sample stock trade data and then running queries which involved compute-intensive operations like joins and the results were returned in no time. Also, I never had an experience before using SingleStore where I created a pipeline from S3 in seconds. Now, coming to your questions
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