Acta de Vecindad
Offline-first PWA that lets field surveyors capture legal property records with no internet connection.
Overview
An offline-first Progressive Web App with a Python/FastAPI backend that lets field surveyors capture legal property records with no internet connection and syncs automatically once back online.
What was built
- An idempotent sync API using client-generated UUIDs and row-level upserts so interrupted uploads resume safely and resends never corrupt data.
- Event-driven, asynchronous automation with FastAPI BackgroundTasks: email confirmations with retry and exponential backoff, each in an isolated DB session so a slow task never blocks the API response.
- PostgreSQL with Alembic migrations, a pytest and vitest test suite (30+ tests), git hooks, and Docker Compose deployment on a Traefik/Dokploy VPS with fail-fast production guards.
Result
A production-grade offline-capable field tool with a tested, resilient sync layer — this is not a Vectia client service today, but shows the same automation/reliability engineering Vectia applies to client systems.
TODO before publishing: add real screenshots of the field app, clarify who the actual users/client are (or confirm this stays as a technical portfolio piece rather than a Vectia service case study), and add a measurable result if available.
Personal technical project — not a Vectia client engagement.