Support for psycopg2 or other PostgreSQL packages?

[drivertrain]

Failed to install psycopg2 from https://files.pythonhosted.org/packages/5c/1c/6997288da181277a0c29bc39a5f9143ff20b8c99f2a7d059cfb55163e165/psycopg2-2.8.3.tar.gz.

[mhsmith]

Thanks for the request. We might add this package in the future, but it isn't a priority at the moment. If anyone else wants it too, please subscribe to this issue and click the thumbs up button above.

[mhsmith]

Confusingly, this package exists under two names: psycopg2 and psycopg2-binary. For our purposes, these would both be essentially the same build.

This would require a build of the Postgres native library libpq.

[abhijithvnair94]

Same issue is coming for me too. How to rectify it?

[mhsmith]

Instead of running a PostgreSQL client directly within a Chaquopy-based app, you could access the database server via a web server. See https://stackoverflow.com/questions/23298590 for ideas.

[2023-05] There are also some pure-Python drivers for PostgreSQL, which should work fine with Chaquopy. See here for a list: we have had positive reports about pg8000.

[abhijithvnair94]

@mhsmith Thank You.

[mhsmith]

The package build tool is now open-source, so if you'd like to try building this package yourself, follow the instructions here. And if you're successful, please make a pull request so we can add the package to the public repository.

[BartStolarek]

I will try to learn how to build a package haha, thanks for the information mhsmith!