École SaaS
School management for several organisations at once (schools, Quranic centres), each one isolated at PostgreSQL row level. A desktop workstation rather than a website.

The starting constraints
- A school office in Conakry: the power cuts out, the network goes down.
- People print a lot, type on a keyboard, and the files are local.
- A school must never see another school's data.
The decisions, and why
Isolation that cannot be forgotten
The RLS policies are generated by a block that walks the database catalogue, and CI fails if an organisation table has none.
docs/modele-donnees.md, invariant 2The organisation context lives for one transaction
Set per connection, it would leak from one school to another through the pool. On top of that, the API connects with a role that does not own the tables.
docs/modele-donnees.md, invariants 3-4Tests run against a real PostgreSQL
RLS, exclusion constraints and citext do not exist in SQLite: a test that passes elsewhere proves nothing.
docs/conventions-backend.md §4Argon2id rather than bcrypt
bcrypt silently truncates beyond 72 bytes.
docs/conventions-backend.md §8
The numbers, counted in the repository
1,872
tests, coverage required ≥ 85%
apps/api/tests
420
HTTP operations on 295 paths
OpenAPI snapshot
213
tables
CREATE TABLE in infra/sql
133
commits, August → October 2026
git log
What does not work yet
- Prototype: neither SMS nor email is connected.
- Some routes are still missing, listed in docs/etat-de-la-dette.md.
Stack
FastAPI async · asyncpgPostgreSQL 17 · RLSArgon2id · uvTauri 2 · Vite 8React 19 · TanStackTailwind 4