
Postgres Row-Level Security for Multi-Tenant Applications
How to enforce tenant isolation at the database layer with Postgres RLS instead of relying on application code to remember a WHERE clause.
Tags
28 articles · Page 1 of 3

How to enforce tenant isolation at the database layer with Postgres RLS instead of relying on application code to remember a WHERE clause.

The security vulnerabilities that appear most often in web applications, explained with real code examples and concrete fixes every developer should know.

Protect API keys in frontend applications with backend proxies, token vaulting, environment hygiene and runtime injection — never in a browser bundle.

Implement OAuth 2.0 and OpenID Connect correctly: authorization code flow with PKCE, token management, refresh rotation and the pitfalls behind takeovers.

A complete guide to securing your software supply chain: dependency auditing, lockfile integrity, build hardening, SBOM generation and artifact provenance.

The security challenges unique to serverless: injection through event sources, over-permissioned functions and dependency risk, with practical mitigations.

Protect credentials in CI/CD pipelines with secret managers, environment isolation, least-privilege access and audit trails — without slowing deploys.

API security layers beyond auth: rate limiting, request validation, output encoding, security headers and audit logging, with TypeScript middleware.

Protect your supply chain with dependency pinning, lockfile integrity checks, SBOM generation, automated scanning and third-party risk monitoring.

Robust secrets management with HashiCorp Vault, AWS Secrets Manager and sealed secrets: rotation, injection, least privilege and no secret sprawl.

Secure OAuth 2.0 token lifecycle management: storage strategies, automatic rotation with refresh tokens, revocation propagation and replay protection.

Runtime security patterns that detect and block attacks from inside your Node.js application: SQL injection detection, path traversal and anomaly alerting.