Back to Portfolio
Automotive MarketplaceProduction • September 2026
Yardly Automotives
Yardly Automotives is a digital automotive marketplace designed to make buying and selling vehicles in Kenya simpler, faster, and more transparent. It connects vehicle buyers, private sellers, car yards, and automotive businesses in one digital marketplace.
01 • Problem Statement
Vehicle buyers and car yards in Kenya face fragmented listings, unverified seller workflows, and slow search experiences across informal social channels.
02 • Deployment & Runtime
Vercel Production with Supabase PostgreSQL, Auth, and Storage.
Integrations: Supabase PostgreSQL • Supabase Auth & RLS • Supabase Storage • Payment Gateways
System Architecture Pipeline
Layer 01 • Presentation
Next.js + Tailwind Marketplace UI
Responsive vehicle search, comparison, and seller portal
Layer 02 • Auth & Access Control
Supabase Auth + PostgreSQL RLS
Role-based seller, dealer, and buyer security policies
Layer 03 • Data & Media
Supabase PostgreSQL & Storage
Relational vehicle inventory, specifications, and image buckets
Layer 04 • Serverless Logic
Edge & Serverless Handlers
Listing verification, search indexing, and payment webhooks
Architecture & Core Features
Architectural Layers
- •Supabase Backend
- •Row Level Security
- •Payment Integration
- •Serverless Functions
Core Product Capabilities
- •Vehicle Discovery
- •Seller Workflows
- •Protected Documentation
- •Real-Time Search & Filtering
Engineering Challenges & Solutions
Key Technical Challenges
- •Enforcing tenant isolation so sellers and car yards can only mutate their own vehicle listings
- •Handling high-resolution vehicle galleries without degrading mobile page load speeds
- •Supporting multi-faceted search filters across thousands of vehicle attributes
Implemented Solutions
- Implemented PostgreSQL Row Level Security (RLS) policies in Supabase tied to authenticated user roles
- Engineered responsive image optimization and lazy loading across listing grids
- Created indexed database queries supporting combined make, price, year, and transmission filters
Requirements & Technical Governance
System Requirements
- • Multi-vendor marketplace supporting both commercial car yards and individual sellers
- • Fast multi-parameter search and filtering optimized for mobile networks in Kenya
- • Database-level access control protecting seller records
Security, Performance & Observability
- • PostgreSQL Row Level Security (RLS) ensuring strict data ownership boundaries
- • Protected document and media upload policies
- • Optimized media delivery and debounced real-time search filtering
- • Static and dynamic route caching for popular vehicle categories
- • Database query performance tracking and API request logging via Supabase & Vercel
Verified Outcomes & Technology Stack
- →Deployed and live at yardlyautomotive.vercel.app
- →End-to-end buyer discovery and multi-seller inventory management workflows
- →Encoding authorization rules directly in PostgreSQL RLS eliminates entire classes of API permission bugs
- →Mobile-first filter ergonomics are critical for automotive marketplaces in emerging markets
TypeScriptSupabaseNext.jsTailwindPostgreSQL