From b617ffd2af71d81c24955c00c1f378325613dec0 Mon Sep 17 00:00:00 2001 From: Jeremy Lin Date: Tue, 26 Apr 2022 17:50:20 -0700 Subject: Add support for database connection init statements This is probably mainly useful for running connection-scoped pragma statements. --- .env.template | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to '.env.template') diff --git a/.env.template b/.env.template index 3c8a5ebb..68c487f4 100644 --- a/.env.template +++ b/.env.template @@ -29,6 +29,17 @@ ## Define the size of the connection pool used for connecting to the database. # DATABASE_MAX_CONNS=10 +## Database connection initialization +## Allows SQL statements to be run whenever a new database connection is created. +## For example, this can be used to run connection-scoped pragma statements. +## +## Statements to run when creating a new SQLite connection +# SQLITE_CONN_INIT="" +## Statements to run when creating a new MySQL connection +# MYSQL_CONN_INIT="" +## Statements to run when creating a new PostgreSQL connection +# POSTGRESQL_CONN_INIT="" + ## Individual folders, these override %DATA_FOLDER% # RSA_KEY_FILENAME=data/rsa_key # ICON_CACHE_FOLDER=data/icon_cache -- cgit v1.2.3