MMuhammad Ali Mughal7m ago · 9 min readSaaS Backup & Disaster Recovery: RPO, RTO and PITRA nightly pg_dump to the same VPS is not a backup strategy. It is a file that disappears with the disk, the compromised root account or the provider incident that took the server down in the first plaresume-ai.hashnode.dev
ZZyVOP2h ago · 11 min readChoosing a Vector Database: pgvector vs Dedicated StoresThe real question isn't which vector database is best. It's where your vectors should live: next to the rest of your data in Postgres, or in a system built only for similarity search. Many teams alreablog.zyvop.com
AAnthony Emmanuella Mmasinachi3h ago · 12 min readAgata Proxima: PostgreSQL Security, Tenant Isolation & Database Access VerificationIntroducing Agata Proxima: PostgreSQL Security, Tenant Isolation & Data Protection A new security platform for SaaS companies, developers, and organizations that need stronger control over how their Phttpsagataproximacom.hashnode.dev
AAbolfazl Mohajeri12h ago · 14 min readHow Does PostgreSQL Decide How to Execute a Query?When you send a SQL query to a database, have you ever wondered what actually happens behind the scenes? Consider the following query: SELECT * FROM orders WHERE user_id = 123 ORDER BY created_at DESCblog.abolfazlmohajeri.ir
SSubramanya M Rao10h ago · 20 min readBuilding Reliable LinkedIn and Instagram Feeds with NestJS, PostgreSQL, and Azure BlobThe first requirement was to show our company's LinkedIn posts inside an employee portal. We already collected public posts and displayed them in a feed. Then we noticed that some cards had no image. subramanyarao.hashnode.dev
MMadhav Bhasin1d ago · 6 min readCloud SQL vs AlloyDB vs Firestore: Picking the Right Database on GCPThe question engineers actually ask isn't "what are the trade-offs between Cloud SQL, AlloyDB, and Firestore?" It's: "I'm building a new service — should I use Firestore or Cloud SQL?" The honest answblog.madhav.dev
ZZyVOP21h ago · 10 min readPostgres Performance Basics: Reading EXPLAIN Output and Fixing Slow QueriesA slow query is a guess until you see its plan. Postgres will tell you exactly how it intends to run a query and, with one extra keyword, how the run actually went. Learning to read that output is oneblog.zyvop.com
UUsman Khan1d ago · 8 min readForeign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQLRunning a DELETE on a parent entity with ON DELETE CASCADE feels like clean relational cleanup. But if any child or grandchild table in the dependency chain lacks an index on its foreign key column, P12MActousman.hashnode.dev
SSina Rezaei1d ago · 4 min readThe SQL NOT IN Trap: When NULL Quietly Breaks Your QueryI've seen SQL bugs that are easy to miss because nothing actually crashes. The query runs, the database returns a result, and the code moves on. You only notice something is wrong when a cleanup job ssinarezaei.hashnode.dev
WWaseem Anjum1d ago · 18 min readMongoDB vs Postgres JSONB in 2026: Inserts, Lookups, Updates and Storage, BenchmarkedMost "MongoDB vs Postgres JSONB" debates are fought with benchmarks from 2014 and opinions from Twitter. I run both in my day job and side projects, so I put the current versions, MongoDB 9.0.4 (releafabwaseem.hashnode.dev
