[7] In its latest release, v.8.9, SingleStore added support for continuous ingest from Iceberg tables, as well as Polaris and Hive catalogs, support for foreign languages as well as n-grams in full-text search; simplified pipelines; a no-code interface that simplifies data ingestion from S3, CSV and MongoDB sources; and disk spilling that now works on right and full join, as well as writable views and vector indexes on nullable columns.
This design was based on the idea that the cost of RAM would continue to decrease exponentially over time, in a trend similar to Moore's law.
Shortly after launch, MemSQL added general support for an on-disk column-based storage format to work alongside the in-memory rowstore.
[11] In April 2023, SingleStore introduced new features to enhance real-time AI capabilities, focusing on faster data processing and more efficient AI-driven applications.
Its other offices include Sunnyvale, California; Seattle, Washington; London, England; Hyderabad, India; and Lisbon, Portugal.
Data for rowstore tables is stored completely in-memory, making random reads fast, with snapshots and transaction logs persisted to disk.
[33][34] A single piece of software is installed for SingleStore aggregator and leaf nodes; administrators designate each machine’s role in the cluster during setup.
It also offers a browser-based interface, SingleStore Studio, for running queries, monitoring the database, and viewing cluster health and status.
[37] In December 2021, SingleStore was recognized in the Gartner Magic Quadrant for Cloud Database Management System for the second time in its history; the company first earned the recognition in 2021.