This page allows detailed configuration of the SQLite, MySQL/MariaDb and PostgreSQL database connections.


SQLite

  • Disable pooling, disables the connection pooling. This can improve stability on databases with much data and/or high concurrency but may result in less performance.
  • Max pool size sets the number of connections that maximum can be stored in the pool.
  • Timeout controls the default timeout in seconds for a command/operations


MySQL/MariaDB

  • Validate connections will perform an extra validation before connecting to the MySQL/MariaDB database
  • Use compression will compress data to reduce network traffic when active. 
  • Disable pooling, disables the connection pooling. This can improve stability on databases with much data and/or high concurrency but may result in less performance.
  • Max pool size sets the number of connections that maximum can be stored in the pool.
  • Timeout controls the default timeout in seconds for a command/operations


PostgreSQL

  • Disable pooling, disables the connection pooling. This can improve stability on databases with much data and/or high concurrency but may result in less performance.
  • Max pool size sets the number of connections that maximum can be stored in the pool.
  • Timeout controls the default timeout in seconds for a command/operations