We use it on Python projects instead of virtualenv. A problem that you sometimes have with virtualenv is that you must install libpq-dev and python headers and what not to install from pip if the package has native extensions.

With Nix you just declare postgresql as your package inputs and you are done. All needed parts to build and install psycopg2 are there.

Your package/project is completely isolated from your OS libs.