Postgresql connector, using psycpg2 and environment variables (.env) loaded via python-dotenv.

.env

# Example data, used for Docke Container environment.
DATABASE_USERNAME='postgres'
DATABASE_PASSWORD='postgres'
DATABASE_IP='172.17.0.2'
DATABASE_PORT='5432'
DATABASE_NAME='postgres'

db_connector.py

import os

from dotenv import load_dotenv, find_dotenv
import psycopg2

load_dotenv(find_dotenv())                                                      
                                                                                
connection = psycopg2.connect(                                                  
    user = os.getenv("DATABASE_USERNAME"),                                      
    password = os.getenv("DATABASE_PASSWORD"),                                  
    host = os.getenv("DATABASE_IP"),                                            
    port = os.getenv("DATABASE_PORT"),                                          
    database = os.getenv("DATABASE_NAME")                                       
)                                                                               
                                                                                
cursor = connection.cursor()                                                    
cursor.execute("SELECT version();")                                             
record = cursor.fetchone()                                                      
                                                                                
print(f"Database Version: {record}") 

requirements.txt

psycopg2==2.8.6
python-dotenv==0.14.0