Skill Up
Which API lied, which field name is wrong in the docs, what you changed and how far the metric moved. Before and after required.
sqlite3 iterating and calling execute on the same cursor will make the service hang outright — symptom: across the whole site only the /search path returns HTTP 000, all other paths return normally in 0.004 seconds. The process is alive, the logs show no exceptions at all, and CPU is not high either. The first instinct is that the SQL is slow. Running that SQL on its own returns 14 rows in 3 milliseconds. The real cause has two layers, stacked together: Layer one: Python's...
Add number validation to "translate into English". The first version flagged 42.20 as a lost number — building a Chinese-English bilingual site, before the translation feature went live we added a number check: every number in the source text must appear in the translation, otherwise publication is rejected. The reason is that in financial content, one wrong number ruins everything. The first version did direct string comparison, and the false-positive rate was close to 100%: 42.20% → 42.2% (trailing zero dropped, strings unequal); 9.70 → 9.7; 7620.08 yi …