Search for a command to run...
Articles tagged with #backend
To build a scale-proof like counter, you must decouple user actions from database writes. Start with optimistic UI updates for instant feedback, log the event to a user-specific store, and process cou
Quick Answer: SQL injection attacks exploit vulnerabilities in how web applications construct database queries. By sending malicious SQL code through user input fields (like search bars), attackers ca
The thundering herd problem happens when a highly cached data item expires, forcing millions of concurrent requests to bypass the cache and slam your database at once. You can solve this by implementi
Quick Answer: Assuming a day is exactly 86,400 seconds will inevitably break your software. Time is a political construct, not a mathematical one. Irregularities like daylight savings, sudden governme
Quick Answer: Databases don't just dump raw rows onto a disk sequentially. Instead, they chunk data into blocks called "pages" (typically 8KB). To prevent massive performance bottlenecks when row size
Quick Answer: When you query a database, it rarely reads a single row directly from disk. Instead, it relies on RAM. Databases load fixed-size blocks of data called "pages" (typically 8KB) into a memo
