Explore the topic
PostgreSQL
Articles.
Read PostgreSQL engineering notes on locking, data modelling, backend integration, and choosing storage for the needs of an application.
All categories & topics · PostgreSQL
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.
Supabase: PostgreSQL Access, RLS and Production Responsibilities
Evaluate Supabase through data access rules, authentication lifecycle, realtime behavior, operational needs and a representative application test.
PostgreSQL vs MongoDB: Choosing Data Boundaries and Consistency Rules
Compare PostgreSQL and MongoDB using monetary types, transaction boundaries, relationships and schema evolution, with a practical payment-workflow example.
Real Estate API: Domain Boundaries and Session Design in Spring Boot
Review the Real Estate API's actual Java and Spring implementation, including dependency checks, registration roles, database-backed refresh sessions and S3 downloads.