Row

Masking Policies and Row Access Policies

How Snowflake dynamically hides sensitive column values or entire rows from unauthorized roles, enforced consistently at query time across every downstream con…

Filter Context and CALCULATE

Filter context determines which rows a DAX measure sees, and CALCULATE is the only function that can directly reshape that context.

Row-Level Security

How Power BI restricts which data rows a user can see through DAX-defined roles, the static-vs-dynamic distinction, and what RLS does not protect.

Locking in PostgreSQL

The row-level and table-level lock modes PostgreSQL uses to coordinate concurrent writers, and how to inspect and reason about lock contention.

Transform and Filter on Groups

Learn how groupby's transform() and filter() differ from agg(): transform preserves row shape while filter selects whole groups by a condition.

Layouts: Row, Column, and Box

Row, Column, and Box are Compose's three foundational layout composables for arranging children horizontally, vertically, or stacked, forming the basis of near…

Supabase Basics Cheat Sheet

Introduces Supabase's Postgres database, auto-generated REST API, authentication, Row Level Security, and realtime subscriptions using the CLI and JS client.

Multi-Tenant Database Design Cheat Sheet

Multi-tenant database architecture patterns covering shared-schema with tenant_id, schema-per-tenant, database-per-tenant, and RLS.