SingleStore (formerly MemSQL) is a distributed, relational, SQL database management system (RDBMS) that features ANSI SQL support, it is known for speed in data ingest, transaction processing, and query processing.
SingleStore stores relational data, JSON data, geospatial data, key-value vector data, and time series data. It can be run in various Linux environments, including on-premises installations, public and private cloud providers, in containers via a Kubernetes operator, or as a hosted service in the cloud known as SingleStore Helios.
Recent updates have included bi-directional integration with Apache Iceberg, faster vector search, enhanced full-text search, autoscaling and a ‘bring your own cloud’ deployment. 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.