Using home manager to create a sqlite database

It worked!
Thank you!

ferdiConfigDB = pkgs.stdenv.mkDerivation {
    name = "ferdiConfigDB";

    buildInputs = with pkgs; [ sqlite ];

    dontUnpack = true;
    dontInstall = true;

    buildPhase = ''
      sqlite3 $out ".read ${initDBTablesSqlFile}"
      sqlite3 $out ".read ${toFile "allInsertionQueries.sql" allInsertionQueries}"
    '';
  };
...
home.file.${servicesDB}.source = ferdiConfigDB;
1 Like