Skip to content
Julián Bayer//
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.