Glide is the single source of truth for all structured data. The 21 tables replace what would normally require 5+ SaaS products (CRM, invoicing, project management, content calendar, habit tracking). The Leads table is the most complex with 25+ source columns and 9 computed columns -- and the most API-intensive. The cache-first protocol in _Cache/ reduces API calls by ~80%.
Data architecture principles
Core operational tables (Tasks, Leads, Contacts, Pipeline, Reports) are the most actively read/written
Reference tables (Choices, Connections, Users) are static -- rarely modified, frequently read
Personal tables (Health, Learning, Habits) support the "body as highest-leverage asset" philosophy
The Finance table replaces QuickBooks -- unified business + personal tracking
Leads > Contacts > Pipeline is the promotion chain managed by /lead-qualify