Database Transaction Management - Best Practices / Postgresql Database for crime reports - Guided Project

Hey folks,

I’m sharing my Postgresql DB projects and happy to get any feedback.

What I’m interested in particular is learn about the best practices, managing
transactions in Postgres or in general working with a database.

I mean, how often and in what order should I commit changes to a Production Database?
Is it better to just set connection.autocommit to True and don’t worry about it?
And, if yes what happens if I make a mistake?

Last mission screen of the Guided Project

Postgres DB.ipynb (37.8 KB)

Best,
Saeed

Click here to view the jupyter notebook file in a new tab