Everything hangs off the edition
A festival's data is a sequence of past states, not a current one. The pivot, the per-year overrides, and the two switches that close a submission.
A foreign key to any unique column
Two ways to point at a row of another form — by id, or by any UNIQUE column. Why the second exists, and what building SQL against runtime tables costs.
One seat, one candidate
Sixty-three exams, zero convocations. A seat is a physical resource that can be taken twice. The constraint, the race, and the report that names refusals.
Every table in one vector index
Eight business tables, one HNSW index, and a rule: no embedding is ever computed inside a request. The projection, the loops, and the worker.
An import that tells you what it will do
A school's data arrives as spreadsheets nobody cleaned. The hard part is not parsing them: it is saying what will happen before it happens.
Materialising a form as a real PostgreSQL table
JSONB stops paying off eventually. Here is how a user-drawn form becomes a real typed table, versioned outside django_migrations, additively.
An OCR result that knows which field it filled
Every OCR tutorial ends at image_to_string. Production starts there — attaching the text to a field, storing failures, and a confidence score that is not one.
Configuring django-tenants properly
Schema per tenant is the easy part. This is the configuration that decides whether your image builds, whether a Postgres blip takes the fleet down, and whether migrations run.
One entrypoint.sh for a laptop, a VPS and a fleet
Waiting for Postgres is the easy line. Extensions before migrations, assets from the image, and one release job instead of four concurrent migrations.