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"
    }
  }
}