Pranay Ravi
Author ProfileClaim This Author Profile
Prove ownership by publishing #HashtagPLUS and this profile link on your author page or an article under your byline. A moderator or admin will review the request before it merges into your real HashtagPLUS username.
π dev.toSource
Our DBA rules say no expression indexes and no index per query. One Keycloak query reading 395k users to return zero rows made us break both, with evidence.
π dev.toSource
A checklist in seven categories for planning a cloud migration, with examples from the platforms I have led.
π dev.toSource
Part 2: testing two pgAudit configurations side by side, four parameters that surprised us, and the layers that protect the data itself.
π dev.toSource
Vaults, lock modes, continuous vs snapshot, org-level policies, headless DR clusters, and the traps that only show up years later.
π dev.toSource
How I replaced curator based cron-and-script backups with four SLM policies, an encrypted S3 bucket and an EC2 instance profile.
π dev.toSource
A walkthrough of pg-user-api, a lightweight Flask API that provisions PostgreSQL roles across dev/qa/uat/prod with an audit trail, no static config files, and notification hooks.