Identica

persistence.yml

Every setting of persistence.yml.

persistence.yml chooses the database that stores accounts and sets up the connection to it. Database explains the choice, upgrades and sharing a database between proxies.

The database is opened on startup: changes take effect on the next start. A database that cannot be reached stops the startup.

type

Takes"SQLITE", "H2", "MYSQL", or "POSTGRES"

Default"SQLITE"

Affectswhich database stores the accounts

Values are case-sensitive. Identica uses SQLite when the file does not set type. Any other value stops the startup with an error that names the accepted values, and the file is left as it is, so Identica never runs on a database the file did not ask for.

"MYSQL" works with MySQL 8.0.19 or newer and with MariaDB.

Fields of each type

Each type has fields of its own. After changing type, start the proxy once so Identica writes the new type's fields, then fill them in.

file

Takesa file name or relative path

Default"identica.db"

Affectsthe SQLite file, relative to the data directory

A blank value uses identica.db.

hikari

The connection pool, HikariCP. The defaults suit almost every network; change them for a reason such as a connection limit of your database server.

poolName

Advanced

Takesa string

Default"Identica"

Affectsthe pool's name in logs

maximumPoolSize

Advanced

Takesan integer

Default10

Affectsthe most connections Identica keeps open

minimumIdle

Advanced

Takesan integer

Default2

Affectshow many unused connections are kept ready

connectionTimeout

Advanced

Takesa number of milliseconds

Default30000

Affectshow long Identica waits for a free connection before giving up

idleTimeout

Advanced

Takesa number of milliseconds

Default600000

Affectshow long an unused connection stays open

maxLifetime

Advanced

Takesa number of milliseconds

Default1800000

Affectshow long a connection is used before it is replaced

On this page