IBM solidDB vs SingleStore comparison

IBM solidDB is a relational database server that combines the high performance of in-memory tables with the nearly unlimited capacity of disk-based tables.

Pure in-memory databases are fast, but strictly limited by the size of memory. Pure disk-based databases allow nearly unlimited amounts of storage, but their performance is dominated by disk access. Even if the computer has enough memory to store the entire database in memory buffers, database servers that are designed for disk-based tables can be slow because the data structures that are optimal for disk-based tables are far from being optimal for in-memory tables. The solidDB solution is to provide a single hybrid database server that contains two optimized engines inside it:

• The main-memory engine (MME) is optimized for in-memory access.
• The disk-based engine (DBE) is optimized for disk-based access.

Both engines coexist inside the same server process, and a single SQL statement can access data from both engines.

SingleStore is headquartered in San Francisco, California, and offers SingleStoreDB, which combines transactional, analytical, & vector data workloads in a real-time, unified, distributed SQL database that is MySQL and MongoDB wire protocol-compatible. SingleStoreDB Cloud is offered as a managed service on AWS, Google, and Azure and in private clouds including IBM Cloud Pak for Data and Red Hat OpenShift. Other partners (50+ in all) include HPE, Twingo, Data-Sleek, Datadog, and Arcion. SingleStoreDB Self-Managed runs on premise/containers/Kubernetes. SingleStore has offices in Sunnyvale, Seattle, Portland, Raleigh, Boston, London, Dublin, Lisbon, Kyiv, Hyderabad, and Singapore, with remote workers worldwide. It has hundreds of customers including 100+ Fortune 500, Forbes Global 2000, and Inc. 5000 brands across 37 verticals, with the top four being financial services and fintech; media, streaming, and telecommunications; adtech/martech/salestech; and retail/eCommerce. SingleStore platform features include Code Engine with WASM, Data API, dbt Connector, Limitless Point-in-Time Recovery, MongoDB API, Pipelines, Unlimited (Bottomless) Storage, and Workspaces.