# 2026.11 Release Notes ## 2026-11-18: v2026.11 release ### Summary This is the first tagged release. It upgrades FastAPI, SQLAlchemy (to the 2.1 series), MySQL, Nginx and the Python base image, and includes the log-page timezone fix from October. ### Changes since c9833eb (2026-10-17 dependency upgrade, inclusive) No earlier release tag exists, so this release starts from the October 17 dependency upgrade. #### Changed - Dependency and image upgrade: FastAPI with Starlette 1.8.0, Uvicorn, python-multipart, pydantic-settings, pytz, email-validator and slowapi. Updated the Nginx and MySQL digest pins and renamed the deprecated HTTP 422 status constant (c9833eb) #### Fixed - The log page now defaults the entry date to today in the user's saved timezone, falling back to the browser's timezone, instead of UTC. Late-evening entries no longer default to tomorrow (68e66c5) #### Internal - README documents current dependency versions (850f0fc) ### Deployment notes - MySQL 8.4.11 → 8.4.13 runs an automatic, in-place data dictionary upgrade on first start (about 1 minute). Once that happens, the old 8.4.11 image cannot reopen the data directory. To roll back, restore from the backup below. - The backend image must be rebuilt (`docker compose build backend`) to pick up the new Python packages and the Python 3.12.16 base. - No env var, port, volume or schema changes. ### Documentation - README stack table updated to FastAPI 0.165.0 / Starlette 1.10.0 / SQLAlchemy 2.1.9 / MySQL 8.4.13 / Nginx 1.31.9 - README pages table: noted that the log page's date defaults to the user's timezone ### Dependency updates | Component | From | To | Type | Notes | |---|---|---|---|---| | pydantic-settings | 2.16.0 | 2.16.3 | patch | | | python-multipart | 0.0.32 | 0.0.34 | patch | | | pytz | 2026.5 | 2026.6 | minor | tzdata refresh | | email-validator | 2.3.0 | 2.4.0 | minor | | | fastapi | 0.143.3 | 0.165.0 | minor (0.x) | starlette 1.8.0 → 1.10.0 | | sqlalchemy[asyncio] | 2.0.50 | 2.1.9 | minor | Works with aiomysql 0.3.2 | | nginx:alpine | 1.31.7 | 1.31.9 | patch | digest pin | | mysql:8 | 8.4.11 | 8.4.13 | patch | digest pin, same 8.4 LTS | | python:3.12-slim | 3.12.15 | 3.12.16 | patch | picked up on rebuild (tag is not pinned) | ### Security - Upstream patch releases for MySQL, Nginx and Python 3.12 picked up via the image updates - PYSEC-2026-4298 (python-jose 3.5.0) and PYSEC-2026-1325 (ecdsa 0.19.2): no fix is available. Still deferred because they are not exploitable here (HS256 only, ecdsa unused). ### Code changes - None ### Deferred / skipped - bcrypt 4.0.1 → 5.0.0: version 5 breaks passlib 1.7.4. It needs passlib removed first (changes `security.py` only; keep the 72-byte truncation). - python-jose → PyJWT: deferred (see Security) - Python 3.13 / 3.14: 3.12 is supported until October 2028. Upgrade in a later release. ### Verification - The project has no test suite or linter (same as baseline) - Backend container built with `--no-cache` from a fresh install - Smoke test after each update: `/`, `/health`, `/api/public/stats` → 200. Admin login plus `/api/users/me`, `/api/entries`, `/api/entries/stats`, `/api/admin/users` → 200. `nginx -t` passes. TRACE → 405. Security headers present. ### Rollback - Starting commit: `68e66c5cd9c55e80c7fa6b1b01ddbbc400d672cb` - Image tags: - `mysql:8-pre-update-bourbonacci-2026-11-18` - `nginx:alpine-pre-update-bourbonacci-2026-11-18` - `bourbonacci-backend:latest-pre-update-bourbonacci-2026-11-18` - Database backup: `~/backups/bourbonacci/bourbonacci-pre-update-2026-11-18.sql.gz` (2.8 KB) - Restore command (also needed if you roll MySQL back to 8.4.11: first recreate the `mysql_data` volume on the old image): ``` gunzip -c ~/backups/bourbonacci/bourbonacci-pre-update-2026-11-18.sql.gz | docker compose exec -T db sh -c 'exec mysql -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" "$MYSQL_DATABASE"' ```