whats the use case ?

nostr:nprofile1qqsd4fqmakmgtyfk806yqlmg0juh38x9g0ksyjah0s3d9jzd3r65z5cprdmhxue69uhkummnw3ezuem9v44hgmmndp5juar9vd5z7qgwwaehxw309ahx7uewd3hkctcpzamhxue69uhkummnw3ezuum5v94k27fwdejhgtcvqx2te and i did something similar with the nostr hypermedia server. check out geek's notes for links a few weeks back...

I don't understand what you mean by a Postgres adaptor. You mean like using Postgres as the database for a relay? That has been done on day 1.