HNHacker News
TopNewBestAskShowJobs

chasil

8,506 karma · joined December 20, 2016

Pride, wrath, sloth, lust, greed, envy, and gluttony. What opposes them?
submissionscomments
chasil··on Israel Has a "Silicon Shield"
If you find something that binds you inextricably with the global economy, then you have power.

Oil is not that thing.

The neon from Odessa and Mariopol was obviously not that thing.

The quartz from North Carolina appears to be an example of that thing. Not absolutely irreplaceable, but inconvenient in the extreme.

Is such a thing found in Iran? If so, that is an alternate path.

That can be people, instead of a raw material.

chasil··on Israel Has a "Silicon Shield"
I have lived with this violence all of my life. I was a fresh teen in the Carter hostage crisis.

I know Eisenhower's role in starting it:

https://en.wikipedia.org/wiki/1953_Iranian_coup_d'%C3%A9tat

There is nothing better that could happen to Iran than to manufacture critical products of such value that global fear of their loss gives them a shield as well.

This is entirely within their capability.

chasil··on Israel Has a "Silicon Shield"
Intel 7, 10nm technology (assuming DUV, not EUV) is the most advanced processing node in Israel.

Iran could step up, and join the silicon shield, by working to replace the lost neon production from Odessa and Mariopol.

That would be an interesting first step in stopping the violence.

chasil··on Frank Lloyd Wright’s first home
I believe that the Guggenheim museum in New York was completed postumusly. I've been there.

Like the Johnson Wax complex in Racine, there were regulatory objections to the design. For the Guggenheim, two fire exits were required per level, so how is this done with a spiral ascending gallery? For Johnson Wax, the "lily pad" column supports were tested to 10x the maximum rated weight. I have not been to Johnson Wax.

Wright did prove his designs durable in unexpected ways, several times.

chasil··on The Zilog Z80 has turned 50
Both the Z80 and the 6502 were products of corporate rejection.

I'd love to see another designer introduce a FORK86-64, but things are much more complex now.

chasil··on Frank Lloyd Wright’s first home
I thought the "move your chair" story concerned the Kauffmans of Falling Water, but it did not.

https://bpsfuelforthought.wordpress.com/2019/02/23/move-your...

chasil··on Frank Lloyd Wright’s first home
You are omitting the murders.

Wright ended his marriage and took Mamah Borthwick Cheney to Europe. This scandal ended his Chicago career.

https://en.wikipedia.org/wiki/Mamah_Borthwick

After bringing her to his Talesin estate in Wisonsin, she and her children perished in the events explained in the wiki.

This particular home is not itself stunning. The Dana Thomas house in Springfield, IL is far more impressive.

In Chicago, the Robie house is the must see, followed by Unity Temple, leaving the Home & Studio a distant third.

I have personally stayed at the Cheney house (twice), which was a bed & breakfast for a time.

chasil··on Lobste.rs is now running on SQLite
Some observations:

1. Stats are used by "Cost-Based Optimizers."

I think this is the most appropriate wiki:

https://en.wikipedia.org/wiki/Query_optimization

On my Oracle databases, I run the dbms_stats.gather_database_stats package procedure once a week. SQL Server also has stats for sure, and I would be surprised by a relational database that did not.

SQLite will quietly gather stats with each database connection. Running an explicit analyze devotes full attention to an otherwise piecemeal group effort.

2. I don't think rows are physically removed when deleted, instead they are marked. Removal will definitely happen at vacuum.

3. There is a backup command in the CLI that will make a transaction consistent copy of the database file, and there are lower-level C functions behind it that can be used with object code.

4. It is important to remember the many restrictions of WAL mode, including the impact on ATTACHing multiple database files: ACID consistency is lost.

https://sqlite.org/lang_attach.html

'Transactions involving multiple attached databases are atomic, assuming that the main database is not ":memory:" and the journal_mode is not WAL.'

chasil··on OnePlus halts operations in USA and Europe
I have a OnePlus 3t, a 5, and a Nord N200.

The last model was quite difficult to unlock and reload with LineageOS.

Had that not been the case, this announcement may not have been necessary.

chasil··on S&P Global has lowered Oracle’s creditworthiness from BBB to BBB-
And they terminated 30k employees to achieve this?

https://www.forbes.com/sites/jonmarkman/2026/04/06/oracles-m...

chasil··on A tiny cell that broke a big rule of biology
The plastid wiki might be germane.

https://en.wikipedia.org/wiki/Plastid

Edit: "It was a type of algae called Braarudosphaera bigelowii. Hagino fondly just calls it Bigelowii."

Is this pronounced bigggie-lowie?

chasil··on The shingles vaccine may reduce the risk of dementia
Do I care?
chasil··on Berkshire's $397B Bet Against an Overheated Market
I have read another article recently indicating that the S&P 500 is overvalued compared to international indexes.

I may soon increase my 401k share of VTIAX.

https://www.telegraph.co.uk/money/investing/stocks-shares/go...

chasil··on The shingles vaccine may reduce the risk of dementia
Not to the union, it's not.

'The plaintiffs alleged that the vaccines do not prevent someone from becoming infected with COVID-19 and characterized it as a treatment rather than a “traditional vaccine.”'

https://calmatters.org/education/2024/06/covid-vaccine-manda...

chasil··on Prefer strict tables in SQLite
For the searched column only?

If you are greatly concerned, SQL Server and the Sybase database from which it emerged have a native boolean data type.

Another benefit of this scheme is that adding another boolean means using the next power of 2 in the existing integer, assuming room remains. No new column necessary.

chasil··on The shingles vaccine may reduce the risk of dementia
From a legal perspective, if the injection does not provide 100% immunity (when used as directed), then it cannot be called a vaccine, instead it is a therapeutic treatment.

Because courts of law have recognized covid mRNA injections as therapeutic treatments, they cannot be mandated.

chasil··on The shingles vaccine may reduce the risk of dementia
Your thymus shuts down in your 80s, and you will make no more new T cells.

I also understand that a third of the elderly will have shingles by their 80s if unvaccinated.

chasil··on The shingles vaccine may reduce the risk of dementia
As I understand it, antibodies only last a month within the blood before they degrade.

It is the memory B cells that produce them that last years.

https://en.wikipedia.org/wiki/Memory_B_cell

https://www.quora.com/What-is-the-lifespan-of-an-antibody-in...

chasil··on Prefer strict tables in SQLite
The largest table where I've done this had over 50 of these booleans.

That's one 64-bit number, or 50 different columns.

chasil··on Why are US consumers so angry? It's not just high prices
This decade began with a pandemic. Its origins and impact can be debated, but it did enormous and lasting harm, unreasonably.

The last presidential election disenfranchised a party (and with it half the country), suppressing turnout. Half of this country had no say in their nominee, by design.

Then A.I. was predicted to end white collar employment.

And now we are at war, with threats to security and economic stability that are unpredictable.

Nobody wanted any of this. Such is the sentiment of our decade.

chasil··on Prefer strict tables in SQLite
When you need many booleans on a table, use an integer with bitwise and/or to record them as powers of 2.

I have done this many times. Function-based indexes are necessary if they must be searched.

chasil··on The Clouds of Hiroshima
Interesting, I did not know that the Soviets declared war against Japan between the Hiroshima and Nagasaki detonations.
chasil··on The Clouds of Hiroshima
Russia invaded and occupied the Sakhalin islands near the end of World War II. Native Japanese were allowed to leave, as I understand it.

"Japan invaded the northern parts of Sakhalin, and ruled the entire island from 1918 to 1925. Russia has held all of the island since seizing the Japanese portion in the final days of World War II in 1945, as well as all of the Kurils."

https://en.wikipedia.org/wiki/Sakhalin

chasil··on Spider venom kills varroa mites without harming honeybees
Powdered sugar is the standard treatment for removing varroa mites that have emerged from capped cells.

"The peptides killed only the mites, while the bees survived."

What benefits do these new treatments offer? They certainly won't be cheaper.

https://www.honeybeesuite.com/can-powdered-sugar-control-var...

Edit: "Treatments every week killed more mites than treatments every two weeks, which killed more mites than treatments every month... The only treatment schedule that effectively suppressed mites over long periods was once per week... sugar dusting has been found to significantly reduce adult mite populations at times when little brood is present."

chasil··on Delta flight hit by firework while landing at Midway Airport on Fourth of July
It would be more practical if major cities had "fireworks zones" with ambulances on call and perhaps some safety advice.
chasil··on Giant trees have no trouble pumping water to top branches: new research
Kurzgesagt has two videos on trees addressing this and other questions.

https://m.youtube.com/watch?v=ZSch_NgZpQs

https://m.youtube.com/watch?v=pHJIhxZEoxg

chasil··on The Radiation Exposure Lie
I remember someone from the Manhattan Project that suffered the same fate. Is that "commercial nuclear history?"

This article on Douglas Crofut [died 1981] implies that there were several.

"His death was the first of its kind in the United States since the 1940s, when radiation deaths occurred during the Manhattan Project at Los Alamos, New Mexico."

https://en.wikipedia.org/wiki/Douglas_Crofut

It turns out that there were two Manhattan Project fatalities, one in 1945, and one in 1946.

https://en.wikipedia.org/wiki/Harry_Daghlian

https://en.wikipedia.org/wiki/Louis_Slotin

chasil··on POSIX Is Not a Shell
This has some information on the 2020 failure, but it is not what I remember reading.

https://www.reddit.com/r/openbsd/comments/jvbj4s/a_new_appro...

There were core performance problems in the 2020 effort.

chasil··on POSIX Is Not a Shell
The big problem with ksh93 is that it is not maintained.

After David Korn retired, an attempt was made to bring out a new version which failed dramatically, and AT&T reverted to Korn's final release.

SmartOS uses ksh93 as root's shell.

chasil··on POSIX Is Not a Shell
The POSIX commentary mentions the Korn shell ten times, including particular behavior of the 1988 ksh release. Bash is not mentioned.

It is easier to understand the POSIX standard with a ksh focus, particularly ksh88.

https://pubs.opengroup.org/onlinepubs/9699919799/utilities/V...

← PreviousPage 4 of 34Next →