Topic
Databases keep information available for reading and changing. Tables, indexes and transactions help organise that work.
When an API or database returns a large list, pagination lets a client fetch it in smaller pages. With offset pagination, the client requests a page by specifying…
Read articleOn a PostgreSQL table serving a live web application, a regular index build can cause an outage because it holds a lock while PostgreSQL scans the table and…
Read articleDuring a deployment, old and new versions of an application run at the same time. Some web servers already run the new code while others still run the…
Read article