Company
Date Published
Author
Conor Doherty
Word count
1052
Language
English
Hacker News points
None

Summary

SingleStore is a relational database management system that offers both familiar SQL interface and leading-edge features such as memory-optimized data storage, distributed architecture, and software-only deployment. It stores data in memory for rowstore tables and on disk for columnstore tables, with options to store data in compressed format on flash/SSD/disk. SingleStore ensures durability by writing logs and full database snapshots to disk, and supports transaction processing with configurable parameters. The system is architected as a cluster of aggregator and leaf nodes, allowing for scalability and flexibility. Licensing is based on total RAM capacity of the cluster, rather than CPU cores, enabling customers to maximize resources without licensing overhead.