Backend Developer Needed – Phase 1.2 (Flask, MySQL, Joomla Integration) -- 3

Project Overview

We are extending an existing Python/Flask-based system that parses theatrical Playbill PDFs and stores structured data (actors, shows, theaters, roles).

Phase 1 is complete.
We are now moving into Phase 1.2, which focuses on public-facing views, Joomla integration, and deployment.

This is not a greenfield project.

Current System (Already Built)

Python + Flask application

Admin UI for:

Uploading Playbill PDFs

Parsing cast & crew

Human review / edit / approve

Structured MySQL schema

Categories handled:

Cast, Ensemble, Swings, Dance Captain, Understudies

Equity (union) detection via asterisk (*)

Clean, working proof already demonstrated

Phase 1.2 Scope (What You Will Build)
1. Public Read-Only Views

Actor profile pages

Show pages

Theater pages

IMDb-style navigation between them

2. Actor Profile Enhancements

Credits grouped by discipline

Equity indicator per show (not global)

Simple USA map showing theaters an actor has worked at

Read-only

No advanced analytics or sharing logic

3. Search & Browsing

Global search across actors, shows, theaters

Filters (e.g. Equity vs Non-Equity)

4. Duplicate Protection

Prevent duplicate Playbill uploads

Detect duplicates using:

Show name

Theater

Date / year

5. Joomla Integration (Mandatory)

Client site is built on Joomla

Existing Theater database must be reused

No duplicate theater records

Integration can be via:

Joomla module

API-based embedding

Menu routing

Public pages must feel native to Joomla

6. Deployment (Mandatory)

Deploy system to client’s server

Configure Flask environment

Wire MySQL connections

Verify production access

Technical Requirements

Strong experience with:

Python

Flask

MySQL

Experience integrating with CMS platforms (Joomla preferred)

Comfortable deploying production apps

Must understand relational data modeling

Must write deterministic logic (no hallucinating AI extractors)

Important Notes

This phase is read-only for public users

No user accounts

No payments

No subscriptions

No mobile apps (future phase)

Deliverables

Live deployment on client server

Public Actor / Show / Theater pages

Working search & navigation

Joomla integration verified

Duplicate upload protection

How to Apply

Please include:

Relevant Flask + MySQL projects

Experience with Joomla or CMS integrations

Fixed-price quote for Phase 1.2

Estimated timeline

⚠️ Do not apply if you are planning to rebuild the system from scratch.