SQLite's temporary files are prefixed with `etilqs_` (SQLite spelled backwards) instead of `sqlite_`. A comment in SQLite's source code (os.h) explains the reason: McAfee began using SQLite in their antivirus product, causing files named with 'sqlite' to appear in Windows temp folders. This confused users who Googled 'sqlite', found developer phone numbers, and called them at night to complain. The prefix was reversed so temp files remain identifiable to those who know the code, while deterring random complaints. This trivia surfaced while studying Turso, a Rust rewrite of SQLite, specifically while implementing the VACUUM command.
2 Comments
Sort: