| in blog | Django News |
|---|---|
| published date | 2026-03-06 |
| original entry | Django News - Django Security Fixes, Python Releases, and New Tools - Mar 6th 2026 |
Fix Django’s case-sensitive unique constraint pitfalls by cleaning duplicates, adding Lower() constraints, and safely migrating with PostgreSQL CONCURRENTLY to avoid downtime.
A subtle PostgreSQL concurrency edge case shows how SELECT ... FOR UPDATE with joins can unexpectedly return missing or partial results under Read Committed isolation, and explores safer query patterns to avoid it.
Use helper functions that return pytest.param to preprocess multiline strings or file contents, and assign concise IDs to make parametrized pytest test cases clearer.
A deep dive into five Claude Code security review skills reveals that most are shallow checklists prone to false positives, while Sentry’s standout skill delivers a context-aware methodology that actually finds real vulnerabilities.