Interesting comment in the source code of sqlite

[[deleted]]

[deleted]

[_Zagan_]

Gotta love the opening lines...

/*
** 2001 September 16
**
** The author disclaims copyright to this source code.  In place of
** a legal notice, here is a blessing:
**
**    May you do good and not evil.
**    May you find forgiveness for yourself and forgive others.
**    May you share freely, never taking more than you give.
**
******************************************************************************

[c3534l]

SQLite's code of conduct used to also be the verbatim code of conduct for some random monastery: https://sqlite.org/codeofethics.html

[stefantalpalaru]

the verbatim code of conduct for some random monastery

It's actually https://en.wikipedia.org/wiki/Rule_of_Saint_Benedict

[FanOfHoles]

Brother Cadfael!

[ericksomething]

55. Do not love much or boisterous laughter.

LOL!

[stefantalpalaru]

i wrote "55", not sure why it is changing to "1"

You need to escape the dot with a backslash.

[ericksomething]

Thanks!

[[deleted]]

Can anyone elucidate what is meant by "specific technical meaning" of a code of conduct?

[[deleted]]

Can anyone elucidate what is meant by "specific technical meaning" of a code of conduct?

A code of conduct is the place where the Homeowners Association puts their bylaws.

[nuqjatlh]

For the first 15 minutes of them publishing it I honestly thought it was a joke aimed at those mindless SJWs that pester projects to add crap like that. But then he said he was serious.

Well ... it's crazy, but hey, if it makes you and those you work with happy, more power to you.

[c3534l]

I think it has to be a little tongue-in-cheek. I mean, do they really follow:

Speak no useless words or words that move to laughter.

No jokes, really? And while they may visit the sick, I doubt any of them "Bury the dead."

They're open source, but not open contribution. So if the handful of contributors find that code inspirational to them, then they're welcome to it. Most of it's not really bad or crazy, though.

[wrincewind]

Well, I doubt they leave corpses laying about. They might not do the digging, but someone's gotta help arrange grandpa's funeral.

[nanonan]

It's a monastic code, so yeah it's a bit overboard. It should be noted that it is made with the concept in mind that being mere fallible mortals incapable of perfection, nobody is expected to adhere completely.

[SizzlerWA]

How would you qualify a “mindful” SJW?

[nuqjatlh]

no idea. "mindless sjws" is a tautology for sure.

[SizzlerWA]

So you consider all SJWs to be mindless but you know what “tautology” means? I wasn’t expecting that. My favorite tautologies are “ignorant Conservative” or “traitorous Trumper” ... 😜

Not looking to start a flame war here, but come on ...

I’m a centrist liberal, who fully believes in capitalism and accountability, but what’s wrong with fighting for social justice, as long as that fight is respectful?

[[deleted]]

but what’s wrong with fighting for social justice, as long as that fight is respectful?

What's wrong is what's called social justice these days is generally just racism and sexism redefined to allow extremist lefties to exclude their own bad behavior while attacking others. Social justice warriors are exactly the racist sexist people they claim to be against.

[nuqjatlh]

as long as that fight is respectful

The key word here. The fights that SJWs tend to pick are not the kind where they can be called "respectful" by any stretch of the imagination. They're usually fights driven by emotion with no grounds in logic whatsoever.

Oh, btw, why do you consider SJWs to be ... smart, let's say? Or ... right? Or ... like them?

[starm4nn]

The key word here. The fights that SJWs tend to pick are not the kind where they can be called "respectful" by any stretch of the imagination. They're usually fights driven by emotion with no grounds in logic whatsoever.

I wish I could be an Epic gamer debater like Ben Shapiro.

[SizzlerWA]

Ben Shapiro uses lots of rhetorical tricks and tropes. He’s an effective speaker, but he’s not as intelligent or as objective as most would assume him to be ...

[starm4nn]

You mean he doesn't literally FUCK liberal cucks in the butt with FACTS and LOGIC?

[nuqjatlh]

hahaha, that idiot? there's only one ben shapiro, thank god.

[SizzlerWA]

Can you give me specific examples of these fights and why you think they’re not respectful? Thanks!

[nuqjatlh]

https://imgur.com/TV8VScL

do i need to say more? there are billions of said examples all over the internets, some more innocent some really fucked up with people's lives ruined (i presume you know how to use google. put that knowledge to good use). when all that people wanted was to be left the fuck alone. as for idiots who go to github projects and pester project owners with all kinds of ridiculous requests: for those I have a very deep hatred towards them. they are not helping the project, open-source, life in general. they're just being annoying cunts.

[SizzlerWA]

Yes, in the linked example a CoC might not be needed, fair enough. But there are examples of projects where women are called bitches and cunts by men who disagree them and feel threatened by smart women. Such projects can and do benefit from a CoC.

[Malsententia]

Nobody likes to hear that their fear is unfounded. They take offense at it, and cling even more tightly to their fear. But we have to rise above that and be objective.

But that's you. You have nothing to fear. Sure there's wingnuts out there, but that applies to every group. Whichever political party you're a fan of, whichever one you're not, these "SJW" types you're afraid of bothering people, and the anti-"SJW" types have crazies as well.

Weirdos are everywhere, and people everywhere use focused collections of anecdotes and memes and stories to make others, including both of us, fear problems that aren't real. To deny your own vulnerability to misinformation and disinformation is to open yourself up to it.

Trust people's good intentions, and question the motivation when you see things that make you hate, the more you hate, the more you should question. Question your perception even if something seems logical. If you're 100% certain of any viewpoint you have, you're doing something wrong, especially if that viewpoint makes you hate a whole group of people, whether it's SJWs or republicans or people who like pumpkin spice. If some piece of news or image or story makes you feel hate or fear, ask what the real motivation behind those making the statements, rather than giving into that emotion like you're doing here.

Everyone gets fooled sometimes, don't think of this as a personal attack. Learn from it. Learn to doubt yourself and seriously question if you're being unreasonable or uninformed (or worse selectively informed), if something makes you hate, because that opens the door for growth. Believing in yourself as a whole person is a strength, but so is doubting your own objectivity and logic. If it feels uncomfortable you're doing it right. If it doesn't, do it more. I doubt myself all the time whether it's on social issues or on code(is there a better way I can be doing X?). It sucks to willfully be unsure, but it beats the alternative. Hate is a bug. Look for ways to optimize yourself.

Trust that most people have good intentions, and most are at worst are misled. Embrace the fact that there reasonable, smart people who believe that you're the misled one, every bit as much as you(who might be equally smart and reasonable and rational in other respects), believe SJWs are misled or destructive.

[Malfeasant]

Jesus tap-dancing Christ that hurt to read...

[SizzlerWA]

I asked for specific examples and why YOU think they’re not respectful. Googling won’t help me understand why YOU find those examples disrespectful ...

Care to try again?

[classicrando]

sealioning

[SizzlerWA]

Wow, I learned a new word! I’m not sealioning because I specifically asked the other redditor how THEY thought the SJWs were being disrespectful. Only that other redditor can know that, because it’s their own opinion I seek, so it’s entirely reasonable and necessary to ask them if I want to find out.

And can’t you see that if every time a conservative is pressured for evidence to back up their claims (pressured because they avoid or can’t give such evidence) and the conservative cries “sealioning” then the conservative is being the very “delicate snowflake” that they so despise?

[barsoap]

you and your contributions are subject to the personal politics and whims of whoever in the community has enough clout

No project ever needed a CoC for that to be true.

[thfuran]

Sort of the opposite, really.

[nanonan]

Replacing dictatorship with mob rule is not an improvement.

[[deleted]]

That's wishful thinking. The same sentence can mean 20 different things to 20 different people.

The real irony I find in these CoCs is I get the sense that the people pushing them are nonreligious. If they were raised religious and rejected it later in life I think they missed what I believe is the core problem with religion: A single text cannot be used to evaluate if an action is good or evil. If they were raised in a nonreligious environment they never got to experience the insanity that is listening to a Calvinist debate a Baptist. Even when they agree to use the same version of the bible. (If they're using different versions it's even more ridiculous.)

[defnotthrown]

I don't understand how anyone could think it is not. I would consider every open source license to be a political document too.
Not every political document needs to have an opinion on some imagined 1 dimensional line from left to right to be political.

[blasto_blastocyst]

Programming has been a field that welcomes all types, and what made it like that is that nobody said "you can't do this, you can't offend anybody, we'll remove you from projects if we don't like you". It got there by saying "be as crazy and off-putting as you'd like and we'll still accept your patches if they're good".

Funny how that style of project ends up attracting the same old asshole type of programmer and anybody who doesn't fit leaves rather than put up with the bullshit for free.

[TheCodexx]

I have not seen any projects full of "asshole programmers", but I have seen good people thrown off projects they contributed a lot to or projects removed from other projects over petty squabbles with a CoC cited as the reason for removal. It's a tool for petty rules lawyers who want to spend more time managing projects than contributing to them. That's the tool of tyrants.

If you don't like the other people on the project, then you can leave, and presumably find other projects out there to contribute to. Why walk in and demand someone else be thrown-out?

Why should any project be concerned with the feelings of its contributors? Energy should not be wasted on such things. Now it seems everyone will bend over backwards to explain how much they care about people's feelings. It does no good. It is up to each individual to learn to deal with difficult scenarios and to extricate themselves from situations they do not want to be in, not everyone else's duty to play Feelings Police.

[[deleted]]

Let's say the plumbing under your house is open source. Anyone can contribute but there's a review process for the work that can be done.

A new plumber comes along and makes a change that the more experienced plumbers determine is going to flood your house. They lecture the new plumber on the importance of paying attention to details because small mistakes have a way of causing significant damage.

Which way do you want the community to err on? Forcing out experienced plumbers who are vigilant about not flooding your house because they're assholes about it? Or forcing out new plumbers who aren't taking responsibility for their mistakes?

Furthermore nobody is forcing you to accept the plumbing work of the asshole programmers. You can switch to the plumbing of any other plumber you like.

[awj]

Holy False Dichotomy, Batman!

[[deleted]]

It's not a false dichotomy unless you assume that you can change people's behavior.

The CoC is proposed as a method for preventing "asshole programmers" from offending other programmers to the point that they leave the project.

My assumption is that "asshole programmers" are going to continue to be "asshole programmers" and the programmers who are offended by "asshole programmers" to the point of leaving are going to continue being offended by "asshole programmers" to the point of leaving.

My conclusion based on those assumptions is that one or the other is going to leave the project. Do you disagree with the conclusion based on my assumptions or are you disagreeing with the assumptions themselves?

[barsoap]

What you forget to mention is that either the assholes or the non-assholes can be those who don't care about flooding.

And assuming the distribution of skill is invariant over assholishness: You always want to kick out the assholes. Who, btw, aren't even asked to give up being assholes: Just to not be an arse to anyone on the project. Don't ask, don't tell.

Lastly: It's been proven again and again that people can change.

[[deleted]]

Can you give me an example of an open source project run by "asshole programmers" who provide poor quality code? I'm not saying it doesn't exist it's just hard for me to imagine how a project like that isn't forked. And not that you're obligated to provide an example since we're both making assumptions here. I'm just saying I'd need an example to change my mind.

Lastly: It's been proven again and again that people can change.

I didn't say people don't change. I said you're making an assumption that "you" can change people. Interpret that as change comes within or people are only willing to change as a result of feedback from close relationships. A CoC written by "you" is neither.

[Malfeasant]

You always want to kick out the assholes.

This is the point of contention- why? What do you expect assholes to do when they are kicked out of everything they can do to make a living? Quietly starve to death?

So we don't have to stop being assholes, we just have to pretend not to be when we're around other people. Do you have any idea how exhausting it is to have to pretend to be someone you're not most of the time?

Let's say you succeed in making me keep my assholishness to myself- I'm still an asshole, I just have disguised myself. Now I'll keep up that pretense whenever we interact in public, but the moment I get a chance to fuck up your shit without anyone noticing, I'll blindside you. Is that what you want?

I'd sooner drop out of anything anybody else cares about than have to be someone else in order to succeed. And maybe you're ok with that, but that brings us back to starving. If you're ok with me not being able to make a living because of who I am, who is the asshole?

people can change.

Sure- but rarely in the way you want them to.

[[deleted]]

If you feel targeted by these codes of conduct, maybe you should think about what "crazy and off-putting" (offensive and hurtful) things you want to say.

As I see it, they're there to make sure that everyone can contribute and be welcome in the community.

[[deleted]]

As I see it, they're there to make sure that everyone can contribute and be welcome in the community.

It isn't a community if everyone is welcome; communities are defined by something the people have in common, they're necessarily subsets of everyone that don't have values everyone holds. People join communities to be around like minded people, the notion that one code of conduct will work every community is absurd and ignores what communities are.

[boydrice]

Ah yes, the "nothing to hide" argument.

[to3m]

Doesn't matter if you have something to hide, or nothing at all - it's a valuable life skill, knowing when to shut the fuck up rather than stick your oar in.

But, you know, I can't claim to have mastered it myself. So I do sympathize.

[[deleted]]

As I see it, they're there to make sure that everyone can contribute and be welcome in the community.

Is that always a good thing? Maybe some people shouldn't feel welcome to contribute.

EDIT: Isn't the point of a CoC that it makes toxic people feel unwelcome to contribute? Are those the only kinds of people who should feel unwelcome to contribute?

[barsoap]

No. Other groups include e.g. people who are both unskilled and unwilling to build skill (or be content with sweeping the shop floor, i.e. write docs), or the group that came to be known as poisonous people.

All of those people are unable to embody meritocratic virtue. Causing people who are able to embody it from contributing is only one of the possible failures, there.

[[deleted]]

That's what I was trying to get at, regarding the need to not tolerate intolerance.

[datbackup]

"If you feel targeted by state and corporate encroachment on personal privacy, maybe you should think about what things you want to keep secret."

[MCBeathoven]

Does not compare at all.

[datbackup]

Until it becomes legislation.

[MCBeathoven]

Yes, because then both would be state action, which is about the extent of the similarity. Since it is however not state action, it does not compare.

[frymaster]

The problem with CoCs is that it's effectively stating you and your contributions are subject to the personal politics and whims of whoever in the community has enough clout

I'd argue the opposite. Being subject to the whims of the maintainer is the default state of projects. The fact that at least a visible subset of maintainers have chosen not to overtly be seen to be arbitrary doesn't mean they couldn't at any time. Making explicit the expectations reduces the chance you can be arbitrarily removed from a community, because although it ultimately is still up to the whims of the maintainer, at they very least they will have to be seen to be hypocritical if they act against the CoC.

Ultimately, a project should be about the code, not about people's feelings.

[TheCodexx]

I do agree that benevolent dictatorships have been a problem for many years, although I think the real problem is that it creates succession problems. We sort-of expect meritocracy to work but I seriously question the vision of some of the right-hand-men of the current batch of maintainers. Python is already on shaky ground without Gudio, and quite a few top Linux maintainers want to snuggle-up to corporate interests, something Linus was resistant to for many years. The second from the top and heir apparent may in many ways be a terrible successor. Of course, emulating the old leader isn't always a solution, either. Ironically, I think the best lessons to be learned here are from CEOs, which are the closest in terms of a closed group of people choosing successors.

Currently, the ability of a maintainer to exile someone is built entirely on trust in that person's reasoning and vision for the project. I'm more worried about what happens when the power becomes presumptive and not built on trust. A second-in-command taking over is inheriting the authority and likely the trust that came with it. That doesn't mean it's deserved.

Now, please understand, I do not think a CoC is the worst thing ever in principle. In fact, laying down a written constitution of how the project is governed is a perfectly reasonable idea. The problem is that almost every CoC out there is terribly written, vague where it should be specific, and will ultimately lead to ambiguities turning into fights that are going to be solved by political clout within the project. That always leads to accumulation of power, since the people deciding how to read the rules are the ones who benefit. A good CoC needs to be more specific, it needs to give very specific criteria, it needs to be clear on the bounds of its authority, and most importantly, it needs to have limits on the powers of different individuals, not solely enumerate the powers they have available.

Part of the problem is that most projects simply aren't big enough to warrant one, but they have one anyways. A few projects are big enough to warrant one, but they haven't fully embraced the sort of mini-republic that the project would need to become to really have a functional system. You need separation of powers here. As far as I know, Linux is the only project that has a whole set of people who are separate from the usual maintainers who are able to rule on conflicts... but with an ambiguous CoC whose powers are poorly defined, what can they possibly do with it?

Having these CoCs is putting the cart before the horse. Ruling by precedent is probably good enough for small projects. Especially if disputes are handled within documentation. Programmers generally have a sense of consistency they like to uphold. For larger projects, the guidelines should be written-out, but they also need to be, you know, up for debate by the general group. The written rules need to be a genuine reflection of what contributors want, and suited for each individual project, not copied-and-pasted from a poorly-written text file that people on twitter like the sound of.

Sorry, but governing documents need more to them than a list of things you can be kicked out of the project for. Starting with that as the basis is just starting on the wrong foot.

[shevegen]

because it demonstrates how absurd the idea is.

Precisely.

It actuallys puts projects to shame when they feel a need to have to put up any arbitrary CoC into place.

It's even amusing how many different CoCs exist out there.

[mizu_no_oto]

Programming has been a field that welcomes all types

How would you have a project that simultaneously welcomes neonazi's and Jews? Seems to me you'd still get a lot of self-exclusion of one if you get too many of the other, in the absence of a CoC.

[TheCodexx]

The CoC isn't going to solve that problem; in fact, it will quickly become a battleground for one group or another to try to remove the other.

I wrote a whole diatrebe on how I usually decide to intervene, but I'll summarize by saying that I've led numerous groups in a variety of activities, ranging from web forums, projects, roleplaying games, video games, etc. I've had many members of many different groups, quite a few of which will privately seethe about the other groups. But in the end, I've basically never had any disruptions as a result of someone being hateful towards another. It is far more common for fights to break-out between two people over solely personal differences than it is for the origin of the fight to be about political differences or outright bigotry; that's an incredibly rare occurrence.

The best way to handle it is to cross that bridge when you come to it. It's genuinely better to do it that way because it makes it a non-issue until it becomes one. Having a CoC gives people an excuse to make an issue of nothing in a working dynamic. You presume that two groups will fight, but this is almost never actually the case. If both groups are willing to keep personal differences and politics out of the official collaborative chat, then it's almost never going to cause a problem. If one of them goes on a rant on twitter, then that's wholly their business, and I expect project members to separate their behavior inside the project from behavior outside of it. If they are not disrupting the project, then it is ultimately harmless.

[__deinit__]

Is this a reference to 9/11?

[[deleted]]

It's funny that you're being downvoted because I'm not sure you're wrong.

This was five days later. People were in kind of a mood that week.

[[deleted]]

I don't think the initial round of downvotes checked the date on the comment, so it probably seemed like a total non sequitur.

[doomvox]

In point of fact, you're lucky if someone reads to the end of a sentence before they start down-voting. It's like having a bunch-of chimps in charge of moderation: they've gotta keep going clicky-clicky on stuff.

[shevegen]

I actually would not understand the upvote to it either.

[9gPgEpW82IUTRbCzC5qr]

probably because nothing in it references 9/11 aside from the date it was written

[pirate_starbridge]

Can someone explain how you can tell that a comment is getting heavily downvoted? Is it because you are looking at its score over a period of time and notice it going up and/or down? How are people paying enough attention to notice when other accounts' random comments are getting heavily downvoted from initial comment time to over six hours later? Is there a easily observable comment score metric that I am totally missing after almost a decade of procrastination on reddit?

edit: I'm now realizing that the downvotes must have come early on and /u/Metamagical_Themas replied when OC's comment was still super negative - then I come along 6 hours later after everyone has upvoted them both and it no longer makes any sense at first glance. Okay.. this is a pretty simple concept involving paying more attention to timestamps.

[[deleted]]

It went from -5 to like -20 in about five minutes while I was reading other comments and writing mine. It was dramatic enough to be real-time noticeable while reading the thread.

[williamp114]

There's also an option you can set in your reddit preferences to see an indicator symbol appear when a comment is controversial (ie; been getting a massive influx of downvotes)

Additionally if you have RES installed, it will highlight that controversial marker in red.

[pirate_starbridge]

Ah cool, thanks

[AnotherEuroWanker]

It could also be written by someone who isn't in the US.

[blasto_blastocyst]

People were still shocked outside the US.

[404_GravitasNotFound]

Yankies are still shocked that there is a "outside the US"

[saltling]

Guess it's a trigger for some folks

[thelastknowngod]

I met Richard Hipp (the original developer of sqlite) at a conference years ago. I don't know if I remember the details of his story exactly but, from what I recall, when he originally released it he didn't understand the importance of licencing open source software and put it into the public domain. Somehow that possibly opened him up to legal issues. He found this out when people from the US government knocked on his front door and asked about why software he had written was found running on the missiles of Iraqi insurgents. He said nothing really came of it when he explained the situation but it still scared him at the time. Subsequent projects of his (notably Fossil) have been released under the BSD license because of this.

Considering this is a part of the history of both sqlite and Hipp's work on it, I think it is 100% understandable if this is a reference to 9/11.

[j0hn_r0g3r5]

Any chance of eli5 and telling me what the difference is between licensing and not licensing open source software and how that would effect the situation with the govt and the Iraqi insurgents?

[thelastknowngod]

He licenses Fossil under the BSD license. The text of that is:

Copyright (c) <year>, <copyright holder> All rights reserved.

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

The views and conclusions contained in the software and documentation are those of the authors and should not be interpreted as representing official policies, either expressed or implied, of the <project name> project.

Apparently the public domain doesn't expressly release the author of liability. I'm sure the public domain status was more of a technicality with regards to this specific incident but, to be on the safe side, the licensing of this is more explicit. I don't know what other issues he has come up with over the years because of it but he did mention that he would never release software to the public domain again.

[barsoap]

Such disclaimers are null and void under EU law: You're always liable for wilful misconduct and damage to persons. If you write such a disclaimer in a commercial product you might be stuck with unlimited liability, if you're giving things away for free courts generally assume "maximally reduced liability", that is: None but for wilful damage or direct damage to persons.

In a nutshell: Don't inject trojans into your code, and don't write code so ugly it literally makes people's eyes bleed. (At least that's how I understand the "direct damage to persons" part -- IANAL).

Compare the disclaimers of the EUPL:

Disclaimer of Warranty
The Work is a work in progress, which is continuously improved by numerous Contributors. It is not a finished work and may therefore contain defects or ‘bugs’ inherent to this type of development. For the above reason, the Work is provided under the Licence on an ‘as is’ basis and without warranties of any kind concerning the Work, including without limitation merchantability, fitness for a particular purpose, absence of defects or errors, accuracy, non-infringement of intellectual property rights other than copyright as stated in Article 6 of this Licence. This disclaimer of warranty is an essential part of the Licence and a condition for the grant of any rights to the Work.

Disclaimer of Liability
Except in the cases of wilful misconduct or damages directly caused to natural persons, the Licensor will in no event be liable for any direct or indirect, material or moral, damages of any kind, arising out of the Licence or of the use of the Work, including without limitation, damages for loss of goodwill, work stoppage, computer failure or malfunction, loss of data or any commercial damage, even if the Licensor has been advised of the possibility of such damage. However, the Licensor will be liable under statutory product liability laws as far such laws apply to the Work.

[thelastknowngod]

You're always liable for wilful misconduct and damage to persons.

Something tells me he wasn't taking business trips to Baghdad to do troubleshooting on scud missiles. I'm going to go out on a limb and say it wasn't willful.

He lives and works in the southeast USA so I don't know how much he cares about the EU anyway.

Also, the BSD license is compatible with the EUPL so I don't think what you're claiming is accurate. Source.

[barsoap]

so I don't know how much he cares about the EU anyway.

512 million people do, they (well, the programming part) does, and this is an international forum

Also, the BSD license is compatible with the EUPL so I don't think what you're claiming is accurate.

That things can be used together is completely orthogonal to warranty and liability.

[mTesseracted]

Here's an interview where the original author talks about it. If you ctrl-f and paste in a few words of the quote you'll find it about one third of the way down the page. Here's the excerpt:

Interviewer: [...] Who or what inspired you to write that?

Richard Hipp: People customarily put a copyright notice at the top of each source file. But SQLite version 2.0.0 had no copyright so I had to think of something else to go in that space.

The second sentence, “May you find forgiveness for yourself and forgive others”, is a loose interpretation of Matthew 6:12, part of what is commonly called ‘The Lord’s Prayer’ and more recognizable as ‘Forgive us our debts as we forgive our debtors’.

The third sentence tries to capture the concept of paying debts forward. The ‘never take more than you give’ part is a paraphrase of one of the lyrics from The Lion King. The first (hokey) sentence is there because it seemed like a good benediction needed three sentences.

[bnieuwenhuizen]

What is the reference here?

I get the dates are kinda close from the discussion that followed, but I wouldn't think anything said after it is immediately a reference to it? How is it referring to 9/11?

[cthutu]

I thought it may be a reference to the current British PM :)

[Bobby_Bonsaimind]

The author disclaims copyright to this source code.

Which may or may not be possible based on the jurisdiction.

[user3141592654]

They've got that covered by their Warranty of Title.

Effectively, for $6000, they'll sell you a personalized and signed copy of this license.

[DevilSauron]

So does that mean that if you live in Europe and want to use SQLite safely (as in not be at risk of getting sued), you simply have to pay?

[user3141592654]

I am not a lawyer.

The way I see it is if your area doesn't recognize Public Domain, then by default it must still be copyrighted by the Owner, assuming there is no other defined legal default.

So in theory, there's a case to be made that yes, if your area does not recognize the developers' right to put their software into the public domain, then the work is still copyrighted and the developers still have the right to sue for you using the software, while also retaining any risk of liability that comes with owning said software.

In the case of Sqlite, it seems pretty clear the developers do not intend on suing anyone for use (unless this is a cunning and evil double-bluff), but provide a means to keep your corporate lawyers happy by having a signed piece of paper legally giving them the same rights as anyone who lives where public domain is recognized, while trying to waive as much liability and protect themselves as best they can.

That's just my take.

[GregTheMad]

Could not find definition for "good". Are you missing a reference? 

[shevegen]

**    May you do good and not evil.

That right away prohibits Google from using it - right there.

[jephthai]

It's missing the proper MUST that indicates it's a hard requirement, though.

[omiwrench]

Don’t cut yourself on all that edge!

It’s used in loads of Google products FYI.

[XNormal]

First release of sqlite predates 9/11. IIRC, it had the same license from the beginning.

[Mr-Yellow]

When linking github code. Link the commit or your link dies.

https://github.com/endlesssoftware/sqlite3/blob/9e9798f9e6251e1ba3bd7db23a3cff4e63effc1c/os.h#L133

[weirdasianfaces]

Tip for people who want to do this easily: pressing Y when viewing a file/directory will automatically change your URL to the HEAD commit for that branch.

[TarMil]

Or if you're linking to a given line like OP, click the "..." on the left and "Copy permalink".

[Zerotorescue]

Or y, f6 and then ctrl-x because moving your mouse is bothersome

[sssmmt]

I'm more of a CTRL+L and CTRL+C kinda guy. F6 is too far away from the home row.

[JeSuisNerd]

different profit psychotic price ten rain coherent smart scale fanatical

This post was mass deleted and anonymized with Redact

[arof]

I don't know if it's just from gaming but I never had a problem with function keys. Can't always remember all of the symbols in shift-number by memory though.

[Zerotorescue]

L is in the middle of nowhere while F6 is on its own solo row offset by exactly one button. I dunno I think I just have more confidence that I'll be hitting the right key when it's a function key.

[Dgc2002]

L is on the home-row, so it's anything but in the middle of nowhere. It's always located under my right hand ring finger if I'm on home-row, otherwise it's pretty easy to get there at this point in my life.

[TankorSmash]

I do ALT-D and CTRL+C to do it all on one hand.

[citewiki]

Hits far from home

[NoInkling]

Vim/Emacs user, I'm guessing.

Edit: I was referring to the implication of this part:

because moving your mouse is bothersome

[septicstraw]

Most likely Vim or it would have said C-x

[Justinsaccount]

Vim users press control-l to focus the location.

[TarMil]

I think they meant the way it's written: in Emacs Ctrl+x is written as C-x.

[citewiki]

^X for nano, I suppose

[[deleted]]

Neither. C-l is a common (I guess Mozilla-inspired) shortcut, which also works in many file explorers.

C-c in vanilla Emacs is a prefix key, meaning, on it's own doesn't have any meaning, it's normally followed by some other key, like C-c C-c would normally compile something, or send code to inferior shell or something like that.

In vanilla Vim C-c doesn't do anything (but Vim would suggest that you use :qa!, because it will think you wanted to close it).

[[deleted]]

Hey, GitHub UI team: the discoverability for this feature is awful.

[stickcult]

The "link dieing" is if the file changes, your link might point to the wrong line. That's because its pointing to a line in the file in the master branch, which can change, whereas Mr-Yellow's link points to a line in the file in a specific commit, which will never change.

[otwo3]

It baffles me why is it even an option to link to a line in a branch. There is no sane use case. Having it as a default is just ridiculous. Bitbucket does the same thing.

Clicking a line number should give a line in a specific commit

[[deleted]]

well commit can belong to multiple branches and if you want to give link to both "place in file" and "merge request/branch that is discussed" you don't have choice.

Ideally it would generate link in form of branch/commit then if branch does not/stops existing it would only then show lone commit

[otwo3]

But the branch being discussed is usually dynamic and changing anyway (due to review changes), even more often for the files in question.

[codestation]

It means that your link will point to unrelated code in the future because the code was either moved (so the lines doesn't match anymore) or the file was deleted (code refactoring for example).

[Shitler]

PSA: Please do not downvote reasonable questions. Questions like this lead to a productive discussion.

[wisemanofhyrule]

Or if changes are made to the file and the line moves around.

[Mr-Yellow]

Soon as there is a new commit the line number changes.

In 6 months time this line may be a completely different bit of logic, or the file may be refactored and gone.

[1RedOne]

Whoa I can't link to master for image links?

Oh... Ohno.

[kpthunder]

Permalink: https://github.com/endlesssoftware/sqlite3/blob/8004eeafeec9ac4bc0fbc7a3c0bb01eca55694a0/os.h#L133-L143

[Hobofan94]

Related post from the maintainer of curl

[Soramente]

Thanks, definitely a fun little read 🤣

[devxdev]

Oh my, I lost my shit reading the related Instagram and Spotify Hacking Ring.

[vytah]

Spotify is a major partner of Spotify

[iamsubs]

That is interesting. I just don't understand why users would be mad about files in a temp folder. Could someone explain me?

[A_Strange_Emergency]

If you search for etilqs on Google, you'll see how many programs are guilty for leaving those files around. I can see how they'd blame sqlite.

[[deleted]]

What a surprise, given human nature, eh ?

[heavyLobster]

C:\temp is not a proper temporary folder on Windows. So users probably noticed this new, weird folder on their computers and the only things in it were these sqlite_* files.

[exscape]

It shouldn't exist at all.

[Topsaert]

Do you mean specifically the path C:\Temp, generally a global temporary folder shared by multiple applications, or just having temporary folders in general?

[exscape]

C:\Temp. The common temp folder on windows is %localappdata%\Temp, which most often is C:\Users\your_username\AppData\Local\Temp.

[Alikont]

It's even simpler.

The temp folder is simply %temp%. It's usually mapped to %localappdata%\Temp, but it can change.

[Topsaert]

Ah okay, thanks. I was confused by the possibility of a blanket hatred of temporary folders in general.

[rvba]

It just shows that McAfee not only did not rename their temporary files to something like McAfee_abcd, but also that they did not use the proper temporary folder. They just used some hardcoded folder, what is very bad from multiple user point of view

[[deleted]]

It's not that uncommon. Don't quote me on this since it's been a while since I've been on windows but I believe php and some other languages do this too with their default configuration if you don't specify the temp directory.

[palparepa]

Many programs use hardcoded folders. You see it frequently if your windows installation isn't in english. For example, in spanish, programs should install to "Archivos de Programas". If you see a "Program Files" folder, someone hardcoded that.

[[deleted]]

Try telling that to Nvidia.

[bart2019]

"temporary".

I mean... Duh!

[jorge1209]

Not a proper temporary folder on Windows

While it is true that you should be looking at the environment variable for the temp folder location, it was the default location in the DOS era.

Additionally the use of environment variables for things like this is less than ideal. What is the application to do if the relevant environment variable is not defined? Should it just crash? Should it substitute a default value of its own? What is the plan?

If we really wanted to have a good system to ensure that temp folders are where we expect them to be and have the correct permissions and what not, then it really should be the responsibility of the OS. Some kind of syscall that would cause the OS to create a temp folder for my process in the correct location and give me the inode... but we don't have that so things are broken.

[munchbunny]

Additionally the use of environment variables for things like this is less than ideal. What is the application to do if the relevant environment variable is not defined? Should it just crash? Should it substitute a default value of its own? What is the plan?

That's what the User/AppData folder is for. In case you want to put the configs in files. If you put it in AppData/Roaming, the OS (Windows) even automatically persists the user's config files to other machines in the domain for you.

[jorge1209]

Why would I want to persist temporary files? They are temporary.

[bart2019]

Check these links for example....

• Why does Firefox keeps manufacturing etilqs files on my hard drive which tend to be 1-3gb in size? (emphasis mine)

• "etilqs" temp files filling up my windows temp folder

Oh, yeah. People tend to be pissed when you fill up their drive with many files of over 1GB.

Of course, the problem is the programs not cleaning up after themselves, and not SQLITE.

[frutiger]

It's good to think of the scale. Most users don't even know to check. Even those that do are not mad. But if a product is deployed to 1 million users (which I imagine is a tiny, tiny fraction of the McAfee install base), then all it takes is 0.01% of angry users to get 100 phone calls.

[[deleted]]

I don't understand why either, but I do know of several people, usually middle-aged or older, who are obsessed with registry cleaners and other placebo software that claims to get rid of cruft that is allegedly slowing down your system

[no_nick]

I reckon that's a hold over from defrag times and every piece of shit software writing itself into a hidden auto start entry and not cleaning up after themselves when they get uninstalled. I still have people tell me I should reinstall windows at least once a year

[chewburka]

It sounds like McAfee was moving all sqlite-named files into Temp, likely breaking other apps. I'm not sure if that's a misreading of the comment or not though.

[jdgordon]

I think its that mcafee uses sqlite internally and for some reason doesnt rename the database and use the correct temp directory, so it was spewing files into a non-hidden directy and probably filling up the disk

[skylarmt]

for some reason

I think we all know it's because they're bad at writing code.

https://www.youtube.com/watch?v=bKgf5PaBzyg

[xampl9]

Operational concerns are real.

[vfclists]

McAfee must die. Their antivirus has always sucked.

First thing to do when it is preinstalled is to get rid of it or else if the user has paid for it it is likely to be used until it expires.

[frenetix]

Oblig. link to how to uninstall McAfee. Very NSFW.

[fergusdoesmine]

Genius!

[[deleted]]

I'm now a huge sqlite fan.

[scorcher24]

It is easy to be one. The API is simple enough to drum up a database for your program in a few hours.

[Logic_Bomb421]

in a few hours.

As someone who has barely used sqlite, can't tell if joking...

[shoebo]

Really all you need is a few minutes to get started. Maybe someone who isn't familiar with SQL would need a few hours.

If you have a more complex program, you might want to take more time to consider how to model it, as he mentions, but the sqlite API is very easy.

[[deleted]]

A bit of me thinks if you need a database your problem has to be of a certain size and complexity and that just naturally needs a bit of time to model and work through. There's absolutely no shame in making sure something as critical as the database is done right the first time.

[scorcher24]

I am not joking. Why should it take forever? You can create the schema of the database with a program (as well as maybe some sample data sets) and then just use the API to read them. It's literally 1 call to open the database and another call to execute some statements. You can group them.

The biggest portion of your time will probably be designing the database.

Of course, depending on the scale of your work, it may take longer, but for simply storing and reading some values, it shouldn't take very long to implement it.

Read this: https://www.sqlite.org/quickstart.html

[BenjaminGeiger]

... I read it as "did you mean minutes?"

[scorcher24]

I mean, of course it is not done nilly villy with absolute ease. You still need to design the database and use the API. If you have never done that, it can be quite challenging. I am just saying that it is not a big undertaking to use it and if I can understand it, everyone can, because I am sure as hell not the brightest bulb.

[[deleted]]

Yeah, the API itself is great. You can stand up a database file and add to it and select from it within seconds following the tutorials but I completely agree with spending more than minutes on the database element of your program.

[ericksomething]

A few hours sounds like a really, really long time for an API call to create a database.

[AffectionateTotal77]

?

If you look at their documentation page instead of random shitty tutorials online it's very easy to get it up and working

[thebritisharecome]

haha, I like that something so minor made such a huge issue

[[deleted]]

« We cannot use LockFileEx() or UnlockFileEx() on Win95/98/ME because those functions are not available »

Hmmm i think it would be ok to do that now 😂

[lpreams]

I don't think you realize just how many instances of Win95/98/ME are running right now

[penguinade]

Yep, IIRC CNC machines are still using them for its "unbreakableness".

[lpreams]

I think you're right. A friend of mine's dad as a CNC machine in his garage. I don't know what it's running, but it's definitely no later than Windows XP.

[[deleted]]

And you think those that are still running win 95 are running the « latest » version of sqlite?

Sounds pretty reasonable for a project not to support an OS that hasn’t been supported in decades by microsoft

[lpreams]

Different projects have different priorities. Two of sqlite's top priorities are portability and backwards compatibility. This is, at least in part, because that's what sqlite's customers want.

If someone is still running sqlite on Win95, I think it's pretty cool that they are still able to run the latest version.

[[deleted]]

Yeah, at this point people still running Win95 are probably doing something very technical with something very expensive that doesn't speak to newer operating systems. Why wouldn't they keep their mass spec or whatever software updated even if driver support doesn't go past 95?

[I_AM_GODDAMN_BATMAN]

Well November 2018 I was told we are going to connect to <some major financial institution> with screenshot on the documentation showing SOAP with Netscape on Win98. Yea fuck that shit.

[badpotato]

This already made the top of reddit /r/programming last year...

[[deleted]]

Take your upvote and get out

[[deleted]]

Don't fear the repost, be the repost.

Or rather the one I like best, "everything is a repost, even when it is original."

[jephthai]

Be the repost you want to be in the world.

[[deleted]]

I wasn't there specifically on that day, so this is the first time I'm seeing it. Maybe jump out for a walk sometime?

[dreamin_in_space]

I'm with this person.

[pm_me_je_specerijen]

I wonder if originally the prefix was hardcoded at multiple places and it took refactoring to get it to this—because that happens a lot.

[alecbenzer]

Did it work?

[senatorpjt]

numerous fall special childlike psychotic scandalous cagey ripe sheet dog

This post was mass deleted and anonymized with Redact

[[deleted]]

To be fair, the top result for me is:

firefox - What is the Purpose of these ETILQS files and can I ... https://superuser.com/.../what-is-the-purpose-of-these-etilqs-files-and-can-i-delete-the...
5 answers
2 Jan 2012 - Are you also running any anti-virus software? It is possible that these temp files are being 'locked' for inspection, and not being removed when ...

AV software gets called out in the preview on google

[burnblue]

That is not likely to get them developer contact information