SingleStore

SingleStore, formerly MemSQL, is a database company that provides a distributed SQL database designed for real-time analytics and mixed workloads. It combines an in-memory rowstore with an on-disk columnstore to support transactional and analytical processing at large scale, delivering low-latency queries across large data sets.

The architecture is distributed and shared-nothing, with data sharded across nodes. SingleStore supports ANSI SQL and ACID transactions and provides a converged engine for OLTP and OLAP workloads. It offers features such as JSON and geospatial support, streaming data ingestion, and built-in connectors for common data platforms. Deployments can be on-premises, in the cloud, or via a managed service called SingleStore Cloud. The database can run in Kubernetes environments and supports cloud-native operations.

SingleStore was founded in 2011 by Eric Frenkiel and Nikita Shamgunov as MemSQL and rebranded to SingleStore in 2020 to reflect its expanded product scope. The company markets SingleStoreDB as the core database product and offers SingleStore Cloud as a fully managed service, along with a Community Edition for development and testing and enterprise editions with advanced security and governance features.

Common use cases include real-time dashboards and analytics, operational analytics, fraud detection, telemetry and streaming data applications, and workload consolidation where both transactional processing and analytical queries are required.