3.8 KiB
3.8 KiB
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.pyonly; 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-cachefrom 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 -tpasses. TRACE → 405. Security headers present.
Rollback
- Starting commit:
68e66c5cd9c55e80c7fa6b1b01ddbbc400d672cb - Image tags:
mysql:8-pre-update-bourbonacci-2026-11-18nginx:alpine-pre-update-bourbonacci-2026-11-18bourbonacci-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_datavolume 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"'