Database Schema Design for Production Applications
The PostgreSQL schema design patterns I use in every production application I build through Supabase. From naming conventions and data type decisions to indexing strategy, UUID vs serial IDs, soft deletes, and migration workflows. Real schemas from EuroParts Lanka (products, orders, users, parts), uvin.lk (modules, lessons, progress tracking), and FreshMart (products, orders, carts). These aren't textbook patterns — they're battle-tested designs running in production right now, serving real users across Sri Lanka, the UK, and beyond.
U
Uvin Vindula·January 6, 2025