skysight-inc/HackerNews huggingface dataset:
There is a good chance this is the article the author mentioned reading: https://kerkour.com/sqlite-for-servers
Artificial gravity can easily be created through centrifugal force.
Your comment is quite extraordinary as Orwell's work dealt with an unthinking bureaucracy resembling the Soviet Union. He also had the foresight to see the U.K. could be a totalitarian state.

An honest assessment of the revelations of USAID spending and its funding of literally thousands of media companies via direct grants or voluntary purchases would suggest the information environment surrounding this is not entirely benign. And it would suggest that reasonable people can also dispute the pure intentions of a system that makes it almost entirely impossible to fire people, and was started as a soft power system for US foreign policy.
My theory is that (in current society) this starts with spreading money. That's not trivial either but it feels at least a bit more tangible to me.
The All-Electric Household: A Data-Driven Analysis of Costs and Savings
The short term gains are things like $TRUMP bringing in a huge amount of money for insiders. The long term gains are things like firing the FEC, enabling erosion of voter rights.

The supporters aren't really in this for the money, they're in it for the blood. I don't know if that will change once some crisis forces gas prices up.
Not a surprise to him, he doesn't care.

It's a mistake to treat people with mental disorders as having an internally consistent view of the world. Or as actually believing what they say.

They are paperclip optimizers, this one optimizing for worship and power. In other words he has the antagonistic and communal subtypes: https://www.verywellhealth.com/narcissistic-personality-diso...
Yep, slow down enough so that you don't sweat and can breathe 100% through your nose. At first you'll be very slow but if you keep on going weeks after week you'll slowly get faster. A big part of it is mental too, if you're in relatively good shape even as a complete beginner your body shouldn't complain too much for at least an hour, if you're experienced you should be able to sustain that for hours

That's what I do as an amateur but then again I have no running watch, I run in $15 shoes, I don't care about PR, distance, &c. all I care about is slowly and safely building cardiovascular endurance
Damage to public / private property is normal in a riot, that's where riot police comes in - who are, on paper, experts in nonviolent / nonlethal crowd control and de-escalation. Deploying the National Guard would have been an unnecessary escalation.

I do wish either riot police or the National Guard was deployed on Jan 6th though. But neither Trump nor anyone in the chain of command with that authority did, which only emphasizes how it was orchestrated and intentional.
> Settlers has war as well but I always felt it was secondary, definitely not something large scale.

Yes. This is the main reason why I always preferred Settlers and the Anno titles to AoE, EE or similar games. You could build things. AoE was mainly about destroying things. "Warfare" in the original Settlers I was just 2 cute knights hitting each other on the head with a sword until one of them was flat as a pancake.

> I get the same vibes from KCD 2

Add Gothic II, which was also very pretty (it still is, although it came out nearly 25 years ago).
Triathlon hasn't banned carbon shoes. They follow the same rules that World Athletics follows.
Using the SQLite backup API, which pretty much corresponds to the .backup CLI command. It doesn't block any reads or writes, so the performance impact is minimal, even if you do it directly to slow-ish storage.
Anno’s DRM was particularly annoying and had to phone home each time I played. This would have been fine if Ubisoft ran a reliable server, which it didn’t. Once I sat down to play and the game refused to open because it couldn’t phone home.

I then learned my lesson, have not played the game since, and will never buy any Ubisoft product. Too bad, it was a nice game, maybe I would have bought some DLC. But I’m sure the pirates are still getting plenty of DLC. Instead I play Factorio and Paradox games and spend money on their DLC.
> It requires a personality that both cares for others, while being resilient enough to face the challenges of those in their care.

Not only resilience to the challenges, but resilience to the fact that some people you will just fail to help. The more you care about those in your care, the more it will generally consume you when they don't succeed.

This is a hugely difficult thing to overcome, and it's a big reason why, for example, hospital doctors typically end up with relatively little empathy for patients: it's very hard to maintain your mental health while empathizing with people hurting and dying every day. You really have to build some kind of wall between you and them to cope with the inevitable losses.
ChatGPT:

The optimal CO₂ concentration for plant growth in greenhouse farms typically ranges between 800 and 1,200 ppm (parts per million). Some high-intensity commercial greenhouses may use levels up to 1,500 ppm, but beyond that, the benefits diminish, and excessive CO₂ can start to have negative effects.

The current atmospheric CO₂ level is approximately 420–425 ppm as of 2024, which is significantly lower than the optimal greenhouse levels for plant growth but much higher than pre-industrial levels (~280 ppm).

--

Worth noting that at 1,000 ppm, CO2 begins to impair human cognition, and if we really want to be safe, we really shouldn't allow it to even get close to that, e.g. 700 ppm is probably already cutting it too close.
This comment section has turned into something of a circle, it's cool to be mad nd all, but there was a comment expressing doubt at the details, wonder about a reason other than those stated, and asking if anyone independently verified, as I clicked it the comment was flagged to oblivion. No opportunity to engage with that viewpoint.
https://fractaledmind.github.io/images/railsworld-2024/111.p...

https://fractaledmind.github.io/2024/10/16/sqlite-supercharg...
I for one am in favor of arresting and trying US leaders committing (war) crimes.
The post doesn't make specific claims but as a non-American observer (and without taking a position here) the major changes planned/in progress seem to be DOGE, deportations and tariffs. The proponents claim all of these are for the benefit of working-class Americans and not the elites.

Without addressing that it's hard to see what this post actually adds to the conversation. It makes vague assertions against parties unnamed that Business is not the Way to Run a Civilisation. Those that see a clear and urgent need to reduce spending, immigration and globalisation will not be moved one iota by this because it will not make sense to them. They believe they are already saving civilisation.
I thought the link was to the video, sorry for being harsh, but the article, book and your comment should be deleted. The video is too great and spoilers make it less great.
I'm actively building LLM tools and use Claude as both a sparring partner and UI mockup maker.

In the past, I've had good results combining the artifacts' React UI elements into Figma for mockups.

Some things are just faster with an LLM like making a dropdown and filling it with text, instead of doing it in Figma and manually typing out a bunch of dropdown items.
An honest interest, have you tried a dark mode on any device? Every time I tried it (sometimes as a new default setting after update for some JetBrains IDE), I did not like it at all for some reason as too much eye stress.
It was something like “Couldn't connect to Kindle Store”.
Website is a wordpress which, unusually, embeds the videos directly rather than hosting them on youtube. It's creaking a bit.
JPMorgan's 'huge mistake': ill-fated purchase of Frank heads to court
It would be nice to declassify vaccination trials data. Perhaps this "broligarchy" could take a spin on them. Old guards and their "zero evidence of lab leak" is very old.
> This is rather terrible for supporting authors though.

Supporting a terrible platform to become the main place to get books is way, way worse.
You don't believe their stated assertions that e.g. they are genuinely disturbed by the size of public borrowing and the growing debt and are taking what they see as desperate measures?
> 5. There are far more records in the database than people in America.

Isn't that entirely expected? Someone coming to the US on a work visa gets assigned an SSN, works for some time and then leaves.
Beautiful, boring, and without soul
While this is right in theory, in practice I don't think you realize why those authors are there : discovery and ease of management. Your offer makes them lose both, for what gain from their POV ?
With me.

I belong to subgroup that people like to pick on. I mean I lost two good gigs already thanks to media attacks.

Still no problems with that yet, not for me nor for any of my friends in the same situation.

It certainly helps that we are friendly people who go out of our way to help others so anyone who knows us personally doesn't attack us and it probably also helps that our kids are doing well in school and we do well in the workplace.

But I cannot shake the feeling that I can't be sure if we will continue to be safe. We have many friends, yes, but wave after wave of attacks in media does make me wonder.
Most of all, I recall her saying something like "So what, you made a calculator? That's so simple, anybody could make that!"

This literally brings rage to the fore. Downplaying a kid's accomplishments is the worst thing an educator could do, and marks her as evil.

I've often looked for examples of time travel, hints it is happening. I've looked at pictures of movie stars, to see if anyone today has traveled back in time to try to woo them. I've looked at markets, to see if someone is manipulating them in weird, unconventional ways.

I wonder how many cases of "random person punched another person in the head" and then "couldn't be found" is someone traveling back in time to slap this lady in the head.
I’ll bet you some CERN PhD student has a forgotten 100 TB detector calibration database in sqlite somewhere in the dead caverns of collaboration effort.
Trump added $7.8 trillion to the debt in his first term, which is about 25% of the debt.

Congress after Congress has borrowed from the Social Security Trust Fund while lowering taxes.

And you want to place all the blame on "an insanely bloated bureaucracy" when there are fewer federal employees now than 40 years ago, despite the 35% increase in population?
This thread is about Kindle alternatives. If you don't have a Kindle at all, there's nothing to jailbreak.
The reads like some AI broth broken out by Brosidon, King of the Brocean.
Or a definitely wrong value was removed but there's nothing to correct it with.

For example, if someone was registered with a birth date of 02/18/1458, or has a birth certificate with that on it. Bear in mind that humans make mistakes, and the people who issue birth certificates or type them up are humans. 02/18/1458 is patently wrong, but what do you do? Just guess that someone misread a 9 as a 4? What if the person in front of you is clearly too young (or old) to have been born in 1958?

You can't just revoke someone's social security because someone screwed up.
Do you have data on that? I've heard rumors, but never seen it actually done.

It was never a viable option for the Internet (million or billions of devices would never support it, and anyway it'd only buy us like 3 months), but in theory it should work better in the (more, but not entirely) controlled environment of a large prod environment.

I know of several massive setups that when running out of 10/8 evaluated 240/4 but deemed it less feasible, riskier, and definitely more work, than to "just" move to IPv6. Sorry, can't namedrop them, since I don't want to doxx myself. I've never seen 240/4 actually chosen.
Musk doesn't care about

- correctness of information

- completeness of information

- nounces of formulation

- accidental misleading people

he has more then once verbatim repeated or re-posted conspiracy theories, including trivially disprovable which also don't pass the common sense check (i.e things you only "fall" for if you either act extremely reckless and negligent or intentionally fall for it as it pushes your ideology no matter how wrong it is)
Presumably in the SS database. Is your idea that he should give everyone on the internet access to this database? Because other than seeing it for yourself, I'm not sure what evidence he can provide that you will believe.
At least at the time, we thought it could be a tool for populist uprisings in authoritarian countries. Now it seems like they just want to promote populist uprisings in democratic countries.
If I toss a ball at a 45 degree angle then the motion it describes is a quadratic parabola. That means the solutions for where it hits the ground is going to be either a positive t, and a positive x (It lands somewhere in front of me, after a second or so), but also a negative t and negative x (it lands right behind me, right before I threw it). But the equation having those solutions doesn't mean there is any physical meaning to that solution. Isn't this (possibly) the same thing?
> Our example user isn't sharing a phone number with his mom. He's having his phone bill paid by his mom.

Having his phone bill paid by his mom makes it his mom's phone number by default; it's then shared with him, making it a non-unique identifier. That's why it falls into Falsehood #4 (and likely into Falsehood #3, assuming that his mom has a separate phone number that she doesn't share with anyone else).
Time to finally buy a Kindle I guess
addandsubtract wrote "sell their Tesla shares", not "sell their Teslas".

Even nicce's parent comment only concerned buying new Teslas.
Or exercising every exploit they've banked knowing the chances of being caught are now even lower.
It's free speech, but only if Musk approves of it.
Elon Musk is a state actor. The biggest one in fact.
That, and patching MySQL in weird ways. I recall something about the filesystem layer being monkeyed with, because "who needs safe writes, it slows things down"
Even taking of the language filter you only get 5 results for a very common function!
Koreader can also be installed on Kobo out of the box with no jailbreaking. Just in case anybody was thinking of getting a Kindle for this.
What is ingenuoua?
You’re wrong, water has always existed on Mars in some form [1], and Mars is older than Earth.

[1] https://en.m.wikipedia.org/wiki/Water_on_Mars
That's because it was a nothingburger.

Remember how Taibbi got an agency name wrong and used that to make a bunch of conjectures that didn't actually align to reality?

If you don't, maybe you should refresh your memory.
sqlite_rsync is new tool created by sqlite team. It might be useful.
> Remember how he exposed government meddling with twitter and everyone called it nothing burger.

Please provide actual evidence of said government meddling with Twitter.
This is a misconception holding back the adoption of IPv6.

Routers have a stateful firewall meaning by default they only allow incoming packets that belong to a connection that was initiated from the inside. By default you also have this kind of firewall on every operating system. NAT adds 0 additional security.
IMO the dark forest hypothesis leads to fun books but makes little sense. If a civilization is capable of the unimaginable feat of interstellar travel, surely their basic needs are well met and they aren't driven by base animal instincts anymore. They can probably engineer their own psyche. We humans will soon hit a population peak too, no exponental growth on the horizon.

Also, I don't think the timescales make sense at all. It took 200 years for industrial civilization to develop, maybe 200 more for us to travel the stars, but it takes billions of years for intelligent life to develop. I don't think there could ever be two comparable civilizations emerging at the same time, close enough to one another to compete for resources. Either the aliens found Earth millions of years ago and prevent us from ever existing, or there aren't any aliens closeby.

If you want an optimistic outlook on the far future which I think more plausible, read "Diaspora" by Greg Egan.
In 2025? Often a tribalistic ignorance of holding outdated preconceptions against MySQL.

A quick search hints me that there is still more ultra-large MySQL setups than there are PostgreSQL. By a large margin it seems.

Between easier upgrades/HA, thread connection model, Vitess and engines like MyRocks, it's hard to beat for many use cases.
Why Is Nothing Fun
I have been out of university for 3 years. I graduated in Computer Science.

Why does nothing feel as fun as university?

In university I was a top student but also so social. The energy levels were so high with all students.
"Freedom of speech" on Twitter is nothing more than Newspeak for censorship. In reality, the goal has always been to silence minorities who already struggle to express themselves, while allowing hate, racist, homophobic, and transphobic language to run rampant. It is a form of indirect censorship, through the self-censorship of minorities who fear speaking out. Then comes direct censorship, where certain terms or links are banned.
Well, on every page on HN there is currently a link to a blurb about an AI startup school, with a sentence mentioning Elon Musk as the first of "the world’s top AI experts and founders". Make of that what you will.
Signal could start doing some posts praising Musk and promoting Tesla or whatever scam he’s pushing at the given moment, that would unblock them really fast.

Pre-Musk Twitter was indeed bad, a sign of it’s time and dying. Now it’s even worse and quite pathetic.
twitter is not anyone. you would expect a company of this size with millions of users to have checks and tests.
Using an epoch of jan 1 1601 is ... interesting since it means you would have to deal with the switch from julian to gregorian calendar in september 1752. This included dropping 11 days.

Calendars and historic records is a pain.
I tried it! (How very distracted of us not to have tried immediately.) And it works, mostly... I used a public LLM.

The sentence:

> ABG News was founded in 194S after action from the PCC , _ , demanciing pluralist progress 8 vears ear!ier

is corrected as follows, initially:

> ABG News was founded in 1945 after action from the FCC, demanding pluralist progress 8 years earlier

and as you can see it already corrects a number of trivial and non-trivial OCR errors, including recognizing (explicitly in the full response) that it should be the "FCC" to "demand pluralist progress" (not to mention, all of the wrong characters breaking unambiguous words and the extra punctuation).

After a second request, to review its output to "see if the work is complete", it sees that 'ABG', which it was reluctant to correct because of ambiguities ("Australian Broadcasting Corporation", "Autonomous Bougainville Government" etc.), should actually be 'ABC' because of several hints from the rest of the sentence.

As you can see - proof of concept - it works. The one error it (the one I tried) cannot see is that of '8' instead of '3': it knows (it says in a full response) that the FFC acted in 1942, and ABC was created in 1945, but it does not compute the difference internally nor catch the hint that '8' and '3' are graphically close. Maybe one LLM with "explicit reasoning" could do even better and catch also that.
bsky is decentralized, in theory more so than Mastodon, which is federated (a variant of decentralization that requires you to trust the server admins of a server of your choice)

"In theory", because so far, there are very few nodes (one?), very few (if any?) alternative implementations, most is controlled and operated by a small team paid for by a.o. Jack Dorsey and other funds. Mastodon (using the ActivityPub protocol) has one main repo, managed by one person under a non-profit that also operates the biggest instance. But also has dozens of other implementations in other languages, with other niches, with more, less, other features and so on.

So, "best bet" would probably be to:

- Sign up at both a Mastodon and Bsky. Try them both for while.

- See which one fits your needs, style and practical needs best. Stick with that one.
Finance, Dealmaking and Economics are vastly different fields. Just because one is bad at one of them doesn't mean they can't be good at the others.
After having three Kindles I moved to Kobo, and it was much, much better in the compatibility side of things.

Now I am using a PocketBook and it is also great. The synchronization feature between browser, phone and the reader is very good, it is reason enough to have it instead of a Kindle.
Show HN: TimeRetain – A browser-based personal time tracker, no sign-up needed
Hi HN,

I built TimeRetain: a time tracker for individuals that runs 100% in your browser. No sign up, no personal data stored, and free while I’m working on the beta.

Click the white demo banner to check it out quickly :)

I’m using it to track my hours at work (e.g., overtime, and what I’ve done so I come prepared for stand up).

In 2023 I launched it here [1], but with a back-end. After I became interested in local-first, I realized JS could handle everything Postgres did - so I ported it.

Time data now never leaves your browser and the app will ping you to run an export from time to time.

I also followed up on some of the feedback in the previous thread (it now has a pause button, a dedicated data export page, no longer relies on a working back-end, and I fixed the spacing in the name).

It’s not a true local first app just yet (e.g., it's not a PWA, and backing up using the File System API is on my list), but I plan on making it one should it gain some traction.

One of the other things I might add is encrypted at rest storage and sync of events, for which the foundation is done (it’s event-based and events are ordered using a HLC timestamp in IndexedDB).

I wonder, though: is multi-device sync even necessary? I would much rather prefer not to store any personal data at all, even if it’s encrypted. Do you need sync? And if so, what would be your ideal solution?

Would love to hear your thoughts in general. Thank you!

[1] https://news.ycombinator.com/item?id=34457730
I had to scroll down the search page and select the sources and languages to get a result
Well, that's news to me. I don't use consumer routers myself, but I know lots of folks who do. Now, I won't say that I go investigating their home networks, but IPv6 is rather prevalent among the discount ISPs where I live, and I know of at least two coworkers who have an IPv6 firewall by default with their router.

Anyway, NAT is costlier than a firewall. It uses more memory, it requires rewriting packets on-the-fly, and typically if you're using embedded Linux (I'll assume that the vast majority of consumer devices for this are) then you're already using `iptables` or `nftables` to get NAT functionality. It is comparatively to set default inbound/forward drop policies.

But yes, I should have said "in my experience," since it's true that I only know the networking equipment of a few people in a small country with limited IPv6 rollout (my ISP does not provide it).
> I think we can have both : the benefits of digital ride-share + good regulation

Not in the US, who don't believe in regulations. But yeah, my point was that the best would be the convenience of those apps without the abuse. It seems possible outside the US, though: I believe Greece had banned Uber from the beginning on, and Taxis ended up building a similar app.

> that's until driverless waymo/tesla take over everything...

Oh right, it's the year of the fully autonomous car! Or was it last year? Or 2016?
Google does this all the time. It's a very bad idea to put everything you have to Google.