skysight-inc/HackerNews huggingface dataset:
Each object has an external key and an internal key. This separation allows you to migrate to other layouts, technologies, etc. without breaking your customer's links or records.

Internally, your database looks like:

User
ID - uint128
external_id - UUID (of some sort)
name - string

Post
ID - uint128
UserId - uint128 (User.ID)
external_id - UUID
...

Then you have secondary indices on the external_id columns in both tables, and the UserId column on Post. You can then join from one to the other using the ID column.

e.g.

SELECT count(*) FROM
Post JOIN User
ON User.ID = Post.UserID
WHERE
User.external_id = <%USERID_FROM_REQUEST%>;

// Don't forget to bind USER_ID_FROM_REQUEST instead of
// concating the string, no Johny-Tables here!

There should be significant performance benefits from using int's for the joining keys (at least compared to strings), but my experience might be old.
Milliseconds matter, especially when they compound. If your DB can return a SELECT in sub-msec time (to its network boundary, obviously) instead of 10 msec, that adds up when a given page might require a dozen or more trips.

Also, I have never seen devs (PMs, really – devs are the unfortunate souls slogging through tickets) suddenly care about performance-related tech debt. Why would they, when you can just click a button and double your DB’s hardware? Boom, problem solved… until it isn’t. Eventually, you run out of scaling, and since you probably don’t have a DBA/DBRE (else they’d have been screaming at you for months), it’s going to be extremely painful to solve now.

The bare minimum I’m asking – as a DBRE – is to use UUIDv7 and store them in Postgres’ native UUID type. That’s all. That’s an incredibly small amount of effort to put forth.
define: baser

> 1. (of a person or a person's actions or feelings) without moral principles; ignoble.

> 2. denoting or befitting a person of low social class.

(New term, to me)
Confirmed on Windows 10 64-bit with Firefox 127.0.2. After right-clicking, the Copy menu entry is disabled. Switching to another tab and back fixes the issue.
There was an astronomical year zero, it’s mainly historians who don’t want the year zero to happen.
After 2500 years, an idea still ahead of the times
I enjoyed watching this presentation by one of the creators: https://www.youtube.com/watch?v=uXhELbJhgoU

However, don't see any evidence that they have physical prototypes of multi-catom swarms. Seems like they're more interested in the controls side of it, which is itself a very difficult problem.

I imagine physical constraints (such as the amount of power needed to engage the device's electromagnets) would render real constructions impossible. I'd loved to be proved wrong, though.
I remember encountering one of these machines in 1973 or 74 when I was on the high school newspaper staff. We visited another high school in our district that had one and I watched it output beautiful proportional, justified newspaper column-width text. I was amazed.
See also: https://news.ycombinator.com/item?id=38058843 for a link to a text-only version; however, IMO their "translation" lies as much in Jane English's photos and the entire book presentation, as it does in the purely English language rendition of the text. I prefer other translations (including Le Guin's) for just the words, but Feng/English is still my favorite overall.
The article is careful to say the oldest dated printed book.
Voice controlled gaming assistant. Think of it as a copilot. I've since added overlays and responses.

Edit:
As I think on it more (it's been a few years since I dusted it off), added multithreading so some commands could process over time.

It was a great learning experience.
> the privacy fight is just completely unwinnable

I'm afraid it is, in the current state of things.

Another depressing example is how we collectively seem to accepted to keep referring to "unique fingerprinting and observation throughout any activity of the web and apps" as "Cookies! :))", while way too many people even blame EU privacy laws for all the purposefully annoying and misleading dark patterns used by the very entities spying on them.

But you can't blame anyone for choosing convenience and preference over a threat that is utterly overwhelming to mitigate, to the point of feeling impossible to avoid anyway.

Not to mention that a number of people rely on very specific UI features -- OP could well be my colleague, who has a muscular condition and simply cannot press "Ctrl + C" without discomfortable effort, or by constantly moving his other hand between mouse and keyboard. Others in turn may even be completely unable to do either, and fully rely on a pointer device to use GUI applications.

The only chance to win the privacy war is by providing and maintaining free and open alternatives that respect and protect your privacy, and are not only on par with, but better and more user friendly than the existing spyware.
> if something is conceivable then it is logically possible

What does it mean to be "logically possible"?

We could conceive of something that is pure garbage due to our lack of knowledge. Something that could never exist due to nature of the universe, but just because we can conceive of it does not mean it's a valid and non-contradictory state for the universe.

It's possible it's a valid argument from the perspective that it forces us into the corner of stating one of these two conditions must be true: either p-zombies or consciousness requires attributes to our reality that are beyond our current physical understanding.
I thought the exact same thing... when I was eight.
Then I just learned the mental gymnastics of hearing, say, "20th century" and associating it with "1900" at got along with it.
Really, it's a bit dated, but if people can function with miles and furlongs, they can handle centuries...
> They get a fuzzy feeling of superiority in their discovery that the mainstream ignores.

I mean, this is the allure of all quackery, conspiracy theories, cults, and other forms of "alternative" facts: The mainstream doesn't want you to know this secret that I'm sharing with you! Doctors hate this one simple trick! Your financial planner is lying to you, but if you buy my seminar, you'll learn the truth! The government is silencing us through mainstream social media, but if you come to Social Network Blah, you will be able to hear the truth! Employment is a scam, but if you join Amway you can learn the real truth about business and your own boss! My religion offers the truth that the rest hide from you!

Somehow, human beings have become vulnerable to "Truth FOMO" and when these guys really get their hooks into you and you start to base your very identity on their truth, well, you can't back out of it without invalidating your entire identity.
Hard to see how they are stronger after this

Russia is already dependent on North Korea munitions and drones from Iran ffs

For reference, in 2003 the US military deployed half-way around the world and captured Baghdad in 3 weeks

Nuclear super-power Russia has not been able to reach Kiev - just 6 hours away - in 28 months of open conflict
Not a portable format, yet.
I love the old-school font on this page. Reminds me of Word Perfect on the old Macintosh computers.

> pxplus_ibm_vga8regular

https://www.bing.com/search?q=%22pxplus_ibm_vga8regular%22+f...

Why is it only available from seedy foreign font sites?
thanks, just realised I mix those up quite frequently
Hypothesis doesn't try to give you a consistent probability distribution, especially not a uniform one. It has lots of heuristics to give you 'nasty' numbers in order to trigger more bugs.

That's actually one big reason I prefer Hypothesis over eg Rust's proptest, which makes no attempt to give you 'nasty' numbers. Last time I checked, QuickCheck didn't make any attempts to give you floats well-known to cause trouble either (like inf, negative inf, different NANs, 0, 1, -1, the least positive float, the largest negative float, the largest finite float just before infinity etc.)
https://www.theguardian.com/australia-news/article/2024/jun/...
I wrote that style of session mapping for a project long ago. It was fairly easy, but a massive pain in the ass to debug. Ended up needing to record the mappings in the backend for a period of time.
Just noting, the commenter you replied to said:

> use “bigint generated always as identity” instead of bigserial.

The commenter you are replying to was not saying anything about whether to use UUIDs or not; they just said "if you are going to use bigserial, you should use bigint generated always as identity instead".
Embed the resource files into the executable program
Embedding resource files into the executable program ensures that all necessary resources are included, simplifying distribution and preventing issues with missing files. It also enhances security by making it harder to modify or tamper with the resources.
I would guess that you are using a hard (sugar) maple cutting board or something similar. I prefer softer woods such as big leaf maple, cherry or birch in order to preserve my knife edge.
Your cube board is beautiful.
Interesting to see a Maltron user in the wild! What made to buy one, and what's your take on them? (say, compared to Kinesis Advantage?)
Creating a well-structured C project can greatly enhance code maintainability, readability, and reusability. This blog post will guide you through a practical example of a C project with a complete directory structure, including a functional Makefile.
Is this open source ?? We can use the same template for other games too if open sourced !!
This is tool for doing it on Windows too: https://github.com/EnhancedJax/IdleWebview
The cheapest Saleae Logic Analyzer costs $499.

https://www.saleae.com/products/saleae-logic-pro-16

A Greaseweazle costs like $35.

That being said, it's always fun to hack around using the tools you have lying around. Put money already spent to good use.
I once saw a spider amputate its own leg. It was severely crippled, only able to move in small circles. Then it suspended itself from a small shelf and started biting off the one leg that was immobile. After it was done it lowered itself on the ground and walked away totally fine.

Since the behaviour seemed very innate I figured that it must be something that happens frequently and is a known phenomenon.

Or maybe ant scientist just don't read spider papers :)
I am just reading about https://en.wikipedia.org/wiki/Zhuang_Zhou now (author of Zhuangzi). At the beginning of every chapter (in Lathe of Heaven) is a quote or extract from Zhuang Zhou's writing.

I just found a short chat by Kim Stanley Robinson where he mentions Le Guin's translation of the Tao Te Ching, https://www.youtube.com/watch?v=Atf7wvPmhjo
Hubris and confidence are two sides of the same coin. Did you maybe mean to say that one should balance hubris with humility to avoid coming across as arrogant?
Extension downloads are validated using a signature check to prevent tampering!

(I work for DuckDB Labs and MotherDuck)
If that is the original article, you can send an email to hn using the contact link and they can update it.
Selective partial SHA1/SHA2 matches only take a few seconds.
https://github.com/not-an-aardvark/lucky-commit
Colorado mountains, southwest of Denver!
>I've always thought that 'boy' sounded suspiciously close to the Swiss German translation "bueb" (or sometimes "buebe"), almost pronounced "b-way-b"

According to Etymology Online[0]:

`boy (n.)

mid-13c., boie "servant, commoner, knave" (generally young and male); c. 1300, "rascal, ruffian, knave; urchin," mid-14c. as "male child before puberty" (possibly extended from the "urchin" sense). A word of unknown origin.

Possibly from Old French embuie "one fettered," from Vulgar Latin imboiare, from Latin boia "leg iron, yoke, leather collar," from Greek boeiai dorai "ox hides." (Words for "boy" double as "servant, attendant" across the Indo-European map — compare Italian ragazzo, French garçon, Greek pais, Middle English knave, Old Church Slavonic otroku — and often it is difficult to say which meaning came first.)

But it also appears to be identical with East Frisian boi "young gentleman," and perhaps with Dutch boef "knave," from Middle Dutch boeve, perhaps from Middle Low German buobe. This suggests a gradational relationship to babe. Another conjecture:

In Old English, only the proper name Boia has been recorded. ME boi meant 'churl, servant' and (rarely) 'devil.' In texts, the meaning 'male child' does not antedate 1400. ModE boy looks like a semantic blend of an onomatopoeic word for an evil spirit ( *boi) and a baby word for 'brother' ( *bo). [Liberman]

Used slightingly of young men in Middle English, also in familiar or contemptuous use of criminal toughs or men in the armed services. In some local uses "a man," without reference to age (OED lists "in Cornwall, in Ireland, in the far West of the U.S."). The meaning "male negro slave or Asian personal servant of any age" attested from c. 1600.

Extended form boyo is attested from 1870. Emphatic exclamation oh, boy is attested by 1917. Boy-meets-girl "typical of a conventional romance" is from 1945; the phrase itself is from 1934 as a dramatic formula. Boy-crazy "eager to associate with males" is from 1923.

A noticable number of the modern words for 'boy', 'girl', and 'child' were originally colloquial nicknames, derogatory or whimsical, in part endearing, and finally commonplace. These, as is natural, are of the most diverse, and in part obscure, origin. [Buck]"

`

[0] https://www.etymonline.com/search?q=boy
Passkeys are a nice solution, and it's entirely possible to adopt them without locking yourself into Apple or Google's walled garden. That seems to require you to forgo using your Apple/Google devices as passkeys themselves, unless you use an unrelated app as your passkey manager.

It's interesting seeing how they're being used for lock-in, though. As mentioned in this thread, attestation in the standard will be abused towards that end.
Thanks! But this method requires Authy's Desktop client, which is unfortunately unavailable at this point.

Also, if this comment[1] is right, API access has also been broken.

[1]: https://news.ycombinator.com/item?id=40885456
Properly Testing Concurrent Data Structures
Crud I think you're right. I had it in my head that in steady flight, the plane had zero change in momentum, whereas, the air, collectively, gained net downward momentum. So to balance it all out, the earth must be gaining upward momentum (though of course spread over such an enormous mass as to make the velocity term imperceptible.)
The number of bad solutions is not just almost infinite. It is definitely infinite. Because, by induction, you can always make another bad solution from a bad solution by adding something unnecessary to it. Hence infinity. QED
I’ve found that most (not all, but overwhelmingly) sites allow you to enroll multiple passkeys. iOS also automatically supports a third party app for using or enrolling passkeys with.
Thankfully there's still a 3rd player running it's own mobile infrastructure.
Ok, 18.1.8 uploaded [1] [2].

[1] https://github.com/llvm/llvm-project/releases/tag/llvmorg-18...

[2] https://discourse.llvm.org/t/18-1-8-has-been-tagged/79726/10...
I'm a practical man, for me it's just n_loc difference and more useful imlicitness (and the listed downsides). Not sure if I can understand this "creation" part, even as a former Perl-ist. I think you can turn any language into Perl, it just happens that their core beliefs are incompatible with its ways.

For example, I can easily imagine something like this:

import 'use-perl'

while (await ls_lr('./*.txt')) {
while (await read_lines($filename)) {
print($ln, $line)

But it's not idiomatic as it uses awful implicit iterators and hideous globals. This conflict is purely dogmatic and doesn't need special syntax, for the most part.
A Roger's exec used to brag that they were able to release major changes faster than anyone because of their strategy which was "push it out... the customer's will find the remaining bugs". This was more than a decade ago, but it seems like it is still their culture.
There are much cheaper logic analyzers out there.
> The Thirteenth Amendment (Amendment XIII) to the United States Constitution abolished slavery and involuntary servitude, except as punishment for a crime.

https://en.m.wikipedia.org/wiki/Thirteenth_Amendment_to_the_...
I just wanted to thank you two here. Your dialog is so insightful. I think the original article was bad. It's biggest merit is that it got you two together here in the comments!
I especially love the aesthetic of the industrial ones that emboss steel or aluminum tape: https://makezine.com/article/science/tool-review-dymo-metal-...

“If you’ve ever used one of Dymo’s small 1/4″ or 3/8″ plastic-embossing labelmakers (and who hasn’t?) you already understand how this tool works, and how to operate it. But in terms of construction quality and durability, the Tapewriter is as far removed from those cheap plastic embossers as a Mercedes is from a Kia. It’s 10″ long, weighs almost two pounds, and is made almost entirely from cast aluminum, with steel fittings here and there, and all held together with machine screws. The only polymer in the thing, as far as I can tell, is a rubber friction coating on the internal tape drive wheels.”
> I will never understand parents thinking that they somehow deserve to know every single thing their child is doing and saying beyond basic parental controls.

Parents have a responsibility to parent: at minimum, making sure that their child doesn't get into anything truly dangerous, exploitative, or criminal. This is easy to do in physical reality but quite difficult to do for online activities unless you are literally watching over the kid's shoulder. So I can easily see why a well-meaning and worried parent would be tempted to install some sort of spyware.
OF course it is absurd--but having to see your doctor for each refill and only being allowed to refill when you are almost completely out is also absurd. Sometimes an absurd situation calls for an absurd response.

At least two people so far have described glitches at their doctor's office combined with not being allowed to request a refill until they are almost out resulting in them running out and missing their medicine for days.

Your glasses comparison doesn't really fit. A better fit would be disposable contact lenses, which you are supposed to only wear once and not wear for more than a day. I wear glasses, not contacts, but if I switched to such contacts and they would only give me a 30 day supply, would not give me a new supply until I'm on the last few days of my current supply, and made me see an optometrist for each refill probably would try to use my old glasses every now and then instead of the contacts to widen the resupply window.

The insulin comparison also doesn't really fit because from what I've read missing your insulin for even a few hours, let alone a day, can cause serious and dangerous problems quickly. The skipping to build a reserve would only be an option with medicines where an occasional missed dose doesn't have any serious consequences.
A six minute sample from her reading, https://soundcloud.com/shambhala-publications/tao-te-ching-b...
This is a bug in a very obvious location that is triggered, in my experience, all the time.

It's easy enough to work around, but it's also just terrible optics. Why does something like this take the better part of a year to fix?
Think of it as the 700s, which is a weird way to refer to the 1700s, unless you are taking a cue from the common usage. That’s just how the periods are referenced by Italian art historians.
Even for a combustion car, 110mph is fast enough to be past the efficient range of speeds. Unless you're driving a Ferrari or something.
Bugs can make great stories. But only for a niche audience. Not Hollywood.
Argh! Spoiled my tape-delay match.

https://giphy.com/gifs/justin-g-grr-fists-grrr-l0NwOkgTYRi30...
PBS American Experience: 1988-2022
Inferring Causality
im stuck on some C code and i was wondering if there is a way to figure out how modifying one variable affects all other variables down the line? (alternatives to sourcetrail)
"Micro Chart" CPU reference cards (6502, Z80, 8088/8086, 68000)
Are you saying that low paid workers don’t have the cognitive capacity to do more than cook hot dogs?
Maybe read further.

>Last July, China installed another buoy inside Japan's exclusive economic zone

as well as

>with Japan protesting against repeated intrusions by Chinese ships into Japanese waters around the Senkakus
ConvNet vs Transformer, Supervised vs CLIP
If you mean Bell, they are near non-existent in these parts.
> There’s no good way to refer to 2000-2009, sorry.

In terms of music this is true.
Most of us are rational people here. Given that, how likely do you think it is to have no foreign intelligence agents on your payroll unknowingly in a strategic company like this one which has several thousand employees? And I don’t just mean Chinese, I mean every country with a competent foreign intelligence service.
Involuntary tech support.
Passkeys have terrible branding, with passkeys being used to describe multiple things over time and depending on what you're reading.
Great points, thought provoking! I think LLMs are about to usher in a new era for academic translation. Obviously they have their faults, but philosophy in particular suffers to a much greater degree from language barriers than the layman might guess, so I think there’s a lot of room for improvement. In particular, many German and French authors have works that haven’t been translated yet, and, more relevantly, Chinese philosophy is still only tangentially related to European philosophy. When books do get translated, they often are translated with a significant delay, obviously leading to issues for people trying to form a scientific consensus.

I think the work of both great thinkers like Husserl and more underappreciated ones like Edith Stein would benefit greatly from LLM-assisted term-standardization and overall synchronized translation, with their original German-language works fed in alongside the translations we do have, for automated comparison purposes.

The academy is efficient, but IMO we’re about to see a scientific revolution in the humanities — aka cognitive science.
ITER fusion reactor to see further delays, with operations pushed to 2034
You know I hear people say stuff like this a lot. Big catastrophe and we need major changes. But then I don’t see many studying Chinese so they can help negotiate a global treaty. Or working on effective propaganda to convince the public that nuclear is good. Instead I see a lot of reusable totes, compost bins, and other virtue signaling trivialities. So what should I believe, what people say or what they do?
Windows 3.1 and Word easily fit on a 40MB hard drive with plenty leftover. Word operated on systems with as little as 2MB RAM on a single core 16MHz 80386. Modern microcontrollers put this to shame! Word then didn’t lack for much compared to today’s version.

Windows and Office require now, 50-100GB disk just to function? 1000X for what gain?

This is sheer insanity, but we overlook it — our modern systems have 5000-10000X as much disk, RAM, and CPU. Our home internet is literally a million times faster than early modems.
An actual Lisp programmer will tell you that the right thing depends on the situation. The right thing can be a lambda, a string, a symbol, a structure, a class object, a hash table, a vector, a list, a call to a foreign function, a syntactic abstraction, a bitmask, a load-time value, a pattern matcher, ...
The best translation of Tao Te Ching is from OSHO. Hands down a hidden gem --

https://oshoworld.com/tao-upanishad-by-osho-01-127/
Likely not a joke, rather a pointed "look how ridiculous it is to try and contain basic technology" and also an implicit that China did not lose out its power position due to "stealing of Chinese technology".