Connecting with psycopg2

To make SQL queries from our application, we'll need to install a Python library that can talk directly to our database. The most popular choice is psycopg2. The psycopg2 library is not a part of the Python standard library. You can find the most current installation instructions at http://initd.org/psycopg/docs/install.html; however, the preferred method is to use pip.

For Windows, macOS, and Linux, the following command should work:

pip install --user psycopg2-binary

If that doesn't work, or if you'd rather install it from the source, check the requirements on the website. The psycopg2 library is written in C, not Python, so it requires a C compiler and a few other development packages. Linux users can usually install ...

Get Python GUI Programming with Tkinter now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.