zj/nidobyte - Change EIIUUAKGFBWJJ67QKWXX3X7TC2ASQIAUZV4734C5KQKWNHOVYJGAC

nix: Install and initialize a Postgres DB For a persistance layer, this change introduces postgresql as dependency. The daemon is started when `nix-shell` is invoked. `pg_ctl stop` is not invoked, and this has to be done by a developer. Data is persisted in a tmp directory, which is added to the ignore file.

Created by zj on July 15, 2021

EIIUUAKGFBWJJ67QKWXX3X7TC2ASQIAUZV4734C5KQKWNHOVYJGAC

Dependencies

[2] W3M3C7CCWHJWRWHULDWO45D3OFD4NL3V4OTJVIJCYRQG57Z2JTWQC

In channels

main

Change contents

Insertion in shell.nix at line 14 [2.853]

[2.1152]

        # Database
        pkgs.buildPackages.postgresql

Insertion in shell.nix at line 20 [2.853]

[2.1215]


  shellHook = ''
    export PGDATA=$PWD/tmp/postgres_data
    export PGHOST=$PWD/tmp/postgres
    export LOG_PATH=$PWD/tmp/postgres/LOG
    export PGDATABASE=postgres
    export DATABASE_URL="postgresql:///postgres?host=$PGHOST"
    if [ ! -d $PGHOST ]; then
      mkdir -p $PGHOST
    fi
    if [ ! -d $PGDATA ]; then
      echo 'Initializing postgresql database...'
      initdb $PGDATA --auth=trust >/dev/null
    fi
    pg_ctl start -l $LOG_PATH -o "-c listen_addresses= -c unix_socket_directories=$PGHOST"
  '';

File addition: .ignore (----------)
[1.0]
```
/target
/tmp
```

Dependencies

In channels

Change contents

Insertion in shell.nix at line 14 [2.853]

Insertion in shell.nix at line 20 [2.853]

File addition: .ignore (----------)