{ config, lib, pkgs, ... }:
{
  services.nocodb.enable = true;
  services.nocodb.environment = {
    DB_URL="postgres:///nocodb?host=/run/postgresql";
  };
  
  services.postgresql = {
    enable = true;

    ensureDatabases = [ "nocodb" ];
    ensureUsers = [{
      name = "nocodb";
      ensureDBOwnership = true;
    }];

    package = with pkgs; postgresql;
    authentication = lib.mkForce ''
        #type database DBuser  origin-address auth-method
        # unix socket
        local all      all                    trust
        # ipv4
        host  all      all     127.0.0.1/32   trust
        # ipv6
        host  all      all     ::1/128        trust
    '';

    settings.log_timezone = config.time.timeZone;
  };
  # virtualisation.oci-containers.containers."nocodb" = {
  #   image = "nocodb/nocodb:latest";
  #   ports = [ "8080:8080" ];
  #   volumes = [ "/home/ntm/nocodb:/usr/app/data/" ];
  #   user = "ntm:ntm";
  #   environment = {
  #     NC_DB="pg://";
  #     NC_AUTH_JWT_SECRET="";
  #   };
  # };
}