Skip to content
Carlo Miguel Dy
← Back to the specimen catalogue

Acc. XVII · Sus provincia — provincial livestock marketplace, cultivated 2026

Backten — provincial livestock trade marketplace

Technical founder · Product engineer · 2026 · Independent studio

A multi-tenant, offline-first PWA marketplace connecting provincial pig farmers and buyers across the Philippines, retained as an engineering case study pending production configuration.

Sus provincia — provincial livestock marketplace, cultivated 2026

Field notes

The context

Provincial pig farmers and buyers in the Philippines trade largely outside any structured marketplace, with pricing, health information, and delivery arrangements handled ad hoc. A trustworthy exchange needs to work offline in low-connectivity provinces, verify who's on either side of a transaction, and enforce tenant isolation without relying on the UI to do it.

Cultivation

What I built

  • Built intent-based onboarding with a buyer/seller mode toggle and KYC via face-matching.
  • Built seller storefronts with photo galleries and provincial categorisation drawn from the PSGC dataset, plus semantic search over pgvector combined with PSGC geographic filtering.
  • Built live auctions with realtime bidding, preference-based buyer-seller matching, and a social feed, alongside an offline-first PWA with an IndexedDB outbox and local-first conflict handling.
  • Built the order lifecycle — feedback, a photo receipt ledger, and delivery scheduling — plus subscriptions with manual payment verification (GCash/Maya/crypto), trials, dunning, and grace periods.
  • Built Mission Control for tenant lifecycle, payment ops, and immutable audit logging enforced in Postgres, with tenant isolation enforced server-side in RLS rather than in the UI.

Root system

How it works

A pnpm and Turborepo monorepo with three surfaces — a Vite/React 19 mobile-first PWA, a Next.js landing site with SEO and PSGC permalinks, and a Vite Mission Control admin — built over seven shared packages, including @backten/psgc (43k province/city/barangay records) and @backten/llm-gateway (provider-fallback inference). Supabase carries 34 tables, 115 RLS policies, and 56 append-only migrations, with every access decision sitting downstream of receipt verification.

Harvest

Outcomes

  • The build session completed and three Vercel projects are deployed, but production Supabase is deliberately not configured, so the deployed PWA and Mission Control are non-functional pending owner action.
  • Feature tracker stands at 29 passing and 16 blocked, blocked mostly on environment and infrastructure decisions — secrets, CI billing, a Supabase production slot.
  • Five E2E specs are authored but not yet executed; migrations 0130–0143 remain unapplied.
  • Retained as an engineering case study, not a market-validation claim — described here accurately as a marketing surface with no functioning backend behind it yet.

Herbarium

The work itself

Desktop landing-page hero for Backten, a Philippine provincial pig marketplace, captured at 1600x900 in a warm cream-and-clay light theme. The top navigation bar carries a round clay-orange pig-face logo beside the wordmark "Backten" at far left; centered links read "Paano gumagana", "Presyo", "Kaligtasan", and "FAQ"; at the right sits a three-option language capsule labelled EN, TL, and Taglish with "TL" selected inside a dark-green filled knob, followed by a clay-orange pill button reading "Simulan". Below, on the left half of the hero, a small white outlined pill reads "Bago sa Backten? Libre ang pag-browse." Under it a very large three-line black headline reads "Backten — ang online na baboyan ng probinsya". The supporting paragraph reads "Gawa ng sariling storefront, mag-post ng katalogo, mag-host ng live na oksyon — at hanapin ka ng buyers hanggang sa barangay level. Walang takedown risk, hindi tulad sa Facebook groups." Two side-by-side buttons follow: a filled clay-orange "Simulan nang libre" and a white outlined "Tingnan ang mga baboy ngayon". Beneath them a single line of grey fine print reads "Libre habambuhay para sa buyers · 30 araw na libreng trial para sa sellers · lahat ay KYC-verified". The right half of the hero holds a flat line-art illustration on the cream gradient: a round rust-brown pig with a pale pink snout standing on a soft elliptical shadow, a pale pink circle with an arc to its upper left, two mint-green swooshes flanking it, and a small white outlined cloud at upper right carrying a teal "₱/kg" label. A pale band across the bottom of the frame shows four evenly spaced statistics, each a large clay-orange number above a small grey uppercase label: "9 AKTIBONG LISTING", "2 KYC-VERIFIED NA SELLER", "82 PROBINSYANG SAKOP", and "0 NAKUMPLETONG OKSYON". All copy is in Tagalog/Taglish, drawn from seeded demo data.
Fig. 1Backten's marketing landing surface introduces a multi-tenant provincial livestock marketplace for Philippine SME sellers — storefronts, catalog listings, live auctions, KYC-verified sellers, and PSGC-backed geographic coverage down to barangay level, with hero counters drawn from seeded demo data.
Screenshot of the Backten landing site on a warm off-white background. A top bar shows a pig-face logo mark next to the wordmark "Backten" on the left; centered navigation links read "Paano gumagana", "Presyo", "Kaligtasan", and "FAQ"; on the right a three-segment language toggle reads "EN", "TL", and "Taglish" with "TL" active as a filled dark-green pill, followed by a rust-orange rounded button labelled "Simulan". Below, a breadcrumb reads "Backten / Batangas". The page heading in large bold black type reads "Baboy for sale sa Batangas", with the subline "4 listing mula sa mga verified seller sa Batangas." A share row labelled "I-share:" offers three outlined pill buttons for Facebook, Messenger, and WhatsApp. A section headed "Mga bayan" lists 33 municipality chips across three rows — Agoncillo (with a grey count "(4)"), Alitagtag, Balayan, Balete, Batangas City, Bauan, Calatagan, and on through Tuy — generated from PSGC geographic data. Under the heading "Pinakabagong listing" is a three-column card grid holding four listing tiles, each with a peach placeholder panel containing a small pig emoji in place of a photo: "Breeder gilt — Large White" at ₱18500/ulo, "Fattener 100kg+, ready this week" at ₱180/kg, "Batch: 8 fatteners ~95kg avg" at ₱184/kg, and "3 biik, Landrace cross — 45 days" at ₱3200/ulo, all located in Agoncillo. Prices are set in rust-orange bold type; the two right-hand slots of the final row are empty.
Fig. 2A server-rendered provincial permalink page for the Backten livestock marketplace, using PSGC geographic data to generate the full Batangas municipality chip list alongside Taglish listing tiles drawn from seeded demo data.
Screenshot of a server-rendered seller storefront page on the Backten landing site, in a warm off-white theme. The top bar shows a pig-face logo mark beside the wordmark "Backten" at left; centered navigation links "Paano gumagana", "Presyo", "Kaligtasan" and "FAQ"; and at right a pill-shaped language toggle reading "EN | TL | Taglish" with "TL" filled in dark green as the active choice, followed by a rounded terracotta "Simulan" button. Below a hairline divider, the storefront header shows a dark-green rounded-square avatar with the initials "KA", the heading "Ka Berto (seller demo)", and a pale mint badge reading "✓ KYC-verified". Under that, a row labelled "I-share:" offers rounded share chips for Facebook, Messenger, and WhatsApp. Next is a row of three rounded stat cards: "0 / SALES", an em dash "—" / "RATING", and "2026 / MIYEMBRO". Below that the section heading "Katalogo (9)" introduces a three-column grid of nine rounded listing tiles, each with a title line and a terracotta price line — "10 biik, malusog — bulk discount" at ₱1700/ulo, "2 breeder boars — Duroc" at ₱22000/ulo, "Pang-lechon batch, 20kg avg" at ₱4200/ulo, and six more down to "3 biik, Landrace cross — 45 days" at ₱3200/ulo. No photographs appear on the tiles; each is text only. The interface copy mixes Tagalog and English.
Fig. 3A public seller storefront on the Next.js landing surface renders a tenant's KYC-verified profile, share links and priced livestock catalog for the multi-tenant provincial marketplace, with all listings and counts shown here being seeded demo data.
Mobile screenshot of the Backten progressive web app at 430 by 932 pixels, on a warm off-white background. A top bar shows a pig-head logo beside the wordmark "Backten" on the left and a bell notification icon on the right. Below a hairline divider is a small back link reading "← Bumalik" and the page heading "Magdagdag ng hanap" in large bold serif type. The form begins with the label "Kategorya" above a full-width dropdown set to "Biik". Next is a two-column row: "Pinakamababang budget (₱, opsyonal)" with the value 1500 typed in, and "Pinakamataas na budget (₱, opsyonal)" with the value 4000. The following two-column row, "Pinakamababang bigat (kg, opsyonal)" and "Pinakamataas na bigat (kg, opsyonal)", is left empty. Under the group label "Gustong lokasyon (opsyonal)" sits a four-field geographic cascade in two rows: "Rehiyon" set to "Region VI (Western Visayas)" and "Probinsya" set to "Iloilo" with an orange focus ring around its select; below them "Bayan/Lungsod" and "Barangay (opsyonal)" both still show the placeholder "Pumili...". Next is "Kailan mo kailangan? (opsyonal)" with the greyed placeholder "hal. sa loob ng 2 linggo", then "May iba pa? (opsyonal)" with a multi-line textarea showing the greyed placeholder "hal. lahi, ugali, dami". A full-width outlined button reads "I-save ang hanap". A fixed bottom tab bar spans the base of the screen with six text labels: Maghanap, Feed, Chat, Mga Order, Magbenta, Profile. All interface copy is Taglish.
Fig. 4The buyer "want" form in Backten's offline-first PWA captures structured livestock demand — category, peso budget range, weight range, and timing — with location entered through a cascading PSGC region-to-province selector (Region VI / Iloilo shown).
Desktop screenshot, 1600 by 800, of the Backten marketing landing page in a warm cream light theme, logged out. A slim top navigation bar carries a round orange pig-face logo and the wordmark "Backten" at left; centered links read "Paano gumagana", "Presyo", "Kaligtasan" and "FAQ"; at right a three-position language capsule shows "EN", a filled dark-green pill containing "TL", and "Taglish", followed by a rust-orange pill button labelled "Simulan". Below, a safety section opens with a small rust-orange eyebrow label "KALIGTASAN AT KYC" above a very large near-black serif headline, "Hindi kami nagpapabaya sa scam". A two-line subhead reads "Ang Backten ay isang venue lamang — pero ginawa namin itong mas mahirap i-scam kaysa sa Facebook groups." To the right sits a flat line illustration of an ID card with a portrait circle and three text lines, overlapped by a dark-green circular camera badge and topped by a dark-green circular checkmark badge. Beneath the subhead is a two-by-two grid of pale mint cards: "REQUIRED na KYC verification" — government ID plus live selfie verification before anyone can transact, owner-reviewed within 24 hours; "Naka-log ang lahat" — every chat, listing, and transaction recorded and exportable as evidence for a barangay complaint; "Report at block, isang tap lang" — reporting a listing or user routes to same-day review in Mission Control; and "Reputasyon na kailangan pagtrabahuin" — rating, completed sales, tenure, and a "Bago sa Backten" indicator visible before anyone messages. Under the grid, a pale pink full-width disclaimer panel opens with a warning triangle, stating plainly that Backten is a venue only and does not hold, inspect, or guarantee any pig or seller, and that every transaction is between buyer and seller at their own risk. A rust-orange text link closes the section: "Basahin ang buong gabay sa kaligtasan" with a right arrow.
Fig. 5The Next.js landing surface presents Backten's trust and moderation layer for a provincial Philippine livestock marketplace — required government-ID plus live-selfie KYC, audit logging of chats, listings and transactions, one-tap reporting routed to the Mission Control admin surface, seller reputation signals, and an explicit venue-only disclaimer.
Pressed leaf — what it taught
Enforcing tenant isolation in RLS rather than the UI layer meant the system's security posture didn't depend on every client surface getting it right. Deploying the surfaces before production infrastructure exists made the gap between “built” and “live” concrete and specific, rather than a vague caveat.