Highly Compatible

SingleStoreDB is an ODBC-compatible database. It is wire protocol compatible with MySQL so that applications that use a MySQL driver can connect to and use SingleStoreDB transparently. SingleStoreDB supports a broad subset of the MySQL syntax and built-in functions, so most queries that run against MySQL will work unchanged against SingleStoreDB. SingleStoreDB also supports advanced features such as distributed architecture, high performance via compiled queries, columnstores, extensibility, Geospatial, JSON, Window Functions, pipelines, full-text search, time series extensions, approximate fast aggregate functions, and S3, Azure Blob Store, and GCS integration.

In addition to MySQL wire compatibility, SingleStoreDB also integrates well with the stream processing framework Apache Spark to provide a simple way to create and manage real-time data pipelines.

For more client compatibility and integration information, see:

Last modified: August 15, 2023

Was this article helpful?