Home→About→Services→Products→Projects→Blog→Contact→
Software DevelopmentCompleted

XPOS

An offline-first point of sale app for small shops on Android, Windows and web, covering sales, stock, receipts, staff shifts, payroll and reports, with cloud sync across devices.

ClientIn-house
Year2026
DivisionSoftware Development

About this engagement

An offline-first point of sale app for small shops on Android, Windows and web, covering sales, stock, receipts, staff shifts, payroll and reports, with cloud sync across devices. Delivered in close partnership with In-house, this engagement covered discovery, implementation, and post-launch support, with measurable outcomes tracked for 90 days after go-live.

Overview

Small shops with patchy internet need a till that never stops. I built XPOS, a Flutter POS that runs fully offline on a local SQLite database and syncs to the cloud in the background. The key decision was splitting the backend into two Supabase projects: one for billing and plans that shop staff can never reach, and one for shop data locked to each tenant with Postgres Row Level Security. Activation, billing webhooks and AI invoice scanning run in Supabase Edge Functions, with Lemon Squeezy handling subscriptions.

Highlights

  • Works with no internet. Every sale goes into a local Drift SQLite database first, and a background queue pushes it to Postgres once the device is online.
  • Multi-tenant by design. Postgres Row Level Security scopes every row to one shop, and billing lives in a separate Supabase project staff can never query.
  • Safe on many devices. A cloud session lease with heartbeats hands a staff profile between terminals, and a delete outbox stops removed rows coming back.
  • AI invoice import. A photo of a supplier invoice goes to Google Gemini through an Edge Function, which reads each line and matches it to existing products.

Technology stack

Flutter (Dart)Supabase (PostgresAuth)Supabase Edge FunctionsDrift (SQLite)RiverpodLemon SqueezyGoogle GeminiGitHub Actions + Vercel

Project Visuals & Architecture

Working on something similar?Tell us about your scope, we will reply within 48 hours.
Start a conversation
← All projects