Explore the topic
Database
Articles.
Investigate database design and production failures, from deadlocks and query amplification to ORM choices and managed data platforms.
All categories & topics · Database
4 articles found
Diagnosing PostgreSQL Deadlocks and Retrying Transactions
Reconstruct a PostgreSQL lock cycle, use consistent lock ordering, and retry a complete transaction without duplicating external side effects.
Drizzle and Prisma: Compare Queries, Migrations and Runtime Fit
Evaluate TypeScript database tooling with representative SQL, migration review and deployment constraints instead of unverified performance rankings.
Fixing GraphQL N+1 Queries with Request-Scoped DataLoaders
Count resolver database calls, preserve batch result ordering, isolate loader caches by request, and verify authorization and pagination alongside query reduction.
Supabase: PostgreSQL Access, RLS and Production Responsibilities
Evaluate Supabase through data access rules, authentication lifecycle, realtime behavior, operational needs and a representative application test.