The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Email Subscription

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 717 other subscribers

Archive for November 3rd, 2026

Today 10 years ago; SQlite reversed their temp file prefix into etilsq_ from sqlite_; why? Harassement.

Posted by jpluimers on 2026/11/03

Choose your prefixes by default, especially if you name them after someone else’s product.

In this case, SQLite suffered from McAfee starting to use sqlite_ as prefix for temporary files in 2016.

SQLite had been using that prefix for a long time, and properly cleaned up these files during application shutdown.

McAfee didn’t cleanup after themselves which, after a long track record of dissatisfying users – [Wayback/Archive] The McAfee update mess explained | Reuters – wasn’t an incident, didn’t surprise techies, but prompted regular users to blame SQLite, some even tracking down their developers and call harass them.

McAfee apparently was deaf for a warning that then had been present for more than 10 years, as this got changed change in 20040522:

Read the rest of this entry »

Posted in C, Database Development, Development, Software Development, SQLite | Tagged: | Leave a Comment »

datetime – What is the difference between UTC and GMT? – Stack Overflow

Posted by jpluimers on 2026/11/03

[Wayback/Archive] datetime – What is the difference between UTC and GMT? – Stack Overflow

TL;DR: they used to be different but have been the same for a while now.

The difference is summarised in [Wayback/Archive] Hans Kruse on Twitter: “TIL; I should use OffsetDateTime in Java. An interesting discussion on UTC vs GMT and the historical differences was posted on Stackoverflow. – UTC has leap seconds – GMT had stretched seconds Nowadays they are the same.”

The historic difference however means that when handling past timestamps, you need to be aware that the differ between GMT and UTC.

Which means it is worth to read the whole Stack Overflow question with the most important answers: a trip down memory lane.

–jeroen

Posted in Development, History, Software Development | Leave a Comment »