Skip to main content
TrustRadius
SingleStore

SingleStore
Formerly MemSQL

Overview

What is SingleStore?

SingleStore aims to enable organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.

Read more

Learn from top reviewers

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing

OnDemand

$0.69

Cloud
per hour

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttps://www.singlestore.com/pricing/

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Details

What is SingleStore?

SingleStore enables organizations to quickly and easily scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.

SingleStore Features

  • Supported: Vector database
  • Supported: Transactions (OLTP)
  • Supported: Analytics (OLAP)
  • Supported: SQL
  • Supported: JSON
  • Supported: Real-time

SingleStore Videos

SingleStore NOW 2024: Outreach / AI- and Data-Driven Sales
SingleStore Now 2024 / Snowflake + SingleStore: Better Together
SingleStore NOW 2024: Adobe / What’s New in SingleStore: AI in Production
SingleStore Now 2024: AWS / Enterprise AI Innovation: Gen AI Experimentation
SingleStore Now 2024: 6sense / AI in Production: Lessons Learned
SingleStore Now 2024: LlamaIndex / Building Multi-Agent RAG Systems
SingleStore NOW 2024 / LiveRamp: Building the World’s Largest Identity Graph without a Graph DB
SingleStore Now 2024: SAS + SingleStore = Enterprise AI at Scale
SingleStore Now 2024 / Pyler: AI-Powered Brand Safety
SingleStore Now 2024: Groq / AI Trends, and Running LLMs in the Enterprise
SingleStore Now 2024: AI with SingleStore, IBM StreamSets and watsonx.ai

SingleStore Integrations

SingleStore Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsLinux
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

SingleStore aims to enable organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.

Oracle Database, Microsoft SQL Server, and MongoDB are common alternatives for SingleStore.

Reviewers rate Performance highest, with a score of 9.2.

The most common users of SingleStore are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

(1-5 of 7)

SingleStore is more reliable, faster at half the cost

Rating: 8 out of 10
December 19, 2024
Vetted Review
Verified User
SingleStore
1 year of experience
We use it as our analytical database. It is more reliable and faster than our previous vendor. It also allowed us to replace another service that frees up $1500/month. We retrieve thousands of records at a time quickly.
  • Delivering thousands of records at blazing fast speeds
  • full text search
  • scaling
Cons
  • Improved UI for their portal
  • Better ticket system
  • More workers on workspace
Reliable, scales and you can do full text search across the data. Customer support ticketing system could be improved but it's barely a con

SingleStore as the backbone for our data analytics platform.

Rating: 9 out of 10
May 16, 2021
Vetted Review
SingleStore
1 year of experience
SingleStore as the backbone for our Data Analytics platform

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.
  • 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.
Migrating existing databases to one instance, accelerate and scale-out existing data warehouses/analytics platforms. Replace HIVE for SingleStore, which will boost your overall performance and support your data management. Get ready for the cloud by using it on-premise, your own cloud/data center, or as a SAAS. The functionality is the same and migrating will be smooth.

SingleStore DB (formerly MemSQL) never fails you

Rating: 10 out of 10
September 24, 2020
Vetted Review
Verified User
SingleStore
5 years of experience
We use SingleStore DB (formerly MemSQL) to store a real-time feed of all kinds of open source data. The data get full-text indexed, stored in start schema, and instantly ready for analysis. Multiple departments have access to multiple dashboards backed up with SingleStore DB (formerly MemSQL).
  • Ingesting high volume of data in real-time.
  • Excellent query performance (response in milliseconds).
  • Feature rich, json support, full-text search.
  • Minimum administration is needed.
Cons
  • Cross-cluster queries
  • SingleStore DB (formerly MemSQL) procedural SQL syntax can be simplified
  • Materialized views
  • Implementing recursion in queries
  • Tag cloud generator from a full-text index
SingleStore DB (formerly MemSQL) is good for a high-volume, real-time data feed, a high number of concurrent queries, and excellent for both OLAP and OLTP workloads. It's not good for unstructured data store.

Maximum performance and scalability in one.

Rating: 9 out of 10
December 15, 2020
JO
Vetted Review
Verified User
SingleStore
1 year of experience
Right now we’re using [SingleStore (formerly MemSQL)] in the whole core platform, we were looking for a database that could handle a huge amount of transactions at the same time without loosing any and have the reliability of writing and storing the records fast so other services can use the data for finalizing the transactions. Also we were aiming to have a product which could be used as a storage solution for Data Scientists and our back office platform.
  • The fastest speed for querying compared with traditional relational database
  • Support JSON and full text search which can be used by API’s
  • Nearly zero admin tasks once it’s running
  • You can use it’s data streaming pipeline with Kafka
Cons
  • It doesn’t provide redistribution when you reach the maximum node capacity
  • The Graphical Interface could have a revamp, it’s a little bit laggy
  • You cannot run it local so development should be made always using cloud instances
I think SingleStore [(formerly MemSQL)] should be used in every modern system which needs an analytical tool provided with the database, where performance matters and when you need fast scaling. The database is going to use a lot of resources so if the scenario is cost sensitive then perhaps is not the best solution in terms of infrastructure.

Great product, amazing team

Rating: 10 out of 10
December 01, 2022
Vetted Review
Verified User
SingleStore
1 year of experience
It's our main data store. SingleStore replaced MySQL, PostgreSQL, Redis and Elasticsearch. It's being used for OLAP, OLTP, search and cache at the same time.
SingleStore has seriously decreased our infrastructure complexity, allowing us to move faster and with more confidence.
It has also allowed us to decrease infrastructure cost.
Cons
  • **Much** better monitoring
  • Alerting
  • Smaller clusters offerings
  • More granular scaling
  • Better search features
  • Multi language support for search
  • Slow query visibility and analysis in real production workload
  • Mixing OLAP and OLTP in the same cluster
  • Support and customer success team really is great
  • OLAP performance
  • Predictable performance scaling with cluster resources
It has transformed into my go to database software. The only scenario in which I wouldn't use or recommend it, is if their base managed cluster is too expensive and I don't want to managed it myself
Return to navigation