Help Center/ GaussDB/ M-Compatibility Developer Guide(Centralized)/ Application Development Guide/ Development Specifications
Updated on 2025-10-23 GMT+08:00
View PDF
Share

Development Specifications

If the connection pool mechanism is used during application development, comply with the following specifications before you return the connection to the connection pool:
  • If GUC parameters are set in the connection, run SET SESSION AUTHORIZATION DEFAULT;RESET ALL; to clear the connection status.
  • If a temporary table is used, delete the temporary table.

If you do not do so, the connection state in the connection pool will remain, which affects subsequent operations using the connection pool.

Table 1 describes the compatibility of application development drivers.
Table 1 Compatibility description

Driver

Compatibility Description

pymysql

The new driver is forward compatible with the database. To use the new features added to the driver and database, you must upgrade the database.
  • Applications can be connected only after the plat_compat_server_port parameter is set correctly and started successfully.
  • When connecting to applications, ensure that SSL is used for secure TCP/IP connection or RSA is used for login password encryption to ensure user information security.