SingleStore
SingleStore (formerly MemSQL) is a distributed, relational, SQL database management system[2] (RDBMS) that features ANSI SQL support, it is known for speed in data ingest, transaction processing, and query processing.[3][4] 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.[5][6] 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.[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.[8] HistoryOn April 23, 2013, SingleStore launched its first generally available version of the database to the public as MemSQL.[9] Early versions supported row-oriented tables, and were optimized for cases where all data fit within main memory. Shortly after launch, MemSQL added general support for an on-disk column-based storage format to work alongside the in-memory rowstore.[10] On October 27, 2020, MemSQL rebranded to SingleStore to reflect a shift in focus away from exclusively in-memory workloads.[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.[12] In May, the company introduced additional tools aimed at enhancing generative AI (GenAI) and analytics capabilities.[13] In July 2023, SingleStore announced a partnership with AWS to advance real-time data analytics and AI applications.[14] In August 2023, IBM announced a collaboration with SingleStore to integrate its watsonx.ai platform for developing generative AI applications.[15] In January 2024, SingleStore announced a new capability under the name SingleStore Kai that added MongoDB API compatibility to SingleStore allowing users to bring in data from MongoDB and run the same queries within SingleStore.[16] In September 2024, SingleStore announced its integration with Snowflake by making SingleStore available as a Snowflake Native App in the Snowpark Container Services (SPCS) marketplace.[17][18] In October 2024, the company announced the acquisition of BryteFlow, a leading data integration platform. The move expanded SingleStore’s capacity to ingest data from a wide range of sources like SAP, Oracle, Salesforce, and many more, enabling customers to operationalize data from their CRM and ERP systems at scale and in real time.[19][20][21] Headquartered in San Francisco, California, in June 2021 SingleStore opened an office in Raleigh, North Carolina. Its other offices include Sunnyvale, California; Seattle, Washington; London, England; Hyderabad, India; and Lisbon, Portugal.[22] FundingIn January 2013, SingleStore announced it raised $5 million. Since then, the company has raised $318.1M from investors including Khosla Ventures, Accel, Google Ventures, Dell Capital and HPE, among others.[23] In October 2022, SingleStore closed Series F-2 and welcomed new investor Prosperity7.[24]
Distribution formatsSingleStore can be downloaded for free and run on Linux for systems up to 4 leaf nodes of 32 gigs RAM each; an Enterprise license is required for larger deployments and for official SingleStore support.SingleStore is also available as a managed service named SingleStore Helios, available in various regions in Google Cloud and Amazon Web Services. The underlying engine and potential system performance are identical in all distribution formats.[1] SingleStore includes a set of tools, called SingleStore Tools, for installing, managing, and monitoring its distributed database across multiple machines. It also offers a browser-based interface, SingleStore Studio, for running queries, monitoring the database, and viewing cluster health and status.[2] See also
References
External links |