Optimistic Concurrency Control for APIs and Databases
Learn how to prevent lost updates with version columns, ETags, compare-and-swap writes, and useful conflict responses.
Topic
databases
9 Devspedia articles tagged with databases.
Zero-Downtime Database Migrations with Expand and Contract
Learn how to ship database schema changes safely with expand-contract migrations, batched backfills, compatible application deploys, and clear rollback points.
Implementing the Transactional Outbox Pattern for Reliable Events
Learn how the transactional outbox pattern keeps database writes and event publication consistent without distributed transactions.
Designing Cursor Pagination APIs That Stay Correct Under Load
Learn how to design cursor pagination APIs that remain stable when records are inserted, deleted, or queried at scale.
Choosing the Right Database for Your Web Application
Learn how to choose the right database for your web application based on your project's requirements and constraints.
Pros and cons of different feature flags table designs
Learn the pros and cons of structuring your features flags horizontally or vertically in your feature flags table with examples.
Sorting algorithms, with visualizations and complexity comparisons
Understand sorting algorithms with visuals, videos, and detailed explanations, also with complexity comparison for each of them
Many to Many vs Polymorphic relationships
Today we're discussing the differences between Many-to-Many and Polymorphic relationships as pros and cons.
Time series databases, what is it, and when to use it?
Learn what is a time series databases, why and when it should be used, what is the most common use cases for it, and see it compared with regular databases.