68 lines
3.8 KiB
Markdown
68 lines
3.8 KiB
Markdown
# 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"'
|
|
```
|