Connection.Options (gb.db)

Return or set the connection options.

These options are specific to the database type.

At the moment, all MySQL and PostgreSQL connection options should be supported. Other database drivers have no options at the moment.

MySQL options

The list of MySQL options is described here: https://dev.mysql.com/doc/c-api/8.0/en/mysql-options.html

The name of the option is its MySQL name, with the MYSQL_ or MYSQL_OPT_ prefix removed.

The name is case insensitive.

The value of the PROTOCOL, SSL_MODE and SSL_FIPS_MODE options, that take their value among integer constants, is defined by a string corresponding to the value part of the constant symbol.

Example

PostgreSQL options

The list of PostgreSQL options is described here: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS

The name of the option is its PostgreSQL name unmodified.

The name is case insensitive.

All options values are converted to string before being sent to the PostgreSQL API.

Example