SingleStore
A distributed SQL database, formerly MemSQL, that serves transactions and real-time analytics from the same tables. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- SingleStore
- Created by
- Eric Frenkiel, Nikita Shamgunov, Adam Prout
- First release
- 2013
- License
- Proprietary
- Open source
- No
- Pricing
- Free with paid plans
- Website
- https://www.singlestore.com
- Written in
- C++
- Data model
- Relational, Document, Vector
- Storage layout
- Hybrid row and column
- Workload
- Both (HTAP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL (MySQL dialect)
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Distributed cluster, Managed cloud
- Scaling
- Natively distributed
- Create, read, update, delete
- Create: fast (Fast ingest into an in-memory segment); Read: fast (Vectorized columnstore scans); Update: moderate (Fine in bulk, rewrites columnstore segments); Delete: moderate (Fine in bulk, rewrites columnstore segments)