TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Why sqlite3 temp files were renamed 'etilqs_*' (2006)

396 点作者 bsmith89将近 2 年前

13 条评论

throwaway09223将近 2 年前
I have a related story:<p>Around the year 2000 I was working operations in the NOC for WebTV (then owned by Microsoft). For those who don&#x27;t know, WebTV was a little set-top box with a modem which would dial up on demand and provide a very basic web&#x2F;chat&#x2F;email experience on the TV. The box would call a 1800 number to figure out its own phone number, then re-dial on a local toll-free number with a local sub-contracted ISP.<p>One of the services we had would periodically send a UDP datagram out to online clients to let them know they had new email. The settop box would then light up a little indicator light.<p>Of course, sometimes the client would hang up. The IP might get allocated to a PC dialup user. And sometimes, that PC dialup user might be running a firewall that was popular back then, called BLACK ICE DEFENDER.<p>BLACK ICE DEFENDER had all these (not so) cool features, the kind that semi-technical people love. For example, it would log ATTACKS. What are ATTACKS? Unrecognized traffic, of course.<p>Sometimes the little UDP datagram for our &quot;you have mail&quot; service would be delivered to a PC user running BLACK ICE DEFENDER, which would register it as an ATTACK. It would then ever so helpfully look up the ARIN contact information to see who sent the errant datagram -- which had the NOC phone number. It would then tell the user &quot;THIS ENTITY IS HACKING YOU&quot; and imply that contacting them would be productive. Yes, you could pick up a phone and call the Microsoft NOC. Back then, the internet was a smaller place.<p>My job was to check the NOC voicemail, which was reliably filled with very angry people. Often they would threaten that they&#x27;ve reported us to the FBI or somesuch, or that it confirmed some conspiracy theory or another. We played the good ones on speakerphone for entertainment.<p>Good times. Doesn&#x27;t happen anymore.
评论 #36305583 未加载
评论 #36309218 未加载
评论 #36306076 未加载
评论 #36308685 未加载
withinrafael将近 2 年前
Similar story: Friend and I put out a kernel driver (uxstyle.sys) that would patch Microsoft&#x27;s theming digital signature checks. It was free, buggy, and bugchecked the OS on upgrade. It was unsurprisingly added to compatibility blocks in Windows. I fixed the bug and asked Microsoft to loosen the block (version X and below). Microsoft refused citing a EULA violation. Valid or not, I renamed the driver to elytsxu.sys to circumvent their check and the app worked well enough until third-party theming fell out of favor.
评论 #36308801 未加载
thrdbndndn将近 2 年前
I often search for weird files in my %userprofile% (there are a lot random ones) just out of curiosity, despite I know they&#x27;re not malicious.<p>It doesn&#x27;t help that if you Google any filenames, or even any semi-obscure file extensions, there would always be plenty of blogspam articles saying they&#x27;re &quot;possible virus&quot;. And oftentimes, there is <i>no</i> legit article to say what they really are even if you try, if they&#x27;re from some relatively less popular software.
评论 #36306369 未加载
kapp_in_life将近 2 年前
Link directly to the reason comment:<p><a href="https:&#x2F;&#x2F;github.com&#x2F;mackyle&#x2F;sqlite&#x2F;blob&#x2F;18cf47156abe94255ae1495ba2da84517dce6081&#x2F;src&#x2F;os.h#L65">https:&#x2F;&#x2F;github.com&#x2F;mackyle&#x2F;sqlite&#x2F;blob&#x2F;18cf47156abe94255ae14...</a>
qalmakka将近 2 年前
I don&#x27;t know, the more time passes the more I convince myself that the net benefits of antivirus software do not (an maybe never) exceed their downsides. In decades I&#x27;ve heard so many stories about AV software behaving suspiciously, using borderline shady tricks to monitor user activity, causing severe performance degradation, etc
评论 #36307912 未加载
评论 #36306540 未加载
评论 #36312574 未加载
评论 #36306513 未加载
评论 #36306746 未加载
评论 #36309248 未加载
评论 #36309361 未加载
ShadowBanThis01将近 2 年前
Love it.<p>Too bad there aren&#x27;t enough Mac users to prompt a similar backlash against Macs littering every computer they visit on the network with .DS_Store and other turds.
评论 #36303238 未加载
评论 #36303276 未加载
评论 #36303775 未加载
评论 #36308479 未加载
评论 #36312084 未加载
评论 #36307566 未加载
评论 #36307599 未加载
shadowgovt将近 2 年前
Software is at least a much social as technology.
garganzol将近 2 年前
Why not to use sub-directories inside a temporary directory instead of file name prefixes?
2h将近 2 年前
correct URL is:<p><a href="https:&#x2F;&#x2F;github.com&#x2F;sqlite&#x2F;sqlite&#x2F;blob&#x2F;master&#x2F;src&#x2F;os.h">https:&#x2F;&#x2F;github.com&#x2F;sqlite&#x2F;sqlite&#x2F;blob&#x2F;master&#x2F;src&#x2F;os.h</a>
cwillu将近 2 年前
The relevant snippet:<p><pre><code> &#x2F;* ** Temporary files are named starting with this prefix followed by 16 random ** alphanumeric characters, and no file extension. They are stored in the ** OS&#x27;s standard temporary file directory, and are deleted prior to exit. ** If sqlite is being embedded in another program, you may wish to change the ** prefix to reflect your program&#x27;s name, so that if your program exits ** prematurely, old temporary files can be easily identified. This can be done ** using -DSQLITE_TEMP_FILE_PREFIX=myprefix_ on the compiler command line. ** ** 2006-10-31: The default prefix used to be &quot;sqlite_&quot;. But then ** Mcafee started using SQLite in their anti-virus product and it ** started putting files with the &quot;sqlite&quot; name in the c:&#x2F;temp folder. ** This annoyed many windows users. Those users would then do a ** Google search for &quot;sqlite&quot;, 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 &quot;sqlite&quot; ** 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. *&#x2F;</code></pre>
评论 #36305978 未加载
评论 #36307155 未加载
pronoiac将近 2 年前
Looks like the line numbers were lost: <a href="https:&#x2F;&#x2F;github.com&#x2F;mackyle&#x2F;sqlite&#x2F;blob&#x2F;18cf47156abe94255ae1495ba2da84517dce6081&#x2F;src&#x2F;os.h#L65-L75">https:&#x2F;&#x2F;github.com&#x2F;mackyle&#x2F;sqlite&#x2F;blob&#x2F;18cf47156abe94255ae14...</a><p>It&#x27;s because McAfee started using SQLite, angry users would stumble upon the files, do a minimum of searching or thinking, and be furious at SQLite developers.
评论 #36303580 未加载
评论 #36303263 未加载
endisneigh将近 2 年前
Somewhat related - I’m very very curious to hear a detailed account of someone who uses SQLite for a production app with high traffic.<p>For the embedded use case I think it’s a slam dunk, but there are many interesting use cases for server side but they all seem to be toyish.<p>The locking behavior of SQLite is somewhat problematic unless you use WAL and even then not perfect
评论 #36303411 未加载
评论 #36303777 未加载
评论 #36303309 未加载
评论 #36303159 未加载
评论 #36303532 未加载
评论 #36305465 未加载
评论 #36303584 未加载
评论 #36303294 未加载
评论 #36304877 未加载
评论 #36303079 未加载
评论 #36303083 未加载
codedokode将近 2 年前
This is a bad choice, I wouldn&#x27;t understand that it needs to be read backwards. Why not use process&#x27;s executable name instead?
评论 #36303691 未加载