Highly Compatible

SingleStore 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 SingleStore transparently. SingleStore supports a broad subset of the MySQL syntax and built-in functions, so most queries that run against MySQL will work unchanged against SingleStore. SingleStore 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, SingleStore 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?