
Constructive
1.2K posts

Constructive
@constructive_io
Your digital construction kit for secure, modular Postgres. Build production apps that last.






The @PlanetScale RLS benchmarks compare per-row function calls vs no RLS. But real RLS policies don’t have to be function-based or evaluated per row. With proper design (stable conditions, InitPlan caching via subqueries, good indexes), you get near-zero overhead + full index utilization.

Postgres RLS sounds great in theory: embedded access control right in the database. In practice, there's complexity in policy configuration, managing your attack surface, and performance implications. Our latest article takes a deep dive into RLS.

Postgres RLS sounds great in theory: embedded access control right in the database. In practice, there's complexity in policy configuration, managing your attack surface, and performance implications. Our latest article takes a deep dive into RLS.







We just open-sourced agentic-db — a Postgres knowledge base and personal CRM you can install in one command. pgpm install agentic-db Vector search, full-text search, fuzzy matching, spatial queries, and auto-embedding triggers. All inside Postgres. npmjs.com/package/agenti…















