-
Sep 2, 2026Cache and database always inconsistent: update database first or delete cache first? Is delayed double deletion really reliable?When cache and database are inconsistent, the default is to update the database first and ...View details
-
Sep 1, 2026How Many Seconds for Interface Timeout to Avoid False Positives? Too Short Misjudges, Too Long Waits—What Determines It?There is no universal interface timeout. Set it in tiers based on interface type and P95 l ...View details
-
Aug 31, 2026System Development: Should Status Fields Store Numbers or Strings? Changing an Enum Value Keeps Frontend and Backend Busy for Two DaysShould status fields store numbers or strings? In 2026, the common practice is to store bu ...View details
-
Aug 30, 2026System Program Development: Should Interfaces Be Synchronous or Asynchronous? Missing Callback Configuration Can Lose Orders OnlineSynchronous vs asynchronous depends on business consistency and caller wait tolerance. Cho ...View details
-
Aug 29, 2026In System Development, Is It Okay to Call APIs Inside a Transaction? When Database Connections Run Out, Everything FreezesCalling external APIs directly inside a transaction is a common pitfall that leads to conn ...View details
-
Aug 28, 2026System Program Development: Store Time Fields as Timestamp or String? Time Zones Cause Repeated ReworkTime fields should prefer storing UTC timestamps, then convert to ISO 8601 strings for dis ...View details
-
Aug 27, 2026Logs too sparse to trace issues, too verbose to afford — what to do when production troubleshooting always misses that one key detail?More logs are not necessarily better; the key is to be able to reconstruct the complete pa ...View details
-
Aug 27, 2026How Detailed Should API Return Codes Be to Avoid Back-and-Forth During Integration?API return codes should be neither overly detailed nor overly minimal. Based on 2026 proje ...View details
-
Aug 26, 2026System Development: Too Few Comments Make Code Hard to Understand, Too Many Are Ignored—How Many Is Enough?The core of comments is to explain decision rationale and business constraints, not to res ...View details
-
Aug 25, 2026Config files or environment variables for multi-environment? After a wrong production DB, I switched.For multi-environment configuration, the recommendation is to use environment variables as ...View details
-
Aug 24, 2026Physical Delete vs Logical Delete: Which One Should You Use in System Development?There is no absolute right or wrong between physical delete and logical delete; the key is ...View details
-
Aug 23, 2026Should Database Tables Have Foreign Keys in System Development?In system development, whether database tables should have foreign keys is a frequent poin ...View details
-
Aug 22, 2026Where Should API Idempotency Be Placed to Avoid Chaos in System Development?API idempotency is not required for every interface. Focus on state-changing interfaces su ...View details
-
Aug 21, 2026System API Development: How Many Retry Attempts Are Appropriate? Wrong Retry Settings Can Make Things WorseMore retries do not mean more safety. Retry count, interval, timeout, and idempotency must ...View details
-
Aug 20, 2026System Program Development: How Detailed Should API Documentation Be to Avoid Integration Headaches?API documentation is appropriate when it's detailed enough to write code directly from it ...View details
