Back to projects// In development
Guardería
Management system for kindergartens in Colombia: tuition collection with QR and a Bre-B key, a guardians' portal, a comprehensive child record and Ley 1581 compliance.
- Role
- Product owner and architect · Orchestrating AI coding agents
- Status
- In development
- 3,304pgTAP tests
- 1,565Vitest tests
- 169SQL migrations
- 95RPC functions
- Supabase
- PostgreSQL
- Deno
- Angular
- Tailwind CSS
- pdf-lib
- Vitest
- Playwright
- pgTAP
- Semgrep
- gitleaks
- Cloudflare Workers
- pnpm
Highlights
- Row Level Security forced on every public table, with SECURITY DEFINER functions isolated in a private schema.
- Mandatory TOTP MFA for staff (Supabase Auth) and Edge Functions for file validation, signed URLs, user admin and email.
- Compliance with Colombian law: Ley 1581 (versioned notices, consents by purpose, data-subject requests, retention) and Ley 2300 (contact windows).
- CI with a pgTAP RLS coverage check, Semgrep, gitleaks over the full history and Edge Functions coverage of at least 85%.
Context
Guardería is a management system for kindergartens in Colombia, with one installation per kindergarten. I am the product owner and architect, and I orchestrate the AI coding agents that write the code (as the showcase repository states).
- Tuition collection: with QR and a Bre-B key, plus payment-proof verification.
- Guardians: a dedicated portal.
- Comprehensive child record: health, PAI vaccines, documents and safe pick-up with restrictions.
- Classroom day-to-day: attendance, daily log and incidents.
- Oversight: audit and CSV reports.
- Compliance: Colombian data-protection law (Ley 1581: versioned notices, consents by purpose, data-subject requests and retention) and Ley 2300 (contact windows).
Architecture
A database-centric architecture on Supabase (PostgreSQL 17, Auth, Deno Edge Functions, pg_cron and Storage).
- Row Level Security forced on every public table.
- SECURITY DEFINER functions isolated in a private schema.
- About 95 RPC functions hold the business logic.
- Edge Functions for file validation, signed URLs, user administration and email.
- Mandatory TOTP MFA for staff.
- Angular 22 frontend (zoneless, signals) with Tailwind 4; PDFs with pdf-lib; static assets served from Cloudflare Workers.
- A pnpm monorepo with husky and commitlint. 72 decisions are on record.
Engineering and quality
Figures as of 16 November 2026:
- Database: 169 SQL migrations, 61 tables, 95 RPC functions and 3,304 pgTAP tests across 131 files.
- Frontend: 1,565 Vitest tests (95% line coverage) with Testing Library, and 24 Playwright specs with axe-core.
- Edge Functions: 8 functions, with 285 unit and 46 integration tests on Deno.
- CI: pnpm audit, Deno fmt/lint, Squawk migration lint, a pgTAP RLS coverage check, Semgrep, a full database reset with pgTAP, advisors and a drift check, Edge Functions coverage of at least 85%, gitleaks over the full history and commitlint.
Status
Work in progress. The main code is private; the showcase repository (“View code” button) documents architecture, decisions and status. There is no public demo yet: demos will be published progressively.