Read Replicas for Separating Analytical and Operational Database Access
Read replicas isolate analytics workloads from production database writes.
Priya Sundaram
Staff Writer
Priya Sundaram
Priya spent seven years as a database administrator at a mid-sized fintech before moving into technical writing, where she covers the operational and performance side of relational databases. Her work focuses on helping engineering teams tame complex data infrastructure without losing their minds.
13 stories
Implementing Column-Level Permissions in Postgres
Postgres column grants fail silently when combined with table-level access.
Priya Sundaram
Detecting and Fixing N+1 Query Problems in Rails and Django ORMs
How lazy loading causes performance disasters and what tools catch them before production.
Priya Sundaram
Writing Idempotent SQL Data Migration Scripts
Ensure migrations run safely on retry by designing for final state instead of linear sequence.
Priya Sundaram
Lateral Joins in Postgres for Per-Row Subqueries
Unleash multi-row subqueries that see the current row's data.
Priya Sundaram
Writing Safe UPDATE and DELETE Statements in Production
Learn the two-stage safety loop that prevents destructive SQL mistakes in production.
Priya Sundaram
Admin Panel Security Risks in Production Database Access
Overly broad database credentials put production data at risk through admin panels.
Priya Sundaram
SQL Joins Explained for Non-Engineering Team Members
LEFT JOIN finds the gaps your business actually needs to chase down.
Priya Sundaram
Zero-Downtime Schema Migrations in Postgres with pg_repack
Avoid costly downtime by understanding which Postgres migrations lock tables and how to prevent it.
Priya Sundaram
MySQL InnoDB Buffer Pool Sizing in Production
The working set matters more than total database size when sizing your buffer pool.
Priya Sundaram
Postgres Row-Level Security Policy Design Patterns
Secure multi-tenant databases by mastering RLS's two-gate model.
Priya Sundaram
Least Privilege Database Access for Support and Operations Teams
Stopping privilege creep protects databases from unnecessary exposure.
Priya Sundaram
Build vs Buy Decision for Internal Admin Panels
Engineers spend a third of their time on internal tools they could buy instead.
Priya Sundaram