Add trace integration with PostgreSQL

[hectorhdzg]

OpenCensus currently supports trace integration with Psycopg library, being one of most popular for PostgreSQL
http://initd.org/psycopg/

Other popular libraries could be also considered in the future
https://wiki.postgresql.org/wiki/Python

[hectorhdzg]

I would like to work on this integration, please assign to me to avoid work duplication

[lzchen]

You're going crazy with the integrations! Keep it up!

[Oberon00]

Is there any way to write a more general integration or integration base layer based on https://www.python.org/dev/peps/pep-0249/ Python Database API Specification v2.0 "DBAPI"?

[hectorhdzg]

@Oberon00 I have seen a couple of different DB libraries and usually follow the DBAPI in some way or another, we can have some shared code when possible, at the end we will need the specific library integration because the patching or hook if provided would be different, in the case of psycopg plenty of the code is written on C and they have a Python wrapper on top, so patching would be entirely different to other libraries, what would be a good way to share code for DB integrations?, creating another ext package like OpenCensus?

[Oberon00]

Yes, I think something like a opentelemetry-ext-dbapi package with the shared code that the db-specific packages depend on would be the way to go -- but only if there really is code to share of course.

[toumorokoshi]

Closing this as we now have dbapi and pyscopg2.