skysight-inc/HackerNews huggingface dataset:
> The surrogate key uniquely identifies a row in your database, which is an entity just as real and significant as the car or the employee or what-have-you. Don't confuse the two!

But the DBMS already maintains a row identifier (called rowid or ctid or whatever depending on the DBMS). Why do you need an explicit one?
Apparently they had all kind of problems with the Windows client. DNS hijacking, route injection, etc.

IMHO understandable that they didn't want to deal with the Windows mess.
Looks like the places I have brokerage accounts don’t let me make a trade like this at all after hours.
This is a useful story to remember.
What I’m doing right now is putting synthetic (auto incremented) ids on every table, but also adding lots of compound unique indices. We have a lot of long background processes that might need to be restarted in the middle. The natural key definition allows for easy idempotency in subsequent runs (the jobs only upsert with. collisions handled by a simple timestamp update).

Most entities are tied to a version record (more or less a God object). But some span across versions. I’m able to have the entities that aren’t tied to a version float around because they reference the natural key of the versioned entities, minus the version’s synthetic key.
I don't get it. People around me have been saying Google is shit for years now but I can't see it.

I still reach for google for any minor query, and it's super responsive and it's super helpful.

Yes of course I am aware that for certain queries you get a lot of results that have manipulated their way to the top. I just think I have a very good natural bullshit-filter.
Any odd number 2n+1 of "a" repetitions, longest match. The inflating first rule is preferred about 2n times until it fails at input end, then the parser backtracks until the middle "a" is matched by the second rule and the others by n expansions of the first rule.
and here is today's but if I copy I don't get a link . Just "Huewords Daily #44 solved in 06:17 with no hints! https://huewords.snellman.net/"
Show HN: 2d web paddle game
Simple retro paddle arcade game written in Javascript, using good ol' Canvas.
> most product changes are driven (at least publicly, within the company) by a desire to improve offerings for users.

The key is: "publicly, within the company"
The author is an engineer at AWS so he has an obvious bridge to sell.

That said, I do agree with the general point of needing more than one computer. But most people probably just need two, one for backup, far from “distributed system” in the traditional sense.
> And you certainly don't want to system to swap in and out gigabytes of memory.

Why though?

Swapping 32GB of memory in and out of an NVMe SSD is much faster than swapping 1GB out of a spinning disk so I really don't get that argument.
Adding more lanes didn't decrease congestion so, for once, giving people an alternative to driving sure isn't going to increase it. It's just one lane. Not even a lane if the lane size is currently oversized with respect to the speed limit (which it is on most roads in the united states)

>I live off a main road into a town with a wide cycle path separated from cars. The town has slow moving traffic and seems a reasonable place to cycle. The cycle lane is still lightly used.

I'd have to see a streetview of it but I wouldn't be surprised if it was just a lone bikelane with no real network around it to support its use

It's not enough to have just one lane that's safe, people won't bike unless they can find a whole itinerary where they don't risk getting flattened by an F-150

>Effort matters too - cycling is more viable somewhere flat.

And somewhere sunny, and somewhere dry, the fact is, people cycle in Finland yet they don't in Canada because it's not safe

We have electric bikes now so slopes are even less of an issue than they were previously

>For me cycling has a very narrow potential use case - if its too far to walk, and close enough to cycle, and I do not need the luggage space of a car.

Tell that to all those people in Amsterdam who don't even bother to get a driving license
> that a) seems like a possibility to me

Then there’s no Starship. Back to the drawing board.

I’m doubtful we get to c before 2030. But b should count as a win, particularly since—in the spirit of Artemis—that’s kit that keeps on giving.
I'm of two minds on Google's MO on products.

On one hand, I appreciate that they try all sorts of things and seem to have almost no hesitation with launching some things which are quirky or of niche usefulness.

On the other hand, the only things that have ever survived are Docs, GCP, and tenuously, Voice. I don't mind them launching and shutting down a lot of products, but it's really stunning just how few things actually make it.
I've become a fan of unique, relatively short and "human-readable" IDs, such at the ones used by Stripe, e.g. `cus_MJA953cFzEuO1z` for an ID of a customer. Here's a Stripe dev article on the topic: https://dev.to/stripe/designing-apis-for-humans-object-ids-3...

If you use JavaScript/TypeScript, you can make them like this:

function makeSlug(length: number): string {
const validChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
const randomBytes = crypto.randomBytes(length);
let result = "";
for (let i = 0; i < length; i++) {
result += validChars[randomBytes[i] % validChars.length];
}
return result;
}

function makeId(tableName: string): string {
const idSpec = TABLE_NAME_TO_ID_SPEC[tableName];
const prefix = idSpec.prefix;
const slugLength = idSpec.length - prefix.length - 1;
return `${prefix}_${makeSlug(slugLength)}`;
}
I'm annoyed that it is getting harder and harder to find what physical filesystems are on a system.

My goto commands "df -h" and "mount" are cluttered with all kinds of ephemeral filesystems, with no easy way to filter (say, a one-character flag). lsblk is close but .. lvm and snaps.
So basically GtkDialog's utility boils down to gtk_dialog_new_with_buttons(). That's like five line of code saved per dialog box, or zero if you use Glade to build the UI.

The big deal for GtkDialog used to be gtk_dialog_run(), which is a bad idea.
I wrote a JavaScript version of this using Intl: https://github.com/GoogleChrome/lighthouse/blob/9baac0ae9da7...
> Google even pays Apple billions to be the default on their devices.

ca 20 billions per year, just to keep their search engine as a default. https://untested.sonnet.io/Defaults+Matter%2C+Don't+Assume+C...
Lua is one of the most amazing bits of programming tech you can use... I have done all sorts of crazy things with it, from applications-with-databases to realtime scientific analysis, games engines and games ahoy, simple automation tooling for devops, and more. I recently decided to sit down and organize a few hundred directories, each with more than 20,000+ files in them, and I've now built a system that my colleagues are asking about installing for themselves..

Its just such a great tool, please don't deny yourself this wonderful experience. Get the VM, put it in something - or find a VM somewhere in something already, and have a lot of fun. And don't forget to make sure you know what a sparse array is, and why pairs() and why ipairs() .. you'll be glad you did!

PS - don't fall for the hype, you can do someTable[0] = "first", someTable[1] = "second" all you like .. :)
I have yet to see substantial swap usage outside of memory pressure scenario. Means the benefit is marginal. All processes seem to be reasonably optimized not to leave lots of not accessed memory around. Or they have sparse access pattern which is touching a lot of pages.
You missed Pinterest :)
Interesting. If I had to do this, I would have done something like

perl -lne 'next unless $_; $z = qx(echo "$_" | gzip | wc -c); printf "%5.2f %s\n", $z/length($_), $_'

on the principle that high entropy means it compresses badly. However, that uses each line as the dictionary, rather than the entire file, so it has a little trouble with very short lines which compress badly.

It did react to this line

return map { $_ > 1 ? 1 : ($_ < 0 ? 0 : $_) } @vs;

which is valid code but indeed seems kind of high in entropy. I was also able to fool it to not detect a high-entropy line by adding a comment of natural English to it.

I'm on the go but it would be interesting to see comparisons between the Perl command and this tool. The benefit of the Perl command is that it would run out of the box on any non-Windows machine so it might not need to be as powerful to gain adoption.
I think good content is now in video, tiktoks, shorts & reels.
Google is unable to show this in the rankings.
> Unexpected failures have the potential to derail such a program for years

Catastrophic ones, sure. But not just the unexpected. If you aren’t unexpectedly failing in such an endeavour, you’re not pushing hard enough.
You are right, but it’s not very difficult:

The trigger can be “Double-click Main Menubar” and the action “Show / Hide Menu Bar Icons left of the BTT Icon.”

You can even add actions to hide them again after a certain number of seconds or minutes.

(It’s only a partial replication because Bartender can show you the additional icons in a secondary bar, if needed).
agree, can tell you meant the price of the seats are super high because it is such a big deal (while contrasted with the guy who's getting paid to watch).
The question is: if you have two restaurants having different scores but distinguishable only by their surrogate keys, how do you know which one to go to?

In other words - using surrogate key is an attempt (and the wrong one!) to fix the problem of missing important information in the database.
"Discuss" or "Discourse" ?
Pinterest is dead.
Python (or any non-Lispy language) REPLs are not truly REPLs in the way that Lisp understands the REPL. Every phase of Read-Eval-Print-Loop cycle has limitations:

Read: In Python, the input is read as strings of code, which are then parsed and compiled. In Lisp, the input is read as data structures (lists, symbols, etc.) due to its homoiconic nature (code is data). This allows for macros and syntax rules to be applied even before evaluation.

Eval - The evaluation phase involves interpreting the compiled code. Python’s evaluation is less interactive; changes in function definitions or classes often require the code to be re-run entirely, and the state can become inconsistent without careful management. Evaluation in Lisp happens directly on the read data structures. Functions, macros, and variables can be redefined interactively without restarting the REPL, maintaining a more fluid development process.

Print - The result of the evaluated Python code is printed out in a standard format. The printing is straightforward but lacks customization unless explicitly coded. In Lisp, results are printed in a way that preserves the structural representation of the data, facilitating easier inspection and manipulation in subsequent steps.

Loop - In Python, the main loop doesn’t offer much in terms of tooling or integration. Extending the REPL with custom behaviors or tools requires additional packages or integrations. The Lisp loop often includes advanced features like hooking into debugging tools, live editing, and runtime modifications, providing a richer development experience.

So, it really makes you ask: can you actually have a proper, "true" REPL in a non-Lisp language? So while it's fair to call them REPLs in a technical sense, they more like "interactive shells" and not REPLs. You really need a Lisp to have a proper REPL.
Has anyone else noticed that Google doesn't index source code from GitHub anymore? I could have sworn that you used to be able to search for source code that is on GitHub (e.g. error message strings), but today the index doesn't seem to include the source code at all. The pages with the source code are in the index but you can only find them by file name. Big loss for Google if so.

I also mourn the Google cache. I bet site owners were lobbying to get rid of it, but it's really lame that Google caved after all these years...
> I'm talking about these new things with ram integrated into the SoC...

But you were already told that this limit is just for this entry-level series of chips.

You asked what other series of Intel chips supported more memory, and the answer is all of them. If your question was supposed to not be about other chips, then your question makes no sense to me. And if that's the case then why did you bring up Xeons and your previous box?
> Ask HN: Is Google Dead?

> Betteridge's law of headlines: "Any headline that ends in a question mark can be answered by the word no."

Google will remain dominant because of the ease of returning to something familiar.

It is the same reason that MS is pushing OpenAI - once they become the familiar brand, people will stay there even if Anthropic blows them out of the water in terms of quality.

All the more so here where Bing results (aka DDG etc) are comparable or worse for a large number of queries.
> thanks to Elon fucking over the entire industry with his ridiculous bullshit)

are you actually saying that elon has been a negative for the EV industry? if so, are you quite serious?
Duolingo removes all LGBT content from its app in Russia
Enshittification. My vague prediction is they will sink $$$ and change board and ceo when it flops, but will save bigly on residuals and avoidance of staff costs. Zero profit films will continue to earn big money with sunk costs to avoid payments to rights holders.
I believe it’s a pretty good analogy, yes.
Your database starts to look like git...

Think about a jet engine. Let's say you figure out that a part is defective and will cause a failure. You want to identify every plane that has one of those parts in it. What if you find that some of them had a bad oil pump that shortened the life of some bearings. You want to know every engine that had one of those pumps, so you can replace other parts.

I dont know if they do this with jets but there are quite a few places that take thee concept much further than this.
But it is still more than an order of magnitude slower than RAM, and is harmful for the disk cells.

If you have enough money to provision NVMe and still swap multiple gigabytes, just get a 16GB RAM stick for $40.
Most of the spaghetti against the wall MVP from meta fails to gain any traction, and if it does it becomes a feature in a main app. Post year of efficiency it might happen again, but every successful Meta app outside of FB was an acquisition of an existing viable product. (Messenger, Whatsapp, Instagram, Occulus) I was really hoping Portal was going to catch on, I really liked it and found it to be a great home VC platform.
Not an answer to your question, but Github code search is great: https://github.com/features/code-search
Fair enough. At least in my case it would be an easy decision, as my social media usage stops at hackernews. Or even if I did use something like twitter, I'd just make a new account. How would they know the new account is me?

Though, not all haters go directly after people. I'd even say those are in the minority. Most congregate to one another and form some bond over the shared dislike of said person/thing. Maybe start a subreddit, parody twitter account, or the like. Some just post complaints about the person without ever @mentioning them. I'm positive not every Elon Musk complaint tweet on twitter directly @mentions him.
I googled his discord identifier (not the display name, but the one you can't change), and it is apparently an Indonesian surname, so I think you're right, he's not Japanese at all.
It may be useful if you have data that originates from another source or if something outside of our system references your entity. In that case you need to keep some form of an externalRef, so it's usually easier to just use an id that you can control, for referencing both internally and externally.
I have found the inheritance method, just add `-d` option.

But I can't find the way to prevent 640. I know it's not really read by all others, but sshd will prevent login with error `error: Permissions 0640 for '/etc/ssh/ssh_host_rsa_key' are too open.`. I have tried a lot of commands, but still can't resolve this.
This is Google. You need a major feature to get noticed and promoted. This feature was almost certainly shipped to ensure a pay rise/promotion for both the manager who delivered it and the manager who approved it. This was likely different in Google's early history. Unfortunately, this is how FAANGs and other large companies operate. You can only get promoted if you deliver something that convinces other managers in the company you deserve that promotion.
A Google query returns in <<500ms (for me anyways). Try that with your shiny LLM's.
The tumbling sure made the footage a lot more spectacular than straight-and-level flight would have :) It's still pretty stunning that we could watch it live, in that quality, nearly uninterrupted.
Short and Distort

https://www.investopedia.com/terms/s/shortanddistort.asp
Maybe in 200 years, or 50, this fearmongering will be considered a crime against humanity and an insane power grab by privileged eugenicists who rule the world.
> good content is now in tiktoks, shorts & reels

lol
“moving the pagefile to a RAM disk.” is a hacky way to emulate disabling swap :P

In an ideal world, swap would automagically move stuff that you are not likely use soon out of RAM even when you use poorly written programs that don’t do that explicitly. And, disk cache would automagically keep stuff in RAM that you are likely to need again soon even when using poorly written programs that don’t do that explicitly.

So, ideally, they work together to max the effectiveness of you RAM.
I don’t like the company and stopped using Google search over 5 years ago. I don’t miss it or even notice its absence.

I have to remind myself Google is a massive part of many people’s experience of the internet.
>entrenchment of existing inequalities

This can also refer to wealth inequality. Especially between people who work for a living vs people who own assets for a living.

And it's worth putting that first, because it's arguably most likely to actually happen of all these threats.
Yeah I'm really glad GitHub finally has functioning code search (how many years did it take?), but I don't like being forced to use it for simple stuff. It's slow and doesn't include source code or documentation that's not on GitHub. I don't always know in advance whether the answer to my query lives in GitHub or not...
I think what many people forget is that applications can ask for a bunch of memory and then never do anything with it (or just do something with it once).

Imagine you want to write something down, so you ask me for a notebook. Now you start writing very slowly such that I can tell you're not going to need more than one page of that notebook for quite a while.

I don't want to take the notebook away from you because you're fussy and you insist on having the entire notebook to yourself, but someone else comes along also wanting to write something down.

Me being the clever kernel that I am, decide to let you keep a "virtual" copy of your notebook, but really only the first page of it is "real" paper and I give the notebook to the next person who ALSO insists on having an entire notebook to write down a few words on a page.

I can now have 20 people all writing in their own "virtual" 100 page notebooks, while I really only have a single 100 page notebook to go around.

Only when the combined total of all needed pages REALLY hits 100 pages will I start to run into issues.
I stand corrected.

The best info I've been able to find about the architecture is https://www.df-f.com/blog/ios17 Is there more info available, yet? Might this be related to Apple's recent sponsorship of seL4--https://sel4.systems/news/#member-apple?
Or just use uBlacklist to block certain sites in search results: https://chromewebstore.google.com/detail/ublacklist/pncfbmia...
Product Managers are only as great as the last new shiny product feature they deliver. This is a systematic problem for companies. Product Teams rarely prioritise fixing technical debt that is actually resulting in significant operational overhead. They prefer to focus on yet another shiny feature, as it is much easier to market.

"We need to spend some time fixing technical debt for the last product feature we rushed to market, as it generates too many support tickets."

versus

"We delivered dark mode. Shiny!"
As someone who is fluently bilingual I have tested the exact thing people say AI in the browser would be good for, translations and subtitle generation and it was abysmal. It produced sentences that absolutely look correct but the meaning has fundamentally changed. Someone fluent in both languages would know what it intended to say but for those people we wouldn't need the translation anyway.

It was deemed far too much work to be viable at this point seening as we would still need to employ someone to double check the translations anyway so the project was canned.
Reddit’s search is notoriously bad, so at least for now, there is still some value in searching Reddit via Google.

It lends some credence to the idea that no matter how bad a service decays, it doesn’t matter if there is no better alternative. It can get worse and worse forever if competition doesn’t exist.
I see. I guess that's why high-end audio is so expensive
If Denmark is anything like Sweden there's also:

- SSN from different ID space gets assigned to immigrants; when they become citizens they are assigned a new permanent SSN.

- SSN:s have a long and a short form; the short form which cuts off century information can be the same for someone who is 5 years old and someone who is 105 years old.

- When an unconscious patient comes in to the E.R. you don't know their SSN, so a temporary one is assigned for use in patient records. Such temporary SSN:s are not coordinated nation-wide so multiple patients may have the same SSN. In some hospitals they don't even have a local standard for ID:s. The staff just makes something up on the spot. It happens that the SSN they made up collides with a valid SSN for another person.
Why would you care about the tankers? The engine costs around 2 million dollars rounded up, that means the upper stage won't cost significantly more than $20 million.

The only thing they have to reuse is the booster. That alone will get them the Artemis 6 contract. Once you have reused the booster, you can do as many reentry tests as you like, even if it is just for fun. For every saved booster, you can do three reentry test flights and still break even.
It's not that hard to max out system capacity on desktop boards. I'm using the maximum possible 128 GB RAM on my desktop.
No no no

You don't get to just say 'you wouldn't need them'.

This is wishful thinking. 'Apple won' because of the marketing.
You’re welcome :) The asset names got slightly weird in this release (and GH doesn’t let me change it because there’s a dot in the name and it prevents removal of file extension), but with a future release the GH action should name them better. But you would probably rename the downloaded file anyway.
> it's really stunning just how few things actually make it

which echoes my experience in the music industry, and what I've seen of VCs in tech, and small businesses in my town.

very, very, few things are successful, and even fewer of those are successful at the kind of scale that Google needs to ensure that they don't become a sprawling mess of millions of employees. they need very high margin high value products at high scale, supported by the fewest possible engineers (even if that number is still thousands or tens of thousands of engineers)... and the truth is, for that business model, very few things are possible, and that the understanding of what those things are is going to be the result of trial and error.

I'm almost completely de-Googled now, so these announcements affect me less and less as time passes, but I do understand why they do this, and it does make business sense
I found that helpful.
Heresy. The one-story 7-11 in Central square takes the prize.
SSD write endurance scares me more than running out of memory.