Kanboard

Kanboard is a free and open-source project management software that uses the Kanban methodology. It provides a simple, self-hosted web interface to visualize tasks, workflows, and project progress. Kanboard supports multiple authentication backends and database systems, including SQLite, MySQL, and PostgreSQL.

Using PostgreSQL with Unix Socket

Kanboard supports PostgreSQL as an alternative to SQLite. To use PostgreSQL as the database backend, enable and configure both services as shown below:

{ config, ... }:

let
  cfg = config.services.kanboard;
  db = {
    user = cfg.user;
    name = "kanboard";
  };
in
{
  services.kanboard = {
    enable = true;

    # Configure Kanboard to use PostgreSQL
    settings = {
      DB_DRIVER = "postgres";
      DB_HOSTNAME = "/var/run/postgresql";
      DB_USERNAME = db.user;
      DB_NAME = db.name;
    };
  };

  services.postgresql = {
    enable = true;
    ensureDatabases = [ db.name ];
    ensureUsers = [
      {
        name = db.user;
        ensureDBOwnership = true;
      }
    ];
  };
}