Aleph Hackathon

It keeps the site's budget in a local SQLite database, imports it from Excel (both flat templates and hierarchical official public-works sheets), and logs expenses against it — captured either by importing a spreadsheet or by photographing a receipt and letting OCR read the amount and description. Contracts and calculation memos uploaded to the expediente are indexed with embeddings so they can be searched by meaning, and an on-device assistant answers questions about the site by calling tools over that SQLite data and the document index, with a fallback to direct SQL for exact amounts, so that it never invents figures.

All inference runs through QVAC inside a native Bare worker: Llama 3.2 1B Instruct (Q4_0) for chat and tool-calling, GTE-Large (FP16) for retrieval, and a DocTR pipeline for OCR — all on the phone's CPU, with no backend and without the data ever leaving the device. It requires a physical Android device; it does not work in an emulator or Expo Go.