One database protocol to rule them all? List of databases that support the MySQL protocol
I was thinking of the value of using a single database protocol for all your database needs. One driver, that you could use for OLTP, OLAP and any other need you could think of. So here is a list that I compiled of known databases that use the mysql protocol.
mysql: MySQL is an open-source relational database management system (RDBMS).[5][6] Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter My,[7] and “SQL”, the acronym for Structured Query Language.
Oceanbase database (OLTP): OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards. https://en.oceanbase.com/
Dolt database (OLTP): Dolt is a SQL database you can fork, clone, branch, merge, push and pull just like a Git repository. Connect to Dolt just like any MySQL database to run SQL queries. Use the command line interface to import CSV files, commit your changes, push them to a remote, or merge your teammate’s changes. https://www.dolthub.com/
StarRocks (OLAP): StarRocks is a next-gen sub-second MPP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics and ad-hoc query. https://www.starrocks.io/
TiDB (OLTP+OLAP): TiDB is an open-source distributed SQL database that supports Hybrid Transactional and Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability. https://www.pingcap.com/
Sphinx Search (Search): Sphinx is a fulltext search engine that provides text search functionality to client applications. https://sphinxsearch.com/
SingleStore: SingleStore is a proprietary, cloud-native database designed for data-intensive applications. A distributed, relational, SQL database management system that features ANSI SQL support, it is known for speed in data ingest, transaction processing, and query processing. https://docs.singlestore.com/cloud/connect-to-your-workspace/connect-with-mysql/connect-with-mysql-client/
More info at https://github.com/alberttwong/databasecomparison
