¿Dónde Están?: Full-stack memorial platform by Berckan Guerrero¿Dónde Están?: Full-stack memorial platform by Berckan Guerrero

¿Dónde Están?: Full-stack memorial platform

Berckan Guerrero

Berckan Guerrero

¿Dónde Están?: Full-stack memorial platform aggregating nearly 9,000 source records from Chile's military dictatorship across 3 sources. Python async ETL pipeline with fuzzy matching achieves 99% deduplication accuracy, resolving them into 3,216 unique victim profiles. AI-powered image restoration using Real-ESRGAN and GFPGAN recovers detail from low-resolution archival photographs.
Supabase PostgreSQL backend with 63 migrations and Row Level Security on every table. Full-text search with Spanish stemming and unaccent handling. SHA-256 change detection for incremental sync.
Nuxt 3, Vue 3, TypeScript. The first platform in Latin America to unify dictatorship victim records with AI-restored historical photographs.
Like this project

Posted Mar 18, 2026

¿Dónde Están?: Full-stack memorial platform aggregating nearly 9,000 source records from Chile's military dictatorship across 3 sources. Python async ETL pip...