skysight-inc/HackerNews huggingface dataset:
Past related threads. I feel like there must have been something else since 2016?

How SQLite Is Tested - https://news.ycombinator.com/item?id=11936435 - June 2016 (57 comments)

How SQLite Is Tested - https://news.ycombinator.com/item?id=9737754 - June 2015 (1 comment)

How SQLite Is Tested - https://news.ycombinator.com/item?id=9095836 - Feb 2015 (17 comments)

How SQLite is tested - https://news.ycombinator.com/item?id=6815321 - Nov 2013 (37 comments)

How SQLite is tested - https://news.ycombinator.com/item?id=4799878 - Nov 2012 (6 comments)

How SQLite is tested - https://news.ycombinator.com/item?id=4616548 - Oct 2012 (40 comments)

How SQLite Is Tested - https://news.ycombinator.com/item?id=633151 - May 2009 (28 comments)
Zig is a really exciting language to see grow.

As a minor correction to your post: C99's flexible arrays are stack-allocated, not heap-allocated. Since stacks are often small, this feature actually wound up causing a bunch of designers to hit stack overflows. It was downgraded to an optional extension in C11.
"Scrumfall" sounds like a rejected James Bond movie script.
So I'm a little confused. How is Facebook responsible for some thing a government did? Or is this just because they can't do anything to the government without invading.
What would stop them from trashing me as a new employer?

Not giving people loads and loads of things to feel bitter about. And an eggshell-strewn environment where it's basically impossible to air these concerns with anyone upstream.

It's really quite simple, actually.
I think the word “protection” implies there’s some reason to be protected.
Access for all, a balanced ecosystem, and powerful tools
It seems like one thing is that Postgres has two types for JSON: JSON and JSONB.

Both validate syntax on insert. The JSONB datatype (not JSON; note the B on the end) further stores the content in a parsed, binary form so future accesses are faster. The schema author does not have to indicate which columns they would like "fast" access to - queries are free to access any arbitrary path in the JSON, and will get reads that don't require JSON parsing.

It seems like SQLite can achieve something similar but not quite the same. It looks like the user has to specifically enumerate and materialize the columns to which they want fast access.

So it seems like json_extract(...) is comparable to Postgres's JSON type, but there's not quite an analagous thing for Postgres's JSONB type.
The Master and Margarita, Burgin/O'Connor translation
This just indicates a failure to perform a proper Analysis/Specification/Requirements phase

No, we're suggesting the analysis/specification phase should be comprised of what are, effectively, many really small waterfalls. And that any effort to obtain specs for an entire system without first building some minimal version of the system is doomed to failure.

For a small enough feature, yes, you end up doing waterfall. The problem is breaking up a massive system into those small enough pieces.
At this point the lack of any Easter Eggs almost IS the hidden feature. I would not have expected this much discussion and controversy, it causes more surprise than an actual egg in the app would!
> Sure, and then how long do we leave troops there for? another 20 years and then we leave and everything goes back to the way it was?

1 option. Just destroy fixed assets, and most armour. US can do it in a few months of logistical preparations, and 1 week high intensity campaign.

2 option. Yes, but now build proper military hardpoint bases, and a proper government
Excellent write up.

One question. The part where GPT-3 generates a story for you is still a manual process, right? You edit the text afterwards to make sure it isn't nonsense and there aren't any repeating sentences?
Ask HN: Is it smart to put your personal info on a Google form?
I'm curious. Is it safe to do a registration though google forms for a small-time club which has legit professional reasons to gather your personal information. I know I can contact them directly and ask for alternatives. I am sure this would be a hassle for them. Yet it's putting all my credentials out on somebody's else's account. I don't know even if the information will be encrypted. The alternative would be emailing them directly and that's the same thing?
Google Trends Analysis: How Our Interests Changed During the Pandemic
Chaos by James Gleick

The Master and Margarita by Mikhail Bulgakov
At least in the US, environmental activism has contributed to lack of geothermal development. While the US has large regions with high geothermal potential, such as the Great Basin area of the mountain West, much of this land is undeveloped and under Federal control. This allows activists anywhere in the country to make getting permission difficult and expensive, the effect of which has been to limit the practical size of the power plants to ~25 MW.

Large-scale geothermal installations are not pretty and they cover large areas of land. The individual bore holes must be widely separated from each other, so if you are aggregating the energy of many bores, you are building giant pipe networks. It looks a bit like a large oil field. This gets attacked by environmental activists as despoiling the natural habitat/beauty etc of the formerly undeveloped land. In places like Nevada, which has a lot of geothermal power, there is nothing attractive or unique about this land, it is essentially volcanic badlands of the boring variety, but the campaigns against them use deceptive pictures from other parts of the country suggesting that they are paving over national parks and similar.

This propaganda against geothermal power generation makes it impractical at scale. Instead, the geothermal power plants that are practical to build in this regulatory environment are all solutions with small land footprints. The largest geothermal power plant in Nevada is <100 MW and most don't even do 20 MW.

Of course, there are similar challenges when trying to install solar power at scale in the same kinds of places. Too much of our "green energy" policy is dictated by activists that don't want to build any kind of power generation anywhere.
That's right, as interesting as crypto currency may be it doesn't solve the customer fuck up problem in a way that the masses would tolerate.
YouTube reveals millions of videos get hit with incorrect copyright claims
For what its worth, I've known about endmyopia for some time as well. Snellen chart is how you can verify things for yourself, you can only lie to yourself so much. I've improved my eyesight as well but nowhere near as much as Aulig has (roughly an improvement of 1.5 diopters over 3 years). I'm also much older, mid 30's, so that might be a factor in rate of improvement. I can't even see out of the glasses that I had before I started, so I know its definitely improved.
I've seen this and rebooting my Temtop sensor seems to help, sometimes.
Another reminder that you can get the "mobile" version for Wikipedia on desktop. Just add ”?useskin=minerva" (sans double quotes) to the end of the URL. Since my browser can't have extensions, I did a dirty userscript for doing that with JavaScript.
I wasn't primarily concerned with Windows portability, but with the portability of scripts altogether, and no longer having to concern oneself with variations in coreutils versions for at least some scripts, even if they run on multiple platforms.

But to answer your question about Windows:

Because requiring an emulation layer is a huge step up in complexity from being able to distribute your shell as a single static binary which is just a few MB. Right now Elvish and Nushell, for example, can be deployed on Windows as binaries that don't require any external dependencies, any installation procedure, or any configuration. If they could link against uutils statically, they could also come with basic utilities without having an environment to manage.

WSL (along with MSYS2 and Cygwin) is deeply stateful. Now to make sure everything is working you have to check the compatibility of your whole system, and the versions of coreutils can still vary in addition to the version of the shell interpreter.

WSL2 also requires virtualization, which can complicate using it under virtual machines.

You may not want everything you run under your shell to depend on WSL, which is also happens with WSL2.

Even with WSL1, a script that requires a chroot environment to deploy and run it is way less portable than one that doesn't.
Can you make a chrome extension that does the reverse of this? Make "modern" webpages on rest of the web look like wikipeidia?
This is interesting - provoking. Can you share some authors/material that has influenced your awakening, so to speak?
You want Chordify, then. It uses YouTube instead of Spotify but does a pretty good job of finding chords.

https://chordify.net/
Nope, finally found it in the USB-C spec, section 4.6.2, covering cables: "USB Power Delivery in Standard Power Range (SPR) operation is intended to work over un- modified USB Type-C to USB Type-C cables, therefore any USB Type-C cable assembly that incorporates electrical components or electronics shall ensure that it tolerate, or be protected from, a VBUS voltage of 21 V."

This comes after a table that would seem to indicate USB-C as a whole supports a minimum of 7.5W, but then this cable-specific section expands that. However, it notes that it must tolerate or be protected from, which in this context I gather means "must pass power through."
I was thinking of buying some Tile to put on my keychain, laptop bag, etc but now that it belongs to Life360 I scratched that off my list..
Show HN: Podcast Audiograms – Make clips with captions, title and audio waves
> That in no way backs up your claim. 1) That was 10 years ago

What does "ten years ago" have to do with it? The original claim said nothing about when it was said; you're the only one who brought that up.
They have a lot of fans, of the type of people that haunt HN.

High quality project that is useful for for small hobbyist projects, startups and large companies alike. Persisting data something that is used in probably the majority of software projects across many verticals. It is OSS software that is easy to pick up. It is a values driven project (both technical and ethical). And the team maintaining it has kept it going for a long time, so as it get rediscovered by others it still has relevancy for many.

Basically it is good software, with a wide TAM, and just enough quirks to appeal to the folks here.
I learned of "Corporation Doe" through the epstein private suits.
Huenit – AI camera and modular robot arm
Oh dang, yeah. An extension that makes the whole web look and work like the default Mediawiki skin would be glorious. And _fast_.

I miss windows having borders. Just dug up a registry hack (obscene that such a thing was needed) to force win10 to have window borders again, because I keep ending up in situations where I honestly couldn't tell where one ends and the other begins.

They spent decades researching and building interfaces with visual cues, and we spent decades tuning our reflexes to them. Then some whim of fashion decided that hiding all those cues was "smoother", and I want to choke someone.
That is not how this works. First off prices increasing is the result of inflation not inflation itself. Inflation is an increase in money supply. Wages increasing is part of the process of inflation working its way through the economy.

Increasing the number of dollars floating around does not give more tax headroom. Taxes are strictly a percentage of the quantity of dollars pie. Making the pie bigger means everybody gets a bigger piece and everything increases in cost to match. Wages that do not increase result in the earner getting a smaller piece of the pie. So, the cost of labor increases as people refuse to work for an amount that doesn't pay the bills anymore. But, the percentage of the slices are exactly the same after the lag period of 12-18 months. The lag period is how long it takes an increase in money supply(inflation) to be reflected in the markets of goods and labor.

https://www.johnlocke.org/the-myth-of-wage-push-inflation/

https://www.lancaster.ac.uk/staff/ecajt/inflation%20lags%20m...
one of the worst things about the current WP GUI is that when you hover over a hyperlinked word with the expectation that your anxious yearning for the definition of that word be fulfilled you're often forced to click through to the actual page, because the popup lacks a concise enough representation of that word, because the definition could not be contained within that small a space, or, the definition of the word succeeds some initial ramblings about the origins of the word, or of its inventors, which does not lead to me understanding the word and makes my WP deep dives less pleasurable.

I want WP to solve this with NLP.
You don't need to use any particular server to publish to this ecosystem. You don't even need to use the Mastodon software. Just hook up the AP plugin to your WordPress (or insert necessary logic into your CMS of choice) and you're a participant.
Wonder how China feels about Amazon growing as a vital link to markets globally or atleast to the US.
Plenty of companies have been sued and paid out claims for their use of forced Jewish labor and other wrongs during WW2.
This makes sense in a weird way.

The spammers have full time jobs figuring out Google's algorithm and how to manipulate it. Regular content creators don't, so they tend to get clobbered by the algorithm.

As Google continues to tighten the algorithm to fight spam, eventually the only users who will be able to post are the spammers.
What goes wrong at those branches, then? Are the supervisors prevented from making drastic changes?
There isn't enough liquidity in those markets to make enough profit to create a regulatory change. If it was easy to misprice used cars and make millions of dollars the FTC would want to do something about it and thats ok. We live in a society and its important that we have trust in the rules.
McLuhan speaks in exaggerated language - it's important to not take everything he says too literally, and to instead judge the essence of the ideas.

"The Medium is the Message" because without context (the media), messages are just noise. McLuhan was all about seeing the contexts we live in, how they shape our reality, etc.
UltimateGuitar is so pushy with their ads and subscriptions, it's a crime.

Neat shortcut though. Thanks for the effort.
Call for participation: Testing and Automation devroom, FOSDEM'22
The power and the glory by Graham Greene. Crime and punishment by Dostoevsky.
> Fundamentally, that means everything must either specialize and focus on a niche set of customers or it becomes driven by the tragedy of the commons.

Very true. Increasingly I get the sense that almost every piece of consumer software I use is not really as concerned with what I want vs other, much larger demographics.

That's fine, but it is a bitter pill to swallow after feeling "at home" in technology for a long time.
Okay that's embarassing. Serves me right for just skimming his article. Thanks for the correction, edited my post.
“You are TOO DAMN SLOW. You are a bunch of DUMB DOLPHINS and…DUMB DOLPHINS get caught in nets and eaten by sharks. SO STOP IT. STOP IT. STOP IT RIGHT NOW. YOU ARE EMBARRASSING ME.”

That last part, “you are embarrassing me,” suggests an element of narcissism. It personalizes the feedback, something every leader should avoid doing.

Also, all caps suggests shouting, which suggests a lack of emotional control, something leaders sometimes pretend to do strategically, but a good leader never does this accidentally. (I give an example here: https://demodexio.substack.com/p/the-hearts-of-men-american-... )

Good feedback is specific and individual. What Gary said, in this example, is almost scientific in how precisely bad it is. He is emotional and non-specific. If a worker has made a good-faith effort and failed, this kind of ranting doesn’t help the worker, and if the worker is operating in bad-faith, then you’ve encouraged them to continue because you are shouting at the room rather than singling them out, a fact which convinces them you don’t know which workers are operating in bad-faith.
Technically, you'll need to go to court to get a canonical answer. Without a court ruling, it's just expert opinions.
I think there is a trend of everything being geared towards new users (i.e. growth) - as soon as you become a user, you're less important. For instance, I noticed in many websites, 'Sign-up' is always featured more prominently than 'Sign-in' button. It feels like UI changes to be geared towards new users who are used to the UX 'flavour-of-the month', lowering the initial learning curve as much as possible even though it will confuse existing (captive?) user base.

The unfortunate side-effect of this is that users will never become proficient in the software tools, with 'power-users' being a thing of the past. As an example, I think MS Office peaked for me probably around 2010 in terms of features and my proficiency and now I'm actually regressing. If I want to export a PDF of the file, I can't remember if I should go to 'File -> Print', 'File -> Export', or 'File -> Share', because it keeps changing.
Actually, what happens is a channel you were subscribed to, or one which you have consumed enough content from to influence the YT algorithm.... has been compromised, taken over, the password was discovered by crypto miners.

They take over the channel, change a bunch of settings, etc... then start spewing out the usual Space-X live stream crypto-mining pyramid-scam. Sometimes if you look at the channel hosting the live-stream, you can sometimes still see clues to the old channel you were subscribed. You have to audit through the videos and playlists, old comments, etc...
I feel the same way and am not even 40. It's too much swirl for BS "features". It's like there's a rush to deliver deliver deliver without actually looking at client impact and value.

On a related note, I'm tired of filling "stretch" roles (more than one role at a time) and being required to work in multiple stacks. Just let me be full stack in only one stack, please.
This is one of those things that seems to be an institutional part of Americans quitting or being fired from jobs, but it's far from universal.

In Germany (and I believe most of Europe) several months notice is usual (three months minimum), and typically people keep working until the end of that time (aside from taking unused vacation). Sure, motivation suffers in that time, but don't think the cases of employees taking revenge on their employers is any higher here than in the US (in fact, I suspect it's less).
Will someone do the same against Twitter for the Arab springs which lead to the rise of ISIS?
Really? How long was it between first complaint and resolution, and how does that compare to cases where the victim didn't get social media outrage on their site? (Honest question, I know this sucks and don't want to trivialize it, just not sure if this is proof of needing to appeal to social media.)
I recommend the book Cheap: The High Cost of Discount Culture. The author talks about how the market for consumer goods has been bifurcated into insanely cheap and stupid expensive.
Facebook doesn't show content chronologically. Their algorithm decides what people see. They may not have purposefully pushed pro genocide content, but that doesn't mean they aren't liable if the court finds they were negligent in building the algorithm.
The sooner people realize that agile and scrum are sales pitches with little substance the better off everyone will be.
It's funny how people recommend Master and Margarita, I found it unbearably difficult to read. The constant jumps between story lines (if I recall correctly) threw me off. Would absolutely avoid, but YMMV.
> Generally speaking, HN is pretty much one sided with Postgres Vs MySQL.

The community here is very pragmatic, and often is speaking through the lens of personal experience. More so than many other communities.

> And Oracle ( MySQL ) is evil.

I think they get about the right level of skepticism with respect to motive that every big tech player gets. MySQL has a complicated story, but honestly, it's a great product.

> But at least not as one sided as usual.

I really enjoy HN because over the years, I've found the community to be pragmatic. There are always responses that tend to favor dogma over practicality, but on the whole, the community really is great about sharing insight and opinion.
Most of the people annoyed with PostgreSQL in these comments are annoyed because it feels like you have to write your own replication and connection management

Most of the people annoyed with MySQL in these comments are annoyed because it feels like you have to write your own optimiser

Welcome to software, I guess :D
It's a sign the field is running out of ideas.
Ask HN: Switching Teams Internally?
Hi there, has anybody here switched teams internally and had a positive/negative experience they would like to share?

I recently decided to switch, today I told my (current) boss. He expressly asked me to stay with this team and told me he already had plans in place to solve the problems I raised. Now I'm not sure what to do. Do I cancel the transfer and believe him? I realize only I can make the decision for myself, but I am really torn.

I do love the team I'm on _except_ for one particularly toxic coworker who seems to have it out for me. I have stuck it out two years with this guy and had direct conversations, nothing has gotten any better. My boss explicitly told me he'd rather fire the other guy than lose me but I just don't want this other guy to lose his job because I can't deal with his toxicity. Everybody else on the team agrees he is unprofessional and rude, but also kind of shrugs their shoulders and have the "its a job" type attitude whereas I think life's too short to work with people that make you feel small.

Stories and advice of all kinds are welcome.

Thanks!
By what mechanism does this "killing off" take place?
In that case, you might wish to know that putting a smile at the end of a comment like that is also a common way of calling the person you're talking to stupid.
> nowhere near to the level it should be.

I get the impression that it's used exactly as it should be, in systems that need a database but don't need clustering or failover strategies.
Evidence for the “great resignation” is thin on the ground
And it would become more profitable without it
You are 100% productive for 8 hours a day?
I think I know some people where this question:

> Why did feature X fail?

Would garner this response:

> Because the universe is deterministic and the fact that this feature would exist and disappoint was determined 13 billion years ago. It really couldn't have gone any other way.
Stop using low contrast gray text. I can barely read it. Real designers use different weights, not colors.
In SQlite's source code, it has the following comment.

2001 September 15

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.

SQLite is _the_ most amazing database in my opinion. (Not the most amazing distributed database for obvious reasons). It strips away all the connect and network IO management, and focuses on the actual database. It's _the_ most deployed and used database in the world (it's even running outside of the Earth). Because of its wide distribution, it has to be very well tested. It's much harder to fix a bug on client (comparing to on server).

Dr. Hipp is amazing. I wish more people are like him.