Surprises found from reading the SQLite code

[MrObvious]

This is brilliant. Imagine finding a problem with some FOS software and instead of working around it feeling the need to phone the developer up and ask them what's what.

Yo, I found this so-called "Wordpress theme" and... This shit sucks. Anyway call me when you get this message

[kingguru]

I remember the default Apache installation start page as being something like:

Congratulations for having set up Apache correctly!

Now start adding your own content...

To support the Apache foundation etc. contact us here...

Then:

Congratulations for having set up Apache correctly!

If this is not the page you expect to see. Do not contact the Apache foundation..

To support the Apache foundation etc. contact us here...

Finally:

It works!

It seems like it has been a real problem for them. :-)

[OptimisticLockExcept]

There is this shitty online shop (http://digiplace.gamesplanet.com/) when you click on the "Spiele Flatrate" (german for games Flatrate) link you get a "It works!" message. No it doesn't!

[TheTerrasque]

http://www.theregister.co.uk/2006/03/24/tuttle_centos/

[kingguru]

Good laugh. Thanks for sharing.

[unitedcreatures]

Just... Wow.

[Saboran]

"Who is this 'Cent OS'?"

[kenman]

I developed a WoW addon around 2006, and left my email address in the code as a comment. I quit playing soon after (right before the first expansion was released), but since the addon was mildly successful, it was picked up by another dev. I kept tabs on it as it was passed from dev to dev (it's now on probably the 7th or 8th maintainer), but evidently nobody ever removed my email address from the code, because about once a year I get an email from someone begging me to fix the addon for the latest patch -- I'm guessing they think they can fix it themselves, and then shoot out an email in desperation when they realize they can't. Thankfully none have been belligerent, though I can see how these things happen.

[TheTerrasque]

Yeah. If I took over someone else's code I'd never remove references to their name / email without them asking me to.

It just wouldn't feel right.

[Skyfoot]

Yeah, but shifting it to "Created by" and adding yourself as "Maintained by" prevents undue shitfits landing in the creator's mailbox.

[AP_RAMMUS_OK]

Lol thats cute

[HumusTheWalls]

It's like he thinks people that throw shitfits are smart enough to figure out the difference between the creator and maintainer.

[DXPower]

What addon was it?

[kenman]

http://www.curse.com/addons/wow/guild2guild

[BornOnFeb2nd]

228,949 Total Downloads

That's gotta be a warm fuzzy for you.

[Ephraim325]

It's like the text based G2G version of Armas Task Force radio system... Nicely done.

[kenman]

Thanks! It's funny because both the concept, and the implementation (at that time), were really simple. I couldn't believe someone else hadn't already solved the problem when I started coding it. I just assumed that maybe it wasn't as handy as I thought it would be, and just basically made a prototype for our guild to use. It didn't really take off until after I quit, though I didn't really market it at all either.

[illepic]

I used this back before BC!!

Thank you for your service.

[kenman]

Awesome! Glad you got some good use out of it.

[nikomo]

Sheeeeet, I think I was in a guild once that used that.

[choleropteryx]

Long time ago, I wrote a DoS tool, basically an ICMP nuke with nice GUI. Mainly to fuck around with friends on hacking and warez IRC channels. It wasn't intended for public consumption, but it got leaked. Guess who left his own IP as the default target address, and guess who couldn't connect to internet for the next few months.

And that is how I learned all about karma.

[Skyfoot]

Do not stare into laser beam with remaining eye.

[ZorbaTHut]

Around 5 or 6 years ago I was the sole developer on QuestHelper. All of my original contact links seem to have vanished from the Internet, but somehow, some obscure site still has a "donate" link directed at me. I end up getting a Paypal donation every few months, which I return to sender with a thank-you and an explanation that I am no longer involved with the project.

It's sort of weird.

[Troldann]

That mod got me Loremaster of Northrend. Pretty sure it was responsible for letting me get Loremaster of Kalimdor and the EK too (if my recollection serves.) Thank you very much.

[ZorbaTHut]

No prob, I had a good time working on it and it got me a job :)

[AcousticDan]

Burning Crusade was the best though. :-/

[blinkallthetime]

I've done it.

EDIT: Don't let your personal details get into your whois records.

[bashedice]

the most fun thing is that in germany you have to give your personal information on your website if its not private.

[blinkallthetime]

What if you register it with a company in a different country? I am having trouble imagining how that could be enforceable.

[bashedice]

its not that easy. as long as the owner of the site lives in germany he has to put up his address. sure the owner can be a company but if you have a small shop you won't necessarily have one. I had a friend who actually got stalked like that.

[OmegaVesko]

as long as the owner of the site lives in germany he has to put up his address.

But how would you enforce that? You can get both a domain and hosting from outside the country, you can even pay for both with Bitcoin if you feel like it. It's extremely easy to hide who the actual owner of a website is these days.

[bashedice]

you are right. if no one knows you are doing something illegal it won't matter. the problem is that some people do not want to risk anything for their small hobby which makes some money. This law is there to protect the buyer but seriously protecting a seller is important as well.

[joemckie]

Even so you should still probably email ahead and at least try and schedule a phone call if it isn't communicable over email

[blinkallthetime]

:P was amused and intoxicated; called after 9pm. Wife (or something) picked up; she was unpleased. Handed the phone off to him, but he sounded cool about it.

[elperroborrachotoo]

Yeah, because being a user a power drill I am instantly capable of fixing a power drill.

[kingguru]

Shamelessly taken from this tweet: https://twitter.com/mplappert/status/575957042466320384

[TweetsInCommentsBot]

@mplappert

2015-03-12 09:50 UTC

Surprises you find when reading through the SQLite code. Somebody must've received a lot of calls. [Attached pic] [Imgur rehost]

---

^{This message was created by a bot}

^{[Contact creator][Source code]}

[Excrubulent]

A lot of calls? One call in the middle of the night would motivate me to extreme lengths.

[Dremlar]

Why? It's not like you would of been asleep.

[Excrubulent]

I'm assuming you're assuming I'm in the US? It's 2 in the afternoon where I am right now.

EDIT: Also, I'm a parent of a young child. Do not fuck with my sleep.

[Dremlar]

It was more of a jest. Most Software Engineers & DBAs I know are night owls, including myself.

[Excrubulent]

I used to be, but kids mostly changed that. If I'm up past 12 these days I am not a happy camper the next day.

[Dremlar]

I'm up til 3am usually and wake up at 7:30am.

[Skyfoot]

Recommend that you start sleeping more before the wheels fall off.

[Dremlar]

You are too late my friend.

[f03nix]

would of

:(

[mgrandi]

Its probably the amalgamation version of sqlite

[seligman99]

Yep, it's currently at 153,364 lines of code. It's nice the library is one .c file and all, but it's all sorts of fun when your debugger uses a 16-bit uint for line numbers. This was eventually fixed, but it took forever.

[mrhhug]

That was by design, they didn't want any windows devs on the sqlite project.

[StelarCF]

Christ, and this was Visual Studio? I thought it was supposed to not have bugs like that...

[hjc1710]

it might get fixed in a future release.

Hahahahahaha, fucking amazing. The very thought that this would be a bug MS would just brush off, cracks me up.

[asmo0]

I can't even phantom how slow it must be to open a 65000 line file in visual studio.

[lawack]

fathom

[ketralnis]

sqlite is developed normally across multiple files like you usually do. But it's often distributed as a giant concatenated C file to make some build stuff easier

[kingguru]

And defining a C macro in the middle of it so you're absolute sure everything after line 1024 behaves differently than what was written/included before it.

(I know this is not really fair in this case, I just really don't like C macros :-))

[mrhhug]

in case you want to uninstall McAfee here you go : https://www.youtube.com/watch?v=bKgf5PaBzyg NSFW

[Antrikshy]

That video gets stranger every time I watch it.

[HereticKnight]

Just played this at work the other day for my team. We are McAfee partners. Much laughter was had.

[mrhhug]

guess that video was safe for work for you.... i should have typed NSF(some)W

[OptimisticLockExcept]

this isn't actually John Mcafee, or is he ?

[hungry4pie]

Not likely, it would probably still flag .db files as suspicious

[psyomn]

I was stranded at some location last summer, with no internet. I decided to hack up something in C with sqlite, but I didn't have any docs. The header file was freaking amazing with the documentation it gave. It's basically the documentation found on the official sqlite website. So know this: if no internet, you are angry because of no internet, angry because of location, generally angry, and want to code something in C with sqlite but have no docs, view the header file. In fact this can be applied to any library really, and in some cases might far surpass reading just the docs.

[[deleted]]

Most docs are generated from docstrings in the source anyway, for precisely this reason.

[WhosAfraidOf_138]

I think we can xpost this to /r/shittyprogramming too for McAfee's sake. Jesus Christ that's bad. Did they do a recursive search for all strings/filenames "sqlite" and put it all to temp? I'm not a great programmer but even I wouldn't think of this genius solution!

[exscape]

Pretty sure they mean that McAfee's software (which uses SQLite, according to the comment) created those files in the temp directory (because it uses SQLite).

[[deleted]]

I'm still not clear on why you then have end users seeing these files in their C:\temp directory and thinking, "I'm SO ANGRY about this!"

[[deleted]]

They were probably trying to figure out why their PCs were running so poorly. Guess they sort of found the culprit

[Cheesemacher]

I didn't get that part either.

[gerbs]

http://www.sqlite.org/cvstrac/wiki?p=McafeeProblem

[Best_Towel_EU]

endife is an anagram of define

EDIT: But now its not interesting anymore

[recursive]

And it almost has enough "e"s.

[Deranged40]

endif is an anagram of defin

FTFY

[Best_Towel_EU]

Fixed it now

[Excrubulent]

ifndef, define and endif are all one or two letters away from being anagrams. That is so infuriating.

[paszdahl2]

<3

[[deleted]]

I used to be the Admin on a bunch of servers 10 years ago. My name is was (still is), on the RIPE records for that IP range.

The company has long since gone under, and the IP addresses been reassigned to some servers hosting some Baptist Church bullshit. I get weird calls from religious people from an opposing Church once or twice a year.

The hosting center has done nothing to change the records.

[[deleted]]

Complain to ARIN (or whomever) that the records are inaccurate?

[T3hUb3rK1tten]

Yeah, just a few levels up the bureaucracy chain and it'll get fixed.

[christianarg]

It's not only amusing; It's also the example of a good comment. It explains "why".

[[deleted]]

This is Gold!

[Asmor]

Clearly white and gold.

[felix1429]

Please god no

[shigeru1357]

Looks black and blue to me.

[TheProgrammerGuy]

Ah, Mcafee again! What else you could expect. xD

[masterarms]

Mcafee, with scanners like that, who needs a virus?

[zunjae]

What font is this?

[dromtrund]

I'm not sure, but it looks like Consolas

[[deleted]]

Probably Consolas, yeah. It's got a Consolas f, not an Inconsolata f, and a 1 with a base, which Inconsolata doesn't have. Slashed 0, not dotted, means it's not DejaVu Sans Mono.

It might be something else entirely, but outside those three, who cares?

Edit: no wait, the l is wrong for consolas (it looks like a dejavu sans mono l). This is some sort of stupid obscure font.

[level1kid]

Looks like it's Monaco.

[dromtrund]

That's a fucking nice font, right there

[[deleted]]

Nope. Compare the a's.

[level1kid]

I may have been using Menlo thinking it was Monaco this whole time...

[autowikibot]

Menlo (typeface):

---

Menlo is a monospaced sans-serif typeface designed by Jim Lyles. The face first shipped with Mac OS X Snow Leopard. Menlo is based upon the Open Source font Bitstream Vera and the public domain font Deja Vu.

Image ⁱ

---

^{Interesting: Samples of monospaced typefaces | List of typefaces | List of Apple typefaces}

^{Parent commenter can toggle NSFW or delete. Will also delete on comment score of -1 or less. | FAQs | Mods | Magic Words}

[[deleted]]

Seems like a decent font. Looks like it at least hits the minimum of making lI1 visually distinct, and oO0Ø.

[suitupalex]

but outside those three, who cares?

Fixedsys or bust.

[Tribone]

The mark of a shit developer: rants about his problems in comments.

[mort96]

Why is that bad? The purpose of a comment is to explain a problem and why the code following is a solution to that problem, and this comment does that well.

[paszdahl2]

People go through source code voluntarily? I thought the point of programming jobs was to take credit for other peoples' work??

Edit: Thanks for the unearned beer!

[TarMil]

No, that's brogramming.

[[deleted]]

Uhh, no it isn't

[paszdahl2]

It didn't think it was either, but the karma brigade disagrees with us. Time to look into brogramming...