pull down to refresh
@chaoticalHeavy
132,647 sats stacked
stacking since: #108260longest cowboy streak: 59npub1g8g2w...c5fqmmk7um
The open question, then, is not whether industrial software will dominate, but what that dominance does to the surrounding ecosystem. Previous industrial revolutions externalised their costs onto environments that seemed infinite until they weren't. Software ecosystems are no different: dependency chains, maintenance burdens, security surfaces that compound as output scales. Technical debt is the pollution of the digital world, invisible until it chokes the systems that depend on it. In an era of mass automation, we may find that the hardest problem is not production, but stewardship. Who maintains the software that no one owns?
TL;DR
The progression is predictable. Start with a flat directory of files. Hit filesystem limits. Implement sharding. Hit cross-platform issues. Build server-side enforcement. Build custom indexes. Eventually give up and use HTTP or an actual database. You’ve built a worse version of what databases already provide, spread across git hooks, CI pipelines, and bespoke tooling.
None of this means git is bad. Git excels at what it was designed for: distributed collaboration on source code, with branching, merging, and offline work. The problem is using it for something else entirely. Package registries need fast point queries for metadata. Git gives you a full-document sync protocol when you need a key-value lookup.
Explosives in the microphone bring back memories of exploding pagers and walkie talkies.
He pissed off Israel.
This caught my attention:
Imagine a world where your “checking account” is actually a high-yield instrument backed by over-collateralized loans against Bitcoin. You are spending stable currency, but the backing is hard money.
I guess the stable currency would be the bank's digital dollar mentioned earlier.
If a bank can issue a digital dollar that is over-collateralized by Bitcoin, that digital dollar is “harder” and safer than a digital dollar backed by fractional reserve fiat lending.
So true
that delicate balance where structure meets freedom. And perhaps that’s where the worlds of hackers and painters quietly meet, each shaping their medium until form and motion become one.
That precise balance is the true art of code.
I like this
5. Need a New Query Pattern Later?5. Need a New Query Pattern Later?
I believe this is one of the strongest points to this pattern. If at a later date your JSON shape changes (expected), you can just add another column and create another index.
For example, you realise you need to query by user_id:
SQL
ALTER TABLE events
ADD COLUMN user_id INTEGER
GENERATED ALWAYS AS (json_extract(data, '$.user.id')) VIRTUAL;
CREATE INDEX idx_events_user_id ON events(user_id);
The vast majority of chronic disease isn’t caused by our genes. “The Human Genome Project was a $3 billion investment, and what did we find out?” says Thomas Hartung, a toxicologist at Johns Hopkins. “Five percent of all disease is purely genetic. Less than 40 percent of diseases even have a genetic component.”
I happen to be in Wild West mode so I am seeing this bullshit.
The price just went back to what it was a day or two ago.
I agree getting paid in BTC is best.
But the people that are paying you really do know their customers, so that's also something to think about.