Provide nixpkgs package

[tomhoule]

Nix is gaining more and more in popularity, with tools like devenv and process-compose making it a viable alternative to docker-compose to run postgres locally in your dev setup. We use pgx_ulid and this is the only thing preventing us from switching right now. I gave a short try at a nixpkgs PR already and things seem to be mostly working, but I ran in a bindgen error that I don't have time to debug today. There are other extensions using pgx already in there, so the groundwork is already done.

Please consider this issue a place to discuss and coordinate, and not a demand for you to spend time on it. I'll try to find time and come back to it myself.

Big thanks for working on pgx_ulid!

[pksunkara]

I don't mind a contribution to automatically set this up in our release process, but I am probably not going to work on this.

[tomhoule]

I gave it some time this morning and it is looking good, there are minor inconveniences but nothing preventing packaging — I'm trying to get this into nixpkgs as cleanly as possible. Not a blocker, but one thing that would help would be updating to the latest version of pgrx (0.11.2) and making a new crates.io release. Would you be open to a PR to upgrade pgrx?

[pksunkara]

Sounds okay with me.

[k0001]

I submitted a PR with this changes to nixpkgs NixOS/nixpkgs#312398

Thank you @tomhoule for pushing this!