Database

The Database tab sets your project's database connection. Go to Settings → Database to access these settings.

Database configuration

Setting	Default	Description
Database Type	PostgreSQL	The database system to use.
Host	`localhost`	Database server hostname or IP address.
Port	`5432`	Database server port.
Username	(required)	Database username for authentication.
Password	(hidden)	Database password. Click the eye icon to reveal.
Database Name	(required)	Name of the database to connect to.

Set the database connection pool behavior.

Setting	Default	Description
Maximum Connections	`20`	Maximum number of connections in the pool.
Minimum Connections	`5`	Minimum number of connections in the pool.
Idle Timeout (ms)	`30000`	Time in milliseconds after which idle connections are closed.
Acquire Timeout (ms)	`60000`	Time in milliseconds to wait for a connection from the pool.

Set how the database schema synchronizes.

Setting	Description
Sync on Startup	When turned on, syncs the database schema on application startup.
Force Recreate on Sync	When turned on, drops and recreates tables on sync. Only visible if Sync on Startup is enabled.
Alter on Sync	When turned on, alters tables to match the schema on sync. Only visible if Sync on Startup is enabled.
SSL Enabled	When turned on, uses SSL for the database connection.

warning

Force Recreate on Sync drops and recreates all tables. Any data in those tables is permanently lost.