Rygian

I would go with something like "Syntax error: pragma strict must appear before any table creation. " and consider that db file unusable.

125 KB of disk space on a diskette.

I use SI prefixes for bytes. You should too!

The prefix for 1000 is lowercase.

From now on, every time I see the word "anomaly" I will assume it is an euphemism for "someone stepped on it".

Why?

What internal drive moves you forward?

What sense of ownership/pride do you feel when you consider one of your works as "done"?

What would you do differently, if you were back at the starting block and had a budget of $800 to spend on writing nonfiction?

Not the author of the article, but I think you are overthinking the issue.

New database ⇒ use the proposed new magic PRAGMA, start with sane defaults.

Existing database ⇒ don't touch anything, keep legacy "suboptimal" defaults.

> The section "The solution: editions?" in the article addresses directly the point of existing data.

I'm sorry, where?

Here:

quote

[...]This should be a nice middle ground which avoids breaking backwards compatibility, but lets the database engine move forwards and not be bogged down by its own history.

end quote

Regarding busy_timeout, why is 5s specifically a better default?

According to the post we are discussing, any number greater than zero is better than the current default:

quote

The default behavior [no timeout] has lead me to writing real-world bugs, where systems would sometimes just crash. I've manually written retry loops to fix it.

end quote

Your forum links may be quite useful as a response to this comment: https://news.ycombinator.com/item?id=48928441

The section "The solution: editions?" in the article addresses directly the point of existing data.

The way I read it, this article does not advocate at any point to change the defaults for existing databases, but rather to start with better defaults for new databases.

Also, regarding the timeout of 5 seconds, I disagree with your premise "SQLite doesn't decide, which makes perfect sense". As the article explains, SQLite decides on the value zero (ie. instant error), which is arguably an inconvenient default.

There is a stark difference between gossiping to individuals vs to a multi billion dollar company whose business is to sell ads targeting you.

In Europe, the Cyber Resilience Act mandates the manufacturer to:

* Report any security breaches within 72 hours to a public body (country's CSIRT + ENISA).

* for "all products with digital elements [...] including those already placed on the market before 11 December 2027"

Products must be sold with a "secure by default" config, with automated security patching enabled by default (opt-out), with reporting on possible unauthorised access, with data collection minimization (tie-in to GDPR), with an SBOM, with dedicated security testing, with public disclosure of vulnerabilities, …

https://digital-strategy.ec.europa.eu/en/policies/cra-summar...

Their nuclear reactor goes away every night though.

It's way too late for alternatives now, unless regulation is created to break the monopoly.

"Google app auto-downloads to Google phones, can't be uninstalled" has been the norm since day 1 and before.

What is newsworthy here? The fact that yet one more third-party (the White House) does it too?

I don't like zoning codes because too often they are placing restrictions that restrict freedom for some value that isn't objective.

That might be a literal case of Chesterton's fence.

Humans have gotten real good at reproducing and staying alive despite external circumstances, up until their offspring can reproduce too.

So, individuals will reproduce.

With that perspective, how do you prevent scope creep when preparing a census exercise? You would collect everything and the shape of each house's kitchen sink, because "it can be useful".

The United States are listed as a secular state (ie. it "is or purports to be officially neutral in matters of religion")

Edit: As I research a bit further, I have stumbled upon an interesting counterargument [1] that enumeration of ethnicity and ethnic groups results in "more political discrimination and state-sponsored violence targeting ethnic groups". Perhaps a similar conclusion could be reached about religious census information.

[1] https://www.tandfonline.com/doi/full/10.1080/1369183X.2025.2...

"What is your religious affiliation" makes absolutely no sense in a census exercise. IMO.

I think the industry is optimizing for the wrong thing.

Indeed: The industry optimizes for speed, time to market, and features, and applies the ostrich model to everything that doesn't bring short-time revenue (security considerations, accessibility, vendor lock-in, interoperability, …)

This has been going on for as long as the industry exists, and now we start to have the proper tools to assess the damage and understand the brittleness of it all.

"Excuse me sir, would you mind carrying this extension that goes against your core business of selling ads?"

Publish it as a Firefox add-on instead.

Ads not only need to be relevant to me. They also have to be presented to me only when I am interested in the category of the advertised product or service. Otherwise they're just spam.

(Consider the typical "you just bought a new fridge, so let's show you ads of fridges".)

How long until a canvas is used to render the full chrome of a web browser (e.g. including the TLS padlock), showing a fake benign URL in the (fake) address bar while having the user interact with a malicious page?

we include it in our terms and condition and privacy page, but I don't think users truly grasp how those tools work

Since you did collect the metrics, you had direct knowledge of how many users opened the T&C and scrolled down to the place where you mention you're recording their session.

Would be interesting if you can share an aggregate statistic of that.

All the questions about sneeze are either about open air, or Newton's third law. Did really no one ask what happens if you sneeze while wearing a spacesuit helmet? Does the visor have a windshield wiper on the inside?

I'm glad we don't have exclusion zones like that one in France either.

You misread my comment.

If someone can deliver the same greater value to society using less electricity than you, they should be rewarded.

Punitive pricing is a great thing.

The less energy you spend to deliver value, the better for everyone.

As addressed in the article ("Choosing the right target"):

Pick the *highest-level* entry point that contains the bug

That's not prevention. That's remediation.

In my case, the site reports "The technique is called browser fingerprinting. It is legal everywhere."

It is definitely not legal in Europe, when used to track individual users. The consent pop-ups are not only about cookies.

I'll ask the obvious: wouldn't the aircraft just take to the skies directly, without bothering with the formality of setting their transponder, if they were knowingly escaping an apocalypse scenario?