Readit News logoReadit News
throw0101b commented on PSA: SQLite WAL checksums fail silently and may lose data   avi.im/blag/2025/sqlite-w... · Posted by u/avinassh
ezekiel68 · 5 months ago
You know what's even easier than doing that? Neglecting to do it or meaning to do it then getting pulled in to some meeting (or other important distraction) and then imagining you did it.
throw0101b · 5 months ago
> Neglecting to do it or meaning to do it then getting pulled in to some meeting (or other important distraction) and then imagining you did it.

If your job is to make sure your file system and your database—SQLite, Pg, My/MariDB, etc—are tuned together, and you don't tune it, then you should be called into a meeting. Or at least the no-fault RCA should bring up remediation methods to make sure it's part of the SOP so that it won't happen again.

The alternative the GP suggests is using Btrfs, which I find even more irresponsible than your non-tuning situation. (Heck, if someone on my sysadmin team suggested we start using Btrfs for anything I would think they were going senile.)

throw0101b commented on AMD CEO sees chips from TSMC's US plant costing 5%-20% more   bloomberg.com/news/articl... · Posted by u/mfiguiere
benreesman · 5 months ago
Intel is a great example of the fact that between stupidity and low-integrity behavior as a default, the people in charge fuck up in ways that the man on the street would get right.

Defense is starting to get a blank check with fairly bipartisan support for the first time in at least 30-40 years and it's centered on semiconductor supply chains. There has never been a better time to secure the fucking funding, have ASML send twice as many people as they already have, and power through it. The market is whatever you want and the margins are whatever you want: in a functioning system? You fucking do it.

And while I will believe that Intel has suffered serious attrition in key posts, there's no way that the meta-knowledge of how to debug "we don't have the fabs running right, who do we hire, what so we need to give them to get it done" has evaporated in 5-10 years from the singular source of this institutional muscle memory in the history of the world.

The failing here is more like a failing in courage, or stamina, grit, something. It's a failure of the will to do the right thing for both the shareholders and the country.

throw0101b · 5 months ago
> Defense is starting to get a blank check with fairly bipartisan support for the first time in at least 30-40 years and it's centered on semiconductor supply chains.

Really? Because:

> During Donald Trump's 2025 speech to a joint session of Congress, the president asked House Speaker Mike Johnson to “get rid” of the subject act.[190]

* https://en.wikipedia.org/wiki/CHIPS_and_Science_Act#Subseque...

throw0101b commented on PSA: SQLite WAL checksums fail silently and may lose data   avi.im/blag/2025/sqlite-w... · Posted by u/avinassh
zaarn · 5 months ago
ZFS isn’t viable for SQLite unless you turn off fsync’s in ZFS, because otherwise you will have the same experience I had for years; SQLite may randomly hang for up to a few minutes with no visible cause, if there isn’t sufficient write txg’s to fill up in the background. If your app depends on SQLite, it’ll randomly die.

Btrfs is a better choice for sqlite, haven’t seen that issue there.

throw0101b · 5 months ago
> ZFS isn’t viable for SQLite unless you turn off fsync’s in ZFS

Which you can do on a per dataset ('directory') basis very easily:

    zfs set sync=disabled mydata/mydb001
* https://openzfs.github.io/openzfs-docs/man/master/7/zfsprops...

Meanwhile all the rest of your pools / datasets can keep the default POSIX behaviour.

throw0101b commented on PSA: SQLite WAL checksums fail silently and may lose data   avi.im/blag/2025/sqlite-w... · Posted by u/avinassh
zaarn · 5 months ago
SQLite on ZFS needs the Fsync behaviour to be off, otherwise SQLite will randomly hang the application as the fsync will wait for the txg to commit. This can take a minute or two, in my experience.

Btrfs is a better choice for SQLite.

throw0101b · 5 months ago
> SQLite on ZFS needs the Fsync behaviour to be off […]

    zfs set sync=disabled mydata/mydb001
* https://openzfs.github.io/openzfs-docs/man/master/7/zfsprops...

throw0101b commented on BGP.Tools: Browse the Internet Ecosystem   bgp.tools/... · Posted by u/RGBCube
globular-toast · 5 months ago
Not sure why you'd need more than 10/8, but I suppose it looks even cooler too those who know and find such things cool.

Does Windoze prevent you from using certain IPv4 addresses?

throw0101b · 5 months ago
> Not sure why you'd need more than 10/8

Large organizations have moved to IPv6 because they, and everyone else, are using 10/8, and so when mergers and acquisitions happen trying to connect the networks together becomes a nightmare.

See this talk from Wells Fargo as an example:

* https://www.youtube.com/watch?v=EzTWjNUb4H4

throw0101b commented on AccuWeather to discontinue free access to Core Weather API   developer.accuweather.com... · Posted by u/TerribleTurnout
lelandfe · 5 months ago
Also talked about in Michael Lewis’s book Fifth Risk.
throw0101b · 5 months ago
> Also talked about in Michael Lewis’s book Fifth Risk.

Highly recommend that book. Haven't gotten to his most recent Who Is Government?:

* https://www.penguinrandomhouse.ca/books/788713/who-is-govern...

But from the interviews it sounds interesting as well. Colbert interview from April 2025:

* https://www.youtube.com/watch?v=T30BF32qPgg

throw0101b commented on AccuWeather to discontinue free access to Core Weather API   developer.accuweather.com... · Posted by u/TerribleTurnout
exe34 · 5 months ago
> “These form a colossal operation that has become one of the main drivers of the climate change alarm industry and, as such, is harmful to future U.S. prosperity,” Project 2025 says. “This industry’s mission emphasis on prediction and management seems designed around the fatal conceit of planning for the unplannable.”

Shoot the messenger and bury your head in the sand!

throw0101b · 5 months ago
Yeah:

> "The Pentagon ... announced that we are eliminating woke climate change programs and initiatives inconsistent with our core warfighting mission," [Chief Pentagon Spokesman Sean Parnell] said.

* https://www.defense.gov/News/News-Stories/Article/Article/41...

See also "Pentagon Starts Purging Climate Change Measures":

* https://www.scientificamerican.com/article/trump-pentagon-pu...

But from 2021 (during Biden), "Climate change is a risk to national security, the Pentagon says"

* https://www.npr.org/2021/10/26/1049222045/the-pentagon-says-...

throw0101b commented on US AI Action Plan   ai.gov/action-plan... · Posted by u/joelburget
msgodel · 5 months ago
>Removing Red Tape and Onerous Regulation

What red tape? Anyone can buy/rent a GPU(s) and train stuff.

throw0101b · 5 months ago
> What red tape? Anyone can buy/rent a GPU(s) and train stuff.

Well previously the Chinese were not able to, but that was changed recently:

* https://www.wsj.com/tech/nvidia-wins-ok-to-resume-sales-of-a...

* https://foreignpolicy.com/2025/07/22/nvidia-chip-deal-us-chi...

u/throw0101b

KarmaCake day4400January 1, 2023View Original