http
5 minReliable API Clients: Pagination, Conditional Requests, and Retry Budgets
Keep list traversal stable, validate cached representations, and bound retry work when networks fail at ambiguous points.
Search the library
60 matching resultsArticles and interview answers
databases
6 minSQL keyset pagination: continue an order without promising a snapshot
Use a unique ordering tuple and a deliberate visibility policy for reliable page traversal.
databases
10 minSQL Query Recipes: Joins, Grouping, Window Functions, and Safe Pagination
Build common analytics queries while avoiding duplicate rows, incorrect aggregates, unstable pages, and cross-dialect surprises.
databases
10 minTop-N and Third-Highest Salary Queries in PostgreSQL, MySQL, and Oracle
Choose between distinct salary ranking, row ranking, and pagination syntax while handling ties and NULLs explicitly.
Q&A
Q&AWhy does a timestamp cursor need a unique tie-breaker?
Equal timestamps otherwise make continuation skip or repeat peers.
Read the concise answer
Carry the full ordering tuple, such as created_at and ID, and match its direction in the continuation predicate. Stable continuation still does not freeze membership across requests.
Q&A
Q&AWhy is a UDP port scan inconclusive about application health?
UDP has no connection handshake and applications may not answer an invalid or empty probe.
Read the concise answer
Unlike TCP, UDP does not establish a transport connection before sending a datagram. A missing response can mean filtering, packet loss, an invalid request, or an application that does not reply. Use a valid protocol-level health check and capture at sender and receiver when diagnosing the path.
Q&A
Q&AWhat does vector-clock incomparability represent?
Concurrent histories under the vector clock identity and propagation model.
Read the concise answer
If neither vector is component-wise less than the other, neither history contains all represented knowledge of the other. This does not establish physical-time order or choose a globally agreed winner.
Q&A
Q&AWhy use exec in a container entrypoint script?
Replacing the shell with the service improves signal delivery and exit-code propagation.
Read the concise answer
Without exec, the shell can remain as the parent process and may not forward termination signals as intended. `exec service ...` replaces the shell, making the service the main process so it receives the container stop signal directly and its exit status is reported. A wrapper supervising multiple children must explicitly forward signals and reap them.