CUT TO:
INT. PROJECT ARCHIVE — STORYBOARD ROOM
The USER opens Python + PostgreSQL Movie Database Explorer.
DIVAKAR DESSAI
Let's run through the shots.
CASE FILE / COMP3311 / Databases / Python
Python + PostgreSQL Movie Database ExplorerApplication-Layer Relational Data Retrieval
Built Python command-line tools that query a PostgreSQL movie database and transform relational data into useful application-level output.
01–02 / OPENING SEQUENCE
Establishing the world
01 / Establishing Shot
The Problem
The application needed to answer structured questions about a large movie dataset while cleanly separating database retrieval from application behaviour.
02 / Wide Shot
The Context
The assignment moved database work outside the SQL shell and into Python applications communicating directly with PostgreSQL.
03 / CHARACTER NOTE
DIVAKAR'S ROLE
Subject
Divakar Dessai
Production
Python + PostgreSQL Movie Database Explorer
Take
03 / Role
Role notes
DIVAKAR DESSAI
I implemented query-driven command-line programs and shared helper functionality for retrieving and presenting database information.
04 / CLOSE-UP
THE ENGINEERING CHALLENGE
The key design decision was determining which processing belonged inside SQL and which belonged in the Python application layer.
05 / TRACKING SHOT
THE APPROACH
A plan emerges.
Each utility executed focused SQL queries through a database connection and then processed the returned records into application-specific output.
06 / INSERT SHOTS
KEY FEATURES
The system takes shape.
07 / DIRECTOR'S NOTES
DESIGN DECISIONS
Things we decided along the way
01
Performed relational filtering and joining in PostgreSQL.
02
Kept presentation and command-line behaviour in Python.
03
Shared repeated connection and database logic between utilities.
design decisions
somewhere mid-build
08 / RETAKES
WHAT WENT WRONG
Naturally, not everything cooperates.
09 / FINAL SHOT
THE OUTCOME
ProblemBuildOutcome
01
Built several database-backed Python utilities.
02
Strengthened understanding of real application/database integration.
03
Applied parameterised relational queries from application code.
10 / PRODUCTION NOTES
TECH STACK
The tools behind the scenes.
PythonPostgreSQLSQL
11 / BEHIND THE SCENES
LINKS
FADE OUT.
USER closes the file.
One project down. A few more stories left.
DIVAKAR DESSAI
Pick another?