SQL Overview #

SphereEx-DBPlusEngine is a distributed computing engine designed to enhance database performance. It is capable of interfacing with multiple heterogeneous databases, and its compatibility with their syntax is highly natural. Additionally, SphereEx-DBPlusEngine provides SQL syntax support tailored to its own architecture, allowing for greater flexibility in cluster development and management.

Types of SQL #

SphereEx-DBPlusEngine offers support for the following types of SQL:

• Database SQL

SphereEx-DBPlusEngine provides native SQL support for multiple heterogeneous databases. However, the degree of SQL support for each database may be limited. For more information, please refer to the SQL Compatibility section .

• Client SQL

SphereEx-DBPlusEngine supports several SQL statements from various SQL clients, including MySQL Client and PSQL Client. These command-line tools offer built-in SQL for easy database management, such as “show tables” in MySQL and “\d” in PSQL.

• DistSQL

SphereEx-DBPlusEngine also supports an extended SQL syntax known as DistSQL, which is specifically designed to simplify management and maintenance tasks for the engine. For more information, please see the DistSQL Section.