Hacker News new | ask | show | jobs
by wces 558 days ago
The relevant comment here: https://github.com/sqlite/sqlite/blob/e8346d0a889c89ec8a78e6...

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.

1 comments

Looks like most links are about antivirus software or Firefox. So it does seem to be working; people are getting pointed to the buggy application code actually causing their problem and not the SQLite project itself
Thanks for this, I was wondering why people would care so much about these files that they go and complain. Reading through these forum questions, looks like most people are trying to free up disk space by clearing temp files, but the SQLite ones can't be deleted - because they are in use and locked - which causes confusion.
Ah, the era of people deleting random files on their computer that they "don't use"
From their temp folder, which is completely reasonable.
while I sneer at the unwashed masses clearing temp stuff by hand in 2024, I'm in the same boat trying to declutter stuff in my Mozilla/Thunderbird profiles :( ...
Doesn't the built in Windows disk space cleanup app actually clear temp as well?
Not C:/temp no, it clears %temp% which is usually squirreled away as C:/Users/<username>/AppData/local/temp
Several lifetimes ago I was looking at a Solaris server with very limited available space on the root partition and realized that someone had deleted the kernel file, presumably trying to solve the same problem.

I really hope it wasn’t me.