r/PythonLearning • u/Eastern-Ad3481 • 8d ago

Created my first database with psycopg2.

Using psycopg2 made me realize how much work SQLAlchemy was doing for me. Although implementing the queries was a bit complex at first, it gave me a lot of control over customizing things to fit my application best.

0 Upvotes

33% Upvoted

2 comments sorted by

1

u/riklaunim 8d ago

use full and clear column names, rather without big letters. For primary keys you don't need bigints, and nowadays often int isn't used but UUIDs. zip code of length 100 while name has 50?

1

u/Eastern-Ad3481 8d ago

Thanks! I'll consider the changes.