Today I found the python connect postgresql have psycopg2 and psycopg2-binary package, which one should I choose? what is the difference with the two package? seems no one talk about the diff about it.Seems psycopg2 are hard to install because of the dependencies. psycopg2-binary easy to install but weak with the ability.
The difference between the two is that
the binary package is a practical choice for development and testing but in production it is advised to use the package built from sources, whereas
building psycopg requires a few prerequisites (a C compiler, some external development library packages)
Read more at psycopg2 documentation on Python's Package Index (PyPI) projects website