Xxiangc15h ago · 14 min readOffline-First Canvas Architecture: Handling IndexedDB Quotas, Binary Blobs, and Zero-Cloud Data SovereigntyWhen designing modern web applications, the prevailing industry default has become aggressively cloud-centric: every keystroke, node creation, and zoom action is continuously firehosed over WebSocketsfocusflow.hashnode.dev
VVishvajeet Shukla19h ago · 4 min readSupabase vs Firebase: Which Backend Fits Your Next Project?The backend-as-a-service (BaaS) you pick early ends up shaping your data model, auth, and hiring needs. Firebase and Supabase are two popular choices for startups and freelancer products — they solve vishvajeetshukla.hashnode.dev
BBuiltSafely1d ago · 4 min readinfinite recursion detected in policy for relation (42P17)If your Supabase queries suddenly fail with "infinite recursion detected in policy for relation", the cause is almost always a row-level security policy that ends up checking itself. The tempting shorbuiltsafely.hashnode.dev
MMuhammad Ali Mughal1d ago · 9 min readMulti-Vendor Marketplace Payments: Ledgers & PayoutsMost first-version marketplaces I review track money with a vendor_balance column and UPDATE ... SET balance = balance + ?. It works until a partial refund lands after a payout, a chargeback arrives wresume-ai.hashnode.dev
NNaveed Ahmed1d ago · 5 min readHow a Kubernetes Database Migration Caused a 502 Production OutageOriginally published on Naveed Ahmed's Engineering Blog. At 2:15 AM, a routine Kubernetes rolling update turned into a production outage. Within minutes, API response times increased, PostgreSQL connenaveedkumbhar.hashnode.dev
BBuiltSafely2d ago · 4 min read42501 permission denied for tableA 42501 "permission denied for table" error means the database role making the request was never granted access to that table, so Postgres stops before your row-level security policies even run. It ofbuiltsafely.hashnode.dev
CCloudmerce Agency2d ago · 10 min readMigrate a small MongoDB collection to Cloudflare D1 with Node.jsMoving a collection from MongoDB to Cloudflare D1 involves decisions that a format converter cannot make for you. MongoDB documents can contain BSON types, nested structures, and inconsistent fields. cloudmerce.hashnode.dev
FFeroz Shah3d ago · 4 min readGenerate SQL migrations from your JPA entitiesYour JPA entities already describe the schema you want. Writing the same change again by hand as SQL is slow and easy to get wrong. Migrax compares your entities with the last state you committed and fsmutimeer.hashnode.dev
FFeroz Shah3d ago · 7 min readApplying and undoing migrations: migrate, status, rollbackmigrax generate writes migrations, and three commands handle the rest: status shows what the database has, migrate applies what is missing, and rollback undoes it. This article goes through each one ofsmutimeer.hashnode.dev
FFeroz Shah3d ago · 7 min readRenaming columns and tables without losing dataRenames are where generated migrations usually go wrong. When a field changes from name to fullName, the database only sees one column disappear and another appear. A tool that just compares the two sfsmutimeer.hashnode.dev