config properties database

Version

v3.0.4

database Type

object (database)

database Properties

Property	Type	Required	Nullable	Defined by
conn_max_lifetime	integer	Optional	cannot be null	Config
conn_max_idletime	integer	Optional	cannot be null	Config
database	string	Optional	cannot be null	Config
dialect	string	Optional	cannot be null	Config
host	string	Optional	cannot be null	Config
idle_pool	integer	Optional	cannot be null	Config
password	string	Optional	cannot be null	Config
pool	integer	Optional	cannot be null	Config
port	string	Optional	cannot be null	Config
url	string	Optional	cannot be null	Config
user	string	Optional	cannot be null	Config

conn_max_lifetime

conn_max_lifetime sets the maximum amount of time a connection may be reused. It must be a (possibly signed) sequence of decimal numbers, each with optional fraction and a unit suffix, such as "300ms", or "2h45m". Valid time units are "ns", "us" (or "µs"), "ms", "s", "m", "h".

conn_max_lifetime

• is optional

• cannot be null

conn_max_lifetime Type

integer

conn_max_idletime

conn_max_idletime sets the maximum number of connections in the idle connection pool. It must be a (possibly signed) sequence of decimal numbers, each with optional fraction and a unit suffix, such as "300ms", or "2h45m". Valid time units are "ns", "us" (or "µs"), "ms", "s", "m", "h".

conn_max_idletime

• is optional

• cannot be null

conn_max_idletime Type

integer

database

database determines the name of the database schema to use.

database

• is optional

• cannot be null

database Type

string

database Default Value

The default value is:

"hanko"

dialect

dialect is the name of the database system to use.

dialect

• is optional

• cannot be null

dialect Type

string

dialect Constraints

enum: the value of this property must be equal to one of the following values:

Value	Explanation
"postgres"
"mysql"
"mariadb"
"cockroach"

dialect Default Value

The default value is:

"postgres"

host

host is the host the database system is running on.

host

• is optional

• cannot be null

host Type

string

host Default Value

The default value is:

"localhost"

idle_pool

idle_pool sets the maximum number of connections in the idle connection pool.

idle_pool

• is optional

• cannot be null

idle_pool Type

integer

idle_pool Default Value

The default value is:

0

password

password is the password for the database user to use for connecting to the database.

password

• is optional

• cannot be null

password Type

string

password Default Value

The default value is:

"hanko"

pool

pool sets the maximum number of open connections to the database.

pool

• is optional

• cannot be null

pool Type

integer

pool Default Value

The default value is:

5

port

port is the port the database system is running on.

port

• is optional

• cannot be null

port Type

string

port Default Value

The default value is:

"5432"

url

url is a datasource connection string. It can be used instead of the rest of the database configuration options. If this url is set then it is prioritized, i.e. the rest of the options, if set, have no effect.

Schema: dialect://username:password@host:port/database

url

• is optional

• cannot be null

url Type

string

url Examples

postgres://hanko:hanko@localhost:5432/hanko

user

user is the database user to use for connecting to the database.

user

• is optional

• cannot be null

user Type

string

user Default Value

The default value is:

"hanko"