SingleStore as the backbone for our data analytics platform.
Overall Satisfaction with SingleStore (formerly MemSQL)
With SingleStore, we are able to replace multiple other databases and started migrating from on-premise to SAAS. As SingleStore provides both scenarios, the migration to the cloud will be a smart and simple one. We now use SingleStore for our data and analytics environment. As we now can use the pipelines towards our data lakes and send data via procedures into our tables, we have achieved the next step in our data management by adding additional metadata during the ingestion. Using text search and the geospatial functions adds more functionality than we had before in our previous databases. The performance and scalability are beyond our expectations.
- The scenario to migrate on-premise and scale up to the cloud as a SAAS.
- Using HTAP means we can now use our database for transactions and analytics.
- The main language is similar to MYSQL, so our organization has already the knowledge to master the system.
- The SingleStore academy is a good program to support our organization to master the environment.
Pros
- Performance on large sets of data for analytics.
- Row based and column based can be used and mixed.
- Time series, geo spatial and text search function to add to our platform.
- Scalability, so we can continue to deliver the same performance.
Cons
- Does not yet support foreign keys.
- 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.
- Azure Synapse Analytics (Azure SQL Data Warehouse) and Azure SQL Database
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
Comments
Please log in to join the conversation