by janvdberg on 5/23/24, 11:32 AM with 10 comments
by mmastrac on 5/23/24, 3:06 PM
** 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.by seabass-labrax on 5/23/24, 3:03 PM
In my opinion, the problems that remain to this day include:
- lack of adherence to conventions for naming and storage of temporary files, especially on Windows. Somehow I'm not surprised that McAfee was a prime offender: antivirus vendors have no incentive to make things less confusing!
- sub-standard technical support that perpetuates misunderstandings. I sometimes wonder how I ever managed to become expert in the fields that I have, because most of the information on any technical subject is misleading if not outright wrong.
- (predictably) a lack of technical literacy in the general population. I know people are touchy about this, and rightly so - it's not the fault of the individual. Yet you can't avoid the mismatch between the knowledge required to correctly understand and debug software like SQLite and the much lower threshold of being able to find a telephone number online and start pestering people.
by lagniappe on 5/23/24, 3:23 PM
by qbane on 5/23/24, 2:51 PM
by causal on 5/23/24, 3:54 PM
by sixhobbits on 5/23/24, 3:46 PM