Psycopg2 Tutorial

Source code for the accompanying tutorial found here: https://hackersandslackers.com/psycopg2-postgres-python/

Connect to a PostgreSQL database and execute queries in Python using the Psycopg2 library using this tutorial. This script looks for .sql files stored in the /queries directory, and executes them against a Postgres database.

Getting Started

Installation via requirements.txt:

$ git clone https://github.com/hackersandslackers/psycopg2-tutorial.git
$ cd psycopg2-tutorial
$ python3 -m venv myenv
$ source myenv/bin/activate
$ pip3 install -r requirements.txt
$ python3 main.py

Installation via Pipenv:

$ git clone https://github.com/hackersandslackers/psycopg2-tutorial.git
$ cd psycopg2-tutorial
$ pipenv shell
$ pipenv update
$ python3 main.py

Installation via Poetry:

$ git clone https://github.com/hackersandslackers/psycopg2-tutorial.git
$ cd psycopg2-tutorial
$ poetry shell
$ poetry update
$ poetry run

Usage

Replace the values in .env.example with your values and rename this file to .env:

• DATABASE_USERNAME: The username used to connect to your Postgres database.
• DATABASE_PASSWORD: Password for the above user.
• DATABASE_HOST: The hostname of your database (ie: localhost).
• DATABASE_NAME: The name of your "database" (the database inside your database - why isn't there a better term for this?).
• DATABASE_PORT: Port of your Postgres database (default is 5432).

Remember never to commit secrets saved in .env files to Github.

Hackers and Slackers tutorials are free of charge. If you found this tutorial helpful, a small donation would be greatly appreciated to keep us in business. All proceeds go towards coffee, and all coffee goes towards more content.