nix-shell + python w/ integrated dependencies

default.nix

{ pkgs ? import <nixpkgs> { } }:
let
  ld_library_path = pkgs.lib.makeLibraryPath (with pkgs; [
    stdenv.cc.cc  # for greenlet support
  ]);
in
pkgs.symlinkJoin {
  name = "dev-env-python311-cc-libpq";
  paths = with pkgs; [ python311 postgresql ];
  nativeBuildInputs = [ pkgs.makeWrapper ];
  postBuild = ''
    wrapProgram $out/bin/python3.11 --set LD_LIBRARY_PATH "${ld_library_path}"
  '';
}

shell.nix

{ pkgs ? import <nixpkgs> { } }:

pkgs.mkShell {
  buildInputs = [ (import ./default.nix { inherit pkgs; }) ];
}

nix-build  
ls result/bin/python3.11
nix-shell  # to have 'paths' in your PATH

Fixes errors with greenlet like:

/nix/store/nprym6lf8lzhp1irb42lb4vp8069l5rj-glibc-2.32-54/lib/libc.so.6: version `GLIBC_2.36' not found (required by ???)

Option without LD_LIBRARY_PATH

{ pkgs ? import <nixpkgs> { } }:

pkgs.symlinkJoin {
  name = "dev-env-python311-libpq";
  paths = with pkgs; [ python311 postgresql ];
}