Support psycopg 3

[antoine-de]

Problem Statement

Hi, I'm not sure if I'm missing something but I cannot find sentry's support for psycopg v3 (well, named psycopg ) and If I try a simple test I cannot find sql query information in sentry when using psycopg3.

Am I missing something ? I feel like I'm missing something since I cannot also find the psycopg2 integration, but I'm not very familiar with sentry's code, so maybe I'm looking in the wrong places.

And if it's not yet supported, do you plan to support it?

Thanks for this great project!

Solution Brainstorm

I guess, we would have to add a specific integration for psycopg3. I'm not sure I feel confident to do a correct and clean implementation of this, but I can try if you want.

[antoine-de]

Note: For the solution, I'm not aware of all the implication, but maybe we can also just implement this as an opentelemetry-python-contrib integration (they have psycopg2 but not psycopg3 yet (cf open-telemetry/opentelemetry-python-contrib#1751).

But I did not manage to make the sentry OTEL integration work and send performance report to sentry 😅

[antonpirker]

Hey @antoine-de!

Thanks for writing in! We have no integrations for the low level psycopg lib but for higher level database access libs like Django ORM or SQLAlchemy or asyncpg.

In my test application I have psycopg==3.1.12 and the spans show up as expected.

How do you connect to your database?

[antoine-de]

I only use psycopg directly, no ORM, so I do things like:

with psycopg.connect("url") as conn:
    conn.execute("some sql") # or use a cursor