# Setting Up PostgreSQL Locally and Connecting It to My Project (Beginner Journey)

A beginner developer documents their process of setting up PostgreSQL locally, connecting it to a Python project using psycopg2 and environment variables, and migrating from SQLite to PostgreSQL. The post covers creating a database, managing credentials via .env files, executing a DDL schema with tables for a social media project, and key syntax differences between SQLite and PostgreSQL such as AUTOINCREMENT vs SERIAL.