Sollo Life in Japan, explained, from official government sources. Python Flutter RAG

Sollo

Life in Japan, explained, from official government sources. I built the scrapers and search pipeline behind it on my own, wrote its first AI server, and led the Flutter app with a small team.

  • Python
  • Flutter
  • RAG
  • pgvector
  • PostgreSQL
  • Tesseract OCR
  • Qwen
App Store

What I built

  • Built the whole data pipeline on my own. It scrapes about 48 official sources, reads scanned PDFs with OCR, and has nearly 2,900 tests.
  • Made search hybrid: Japanese full-text search plus vector search, both in Postgres.
  • Wrote the original AI server that answers from those sources (retrieval-augmented generation, or RAG). It first ran a self-hosted Gemma model on a GPU; I moved it to a hosted Qwen model.
  • Tracked down two production outages caused by the pipeline's own database load, and fixed them by pacing its jobs.

More projects