Highly Compatible

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