Search for a command to run...
Articles tagged with #backend
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 implements MVCC (Multi-Version Concurrency Control) so that transactions see a consistent view of data while minimizing blocking.This design is central to PostgreSQL’s ability to balance consistency with concurrency. Tuple metadata: xmin ...
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...
Background Sequential integer for primary keys/unique IDs has been the default choice in most database systems around the world. It has proven to be effective given the int type selected is large enough to not cause any overflow issues.UUIDs (Univers...
