Skip to main content

Database

Gitploy requires the use of a database backend for persistence. Gitploy uses an embedded SQLite database by default. This article provides alternate databases: MySQL and Postgres.

MySQL​

Gitploy supports mysql 5.6 and higher as the database engine. The below example demonstrates mysql database configuration. See the official driver documentation for more connection string details.

GITPLOY_STORE_DRIVER=mysql
GITPLOY_STORE_SOURCE=root:password@tcp(1.2.3.4:3306)/gitploy?parseTime=true

⚠️ WARNING​

You have to setting the SQL mode by removing NO_ZERO_DATE from the default setting to enable the zero value for the timestamp type. 

sql-mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

To set the SQL mode, you can check the official document.

Postgres​

Gitploy supports postgres on the following 4 versions: 10, 11, 12 and 13. The below example demonstrates postgres database configuration. See the official driver documentation for more connection string details.

GITPLOY_STORE_DRIVER=postgres
GITPLOY_STORE_SOURCE=root:password@1.2.3.4:5432/gitploy?sslmode=disable