Using a Database¶
PufferPanel supports several databases out of the box. - SQLite (default) - MySQL/MariaDB - PostgreSQL - Microsoft SQL Server
SQLite¶
{
"panel": {
"database": {
"dialect": "sqlite3",
"url": "file:/var/lib/pufferpanel/database.db?cache=shared"
}
}
}
MySQL/MariaDB¶
{
"panel": {
"database": {
"dialect": "mysql",
"url": "user:pass@tcp(127.0.0.1:3306)/pufferpanel"
}
}
}
PostgresSQL¶
{
"panel": {
"database": {
"dialect": "postgres",
"url": "user=pufferpanel password=pufferpanel dbname=pufferpanel port=9920 sslmode=disable"
}
}
}
Microsoft SQL Server¶
{
"panel": {
"database": {
"dialect": "sqlserver",
"url": "sqlserver://username:password@localhost:9930?database=pufferpanel"
}
}
}