SQLite prefixes its temp files with `etilqs_`

Lobsters Hottest News

Summary

SQLite prefixes temporary files with 'etilqs_' (sqlite backwards) instead of 'sqlite_' to avoid user complaints after McAfee's antivirus product created confusion with temp files in Windows.

<p><a href="https://lobste.rs/s/tttexr/sqlite_prefixes_its_temp_files_with">Comments</a></p>
Original Article Export to Word Export to PDF
View Cached Full Text

Cached at: 04/20/26, 02:44 PM

# SQLite prefixes its temp files with `etilqs_` - blag Source: [https://avi.im/blag/2026/etilqs/](https://avi.im/blag/2026/etilqs/) [Turso](https://github.com/tursodatabase/turso)is a rewrite of SQLite in Rust, fully compatible with SQLite\. I’ve been working on implementing`VACUUM`and studying their \(beautiful\) code\.`VACUUM`rebuilds the database into a fresh temporary file to reclaim space and defragment pages\. SQLite prefixes this temp file with`etilqs\_`\. Here’s why: ``` /* ** 2006-10-31: The default prefix used to be "sqlite_". But then ** Mcafee started using SQLite in their anti-virus product and it ** started putting files with the "sqlite" name in the c:/temp folder. ** This annoyed many windows users. Those users would then do a ** Google search for "sqlite", find the telephone numbers of the ** developers and call to wake them up at night and complain. ** For this reason, the default name prefix is changed to be "sqlite" ** spelled backwards. So the temp files are still identified, but ** anybody smart enough to figure out the code is also likely smart ** enough to know that calling the developer will not help get rid ** of the file. */ #ifndef SQLITE_TEMP_FILE_PREFIX # define SQLITE_TEMP_FILE_PREFIX "etilqs_" #endif ``` It’s here:[os\.h](https://github.com/sqlite/sqlite/blob/version-3.53.0/src/os.h#L65,%23L79)\.

Similar Articles

SQLite 3.53.0

Simon Willison's Blog

SQLite 3.53.0 releases with significant accumulated improvements including ALTER TABLE constraint modifications, new JSON functions (json_array_insert), and major CLI mode enhancements via a new Query Results Formatter library.

Theseus, a static Windows emulator

Lobsters Hottest

Theseus is a new static Windows/x86 emulator that translates programs at compile-time rather than interpreting or JIT-compiling them at runtime, representing an alternative approach to traditional emulation architectures.

InstantDB

Product Hunt

InstantDB offers a complete backend with authentication and storage set up via a single prompt.

GNU IFUNC is the real culprit behind CVE-2024-3094

Hacker News Top

The article argues that GNU IFUNC and design decisions linking OpenSSH to SystemD were the primary enablers of the CVE-2024-3094 xz-utils backdoor, rather than the malicious code itself.