Amusingly there exists a "Why SQLite Does Not Use Git" article (https://sqlite.org/whynotgit.html), but there is no corresponding "Why Git Does Not Use SQLite".
Well the big difference is that an sqlite db has to be running. Git repos just exist as long as the files are on disk, which I think is a mental model people are very used to by now.
Sqlite does not have a server component (although there may be other projects that do provide sqlite as a server). Sqlite files are also just files on the disk.
Now I wonder when the first polyglot file was published. I kinda just assumed they'd been around forever. EICAR.COM comes to mind as a COM/plaintext polyglot
Players that don't know the technical term "billboarding" might use this as a way to say that the images of the food are "flat" unlike the rest of the 3D modeled environment. Just a suspicion!
I can also be used for derogatory connotations; Another example is for Smash Brothers specifically, the Byleth character's ultra move has a flat image of a character in their game and people call it "png sothis" (character name) to suggest that it's low-effort or not well made
"flagged" generally means flagged by users, which is an option with enough Karma on Hacker News. Such posts will have a [flagged] tag and will not appear on the front page normally.
In this /active page, there are two posts pertaining to politics (without a direct tech angle) as user-flagged, as the Guidelines state that is off-topic.
Users with enough karma can "flag" posts and comments, which a) calls for moderator attention and b) decreases ranking. It's meant for off-topic/inflammatory/low-quality submissions.
People on Hacker News with a high enough score get a "super downvote" that can downrank a story, with enough removing it off the page entirely (flagged). It's why you won't see stories critical of Elon Musk or the current administration last for longer than an hour.
HN has had plenty of large frontpage threads fitting each of those descriptions. What we don't want is too much repetition. Otherwise the small handful of hottest topics on the internet would dominate everything else, and HN isn't that kind of site.
Speaking as the user you responded to in the first link: I’m sure you get flak from all corners, but I (and presumably many others like me) take zero issue with your philosophy or design goals for the site. I’m with you all the way when you say you don’t want to HN to turn into a current affairs site.
The problem IMO is the current sensitivity of the filtering. You said upstream that a high enough number of upvotes could outweigh flags — but that CECOT thread was one of the top 5-10 posts of the month despite having been taken down for many hours overnight. If that wasn’t a thread where the upvotes should be a strong enough signal to override the flags, I dunno what is.
We’re asking for subtle knob tuning, not revolution.
It seems like this post got killed as well, but it's the first I'm hearing of the functionality. I wouldn't say I'm a frequent user of the site, but I think I would have noticed if people were posting this link often.
As I've said in the past*, avoiding repetition is a core principle here and applies to every topic - especially when it's a repetitive+indignant combo. There's no political exemption.
And as I’ve said in the past, to you, no one’s buying it. It’s obvious to everyone that the same tech and biz topics can and do appear here ad nauseum.
Very high quality "Recommended repos for you" results, the top one was in fact a repo I was looking for a couple of days ago but did not successfully find.
I just wish I could scroll further down the "Similar to you" list.
I do something similar but it's iPhone SE plus olympus camera plus laptop. The laptop is where all the libre software lives, and the camera is (of course) for taking pictures with. I don't use the phone for anything except boring essentials, for the most part.
lol says you, its been my experience that reason.com does NOT post made-up stories, they simply have priorities aligned with their political biases which is relatively normal nowadays. AI agrees.
google:
"Reason.com is a reputable source that adheres to journalistic standards, but its content is filtered through a specific, consistent libertarian lens."
can you post the neonazi part? I couldn't find it. if you're uncomfortable posting actual nazi text, post the wordcount that precedes it in the article and I can count the words that precede your neonazi discovery.
I found https://github.com/chrislloyd/git-remote-sqlite as a way to achieve git-on-sqlite, which works by registering itself as a git "remote" helper.
Amusingly there exists a "Why SQLite Does Not Use Git" article (https://sqlite.org/whynotgit.html), but there is no corresponding "Why Git Does Not Use SQLite".
reply