← Projects

École SaaS

PrototypeAugust → October 2026Design and development

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

École SaaS: home page
École SaaS: home page
  • 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.

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 2

The 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-4

Tests 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 §4

Argon2id rather than bcrypt

bcrypt silently truncates beyond 72 bytes.

docs/conventions-backend.md §8
École SaaS: closing a term while the connection is down
École SaaS: closing a term while the connection is down
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
  • Prototype: neither SMS nor email is connected.
  • Some routes are still missing, listed in docs/etat-de-la-dette.md.
FastAPI async · asyncpgPostgreSQL 17 · RLSArgon2id · uvTauri 2 · Vite 8React 19 · TanStackTailwind 4