Managing sqlite package declaratively

anon22412468 · September 7, 2020, 11:11am

I need to create sqlite database, but as I’m trying to achieve full automation, doing it manually from the CLI is not an option for me, so I’m wondering, if there’s an option to define DB creation inside .nix file, which would include DB name and path

fzakaria · September 7, 2020, 5:14pm

Sure can!
I would use the runCommand builder and just create the database which would be an entry in the nix store.

github.com

NixOS/nixpkgs/blob/0aa340b2fce773cfeca9aab9f8793d6db83122ef/pkgs/build-support/trivial-builders.nix

{ lib, stdenv, stdenvNoCC, lndir, runtimeShell }:

let

  runCommand' = runLocal: stdenv: name: env: buildCommand:
    stdenv.mkDerivation ({
      name = lib.strings.sanitizeDerivationName name;
      inherit buildCommand;
      passAsFile = [ "buildCommand" ];
    }
    // (lib.optionalAttrs runLocal {
          preferLocalBuild = true;
          allowSubstitutes = false;
       })
    // env);

in

rec {

This file has been truncated. show original

olmokramer · September 7, 2020, 7:01pm

If you go the runCommand route, the database will not be writable, though. This may not be an issue for you, but if it is you can take inspiration from the postgresql module which does something similar with its ensureDatabases option.