python-postgresql-app

Live demo: https://replit.com/@GraemeBalint/python-postgresql-app?v=1 Database: https://bit.io/graemebalint/python-postgresql-app

Instructions:

1. Open the live demo link and click the green run button (its slow, takes about 5 seconds after clicking the button). Follow the on-screen prompts.
2. Open the database link (opens database hosted by bit.io).
3. Verify any changes made to the table via the UI are reflected in the database.

Project goals:

1. Learn how to integrate Postgresql with Python.
2. Use Python to write directly to a database.

Notes:

1. All interactions between the Python program and the database are printed on the console. This includes: establishing a connection to the database, committing updates, closing the connection at the end of the session.
2. The UI and database connection are both classes are made by creating object instances.
3. The UI was built using the Tkinter module in Python. It looks better when rendered locally using a Python compiler like PyCharm. At this point, I have decided to not rebuild the UI for a web app since the focus of this project is working with databases, Python and Postgresql.