From SQLite to PostgreSQL: My First Integration Attempt (Failures, Learning & Direction Change)

Hey everyone, Today was one of those days where I didn’t just code… I struggled, failed, learned, and improved . I started with a clear goal: Replace SQLite with PostgreSQL Store all my project data in a real database Sounds simple right? But the journey had some twists. My Initial Plan My project was using SQLite. It was easy, but not scalable. So I decided: Remove SQLite completely Integrate PostgreSQL Use .env for security Store everything in database Step 1: Database Setup I installed PostgreSQL and opened pgAdmin. Then I: Created a database → social_media_db Designed tables using DDL Ran SQL successfully That moment felt good — my database was ready. Step 2: Integration Attempt Next, I started integrating it into my code. I: Removed sqlite3 Added psycopg2 Created a db.py connection file Updated queries ( ? → %s ) Problems I Faced This is where things got real. Connection errors Query syntax mistakes Forgot commit() Small bugs everywhere At first, I thought: “Why is this so hard?”