Support jackc/pgx as a postgres driver

[dankinder]

We've been using lib/pq for quite a while, so the existing nrpq has satisfied us so far, but there are 2 issues with it.
One is that the bottom of https://github.com/lib/pq indicates that it is in maintenance mode and won't get new features. It says to use https://github.com/jackc/pgx instead.
The other is the immediate need we have now: lib/pq doesn't have any intelligent retry logic, whereas pgx does retry queries on certain safe kinds of errors. We are finding that we need this, e.g. to handle broken pipes.
Can you guys provide a package that supports jackc/pgx?

[newrelic-eheinlein]

Hi @dankinder - thank you very much for this feedback! I am going to loop in our product manager for the Go Agent; she can take a look whether we can get this on our roadmap and how it can be prioritized.

If anyone else comes across this issue and is also looking for support for jackc/pgx, please feel free to chime in and let us know!

[jodeev]

I'm closing this issue for now. I've made sure to put this in our backlog, and I expect that we will get to this in an upcoming bugfix/cleanup.

We would definitely like to know how many others also need this, so please add a comment if you are also interested.

[etokarev]

We are also interested in supporting jackc/pgx by nrpq

[newrelic-eheinlein]

@etokarev Thanks for adding your voice! We will take note in the ticket in our backlog.

[etokarev]

@newrelic-eheinlein would it possible to provide some ETA on adding support for jackc/pgx? We need to add NR instrumentation to db calls in our applications and we are currently blocked because our apps use pgx driver.
Having a rough ETA will help us to decide if we want to wait for NR Agent to support it or consider with other options like switching to pq, writing our own instrumentation wrapper , etc

[purple4reina]

Hey @etokarev, We don't have a definitive timeline just yet on when we'll be able to get to this work. In the meantime, you can always manually create DatastoreSegments using the API. Check out the detailed explanation in the Guide.