Data Dictionary #

SphereEx-DBPlusEngine is compatible with some of the data dictionaries of underlying databases. Currently, it has been adapted to be compatible with the meta-databases of MySQL and PostgreSQL. You can query the meta-database directly in JDBC connections using SQL statements. However, SphereEx-DBPlusEngine has limited support for system databases/tables (such as information_schema and pg_catalog). When connecting via certain graphical database clients to the proxy, there may be client or proxy errors. You can use command-line clients (mysql, psql, gsql, etc.) to connect to the proxy for validation. Additionally, for MySQL databases, when you execute the ANALYZE command on the proxy side, it will be passed through to the underlying database.

For specific details, refer to the Data Dictionary.