Search for a command to run...
Articles tagged with #software-development
Guardrails in software engineering are often misunderstood. Most engineers associate guardrails with: null checks validations defensive coding That is only a small part of the story. A more accur
PostgreSQL guarantees durability using Write-Ahead Logging (WAL). WAL ensures that once a transaction is committed, its changes survive crashes, even if the actual table or index pages were never written to disk at the time of failure. This article g...
PostgreSQL uses MVCC (Multi-Version Concurrency Control).Each UPDATE inserts a new row version (xmin = current XID) and marks the old one dead (xmax = current XID).Each DELETE marks the row dead by setting xmax. Dead tuples remain on disk, still refe...
PostgreSQL Locks — A Detailed Guide When working with PostgreSQL, understanding locks is essential for reasoning about concurrency and troubleshooting blocking queries. Postgres uses two main categories of locks: row-level locks and table-level locks...
When testing Spring applications, it's important to choose the right approach to load the application context and manage dependencies. Choosing the correct approach ensures that your tests are both efficient and effective. Loading the entire applicat...
When building enterprise applications, it's often necessary to connect to multiple databases. This can present some unique challenges, especially around transaction management. In this article, we’ll explore how to handle multiple data sources in Spr...
