← Graph

Locality of Behavior in Views

concept 1 connections

Design principle Yippee encourages: because SQLite makes query overhead negligible, views are the right place to fetch the data they render. The historical rule against queries in views exists only because Rails/MySQL/Postgres stacks can silently balloon partial N+1s into p50-killing cascades; when that risk is removed, co-locating data fetching with data usage is architecturally cleaner. Hundreds of queries inside a view become acceptable and often preferable.

category
practice
about
Locality of Behavior in Views concept
Talk argues for co-locating data fetching with data usage once SQLite removes the latency risk.

Provenance

Read by
1 extraction