- Added PostgreSQL 16 Alpine service to Docker Swarm stack - db.py: schema for 17 tables, auto-seed from jv_data.json on first boot - /api/dashboard/data?start=&end= — server-side SQL filtering All Time: 0.43s (was 4MB JSON download stuck loading) Filtered (12mo): 0.20s with ~90% less data transferred - Dashboard HTML patched: calls API instead of static JSON - Integer casting for IsNewCustomer/HasDiscount/IsFreeShipping - Advisory lock prevents race condition during parallel worker startup - Returning Revenue now shows correctly: £14.5M (75% of total)
7 lines
114 B
Plaintext
7 lines
114 B
Plaintext
flask==3.1.0
|
|
gunicorn==23.0.0
|
|
requests==2.32.3
|
|
beautifulsoup4==4.13.3
|
|
google-genai==1.5.0
|
|
psycopg2-binary==2.9.10
|