skysight-inc/HackerNews huggingface dataset:
I understand the performance implications of using a UUID for a primary key. And if performance is your primary concern, then this is good advice for large tables.

But if I could go back 25 years and only give myself one bit of advice, it would be to use UUIDs as the primary key. Because in a different context to raw performance, it offers a lot of advantages.

While there are advantages in numerous areas, I'll focus on one for this post. The area of distributed data.

We started by running a database on prem. Each branch or store got their own db. 15 years later always-on networking happened. 15 years after that, all businesses have fibre.

So now all the branches use a giant shared online database. With merged data. Uuid based this task would be trivial. Bigint based, yeah, it's not.

Along the same timeline data started escaping from our database. It would go to a phone, travel around a bit, change, get new records, then come home. Think lots of sales folk, in places without reception, doing stuff.

So you're right in the context of a single database (cluster) which encompasses all the data all the time.

But in the context where data lives beyond the database, using uuids solves a lot of problems.

There are other places as well where uuids shine.

So as with most advice when it comes to SQL, I'd add "context matters".
Reading Hamlet is as hard as writing it, no reader has ever enjoyed the same pleasure the writer indulged, being finished.

"Reading" Hamlet is something my pet hamster does for breakfast.
That countertop unit looks great.

Question - how do you deal with countertops that have storage tanks made out of plastic?

Are there no concerns with microplastics at all with these units? I know the plastic is not the Polypropylene stuff, but still.
Any chance you CH is proxied through a Heroku app? Heroku has 30s timeouts.
Possibly the credentials were encrypted, but the attackers got the encryption keys as well?
Phone layout plus * and # is extremely common on combination locks, even ones with electronic displays for keypads like this https://www.levellock.com/home-and-office-electronic-lock-wi... so maybe it's just more widely recognized by users for non-computer, non-calculator devices.

When I opened a bank account, I had to choose a PIN on the keypad in the office (probably a computer numpad with the same layout as a keyboard) and the clerk warned me that the numbers are upside down compared to an actual POS machine or ATM (which are phone layout).
A BRAND NEW Apple Watch SE with cellular is $330 (and it goes on sale sometimes). You’ll have to add it to your cell plan which is usually $10 a month.

Siri works great for a lot of the basic use cases that didn’t work in the video. Reminders, notes, alarms, messaging. Honestly I’m guessing it would work just as well for some of the knowledge questions that they asked.

Except if you do that you get an Apple Watch. It tells the time too. It also counts your steps, tracks your heart rate, functions as an exercise/fitness tracker, does a better job of showing your notifications, can stream music from services other than Tidal, can actually show Photos and Web results and emails (although the screen is obviously tiny).

It doesn’t have a camera though.

So that’s $370 less for the device and $15 less per month? For something that already works way better? And doesn’t seem to run the risk of burning you and constantly turning itself off due to overheating?

Hey look! That’s saving enough money that you could actually buy a second Apple Watch and still come out ahead.

Wow this is a dud. I wasn’t expecting it to set the world on fire. I wasn’t even expecting it to be good. I did not imagine it would be THIS bad. The two things I use Siri for more than anything else or reminders and texting. And this thing can’t do either one.
You're just missing the "next gen speed tier" which is available in some areas and usable if, and only if, you own a blessed modem. I'm in the same boat, 20 up (which is a nice increase from 5 a year ago), but I could get 100 if I rented or bought the right modem.

https://www.xfinity.com/support/articles/upgraded-areas-leas...

https://www.reddit.com/r/Comcast_Xfinity/wiki/knowledgebase/...

https://assets.xfinity.com/assets/dotcom/projects/cix-4997_c...
I can't wait to pay you so you can harvest my personal information.
For sure. I never trusted them. I got a #14 welders glass for the annular about 13 years ago or whenever it was and it's served me well ever since.
OpenAI makes ChatGPT 'more direct, less verbose'
If ensuring that kind of "safety" (a massive misuse of the word) were an actual security concern, then neither the original, "aligned", un-fine-tuned model, nor a model with an outboard "jailbreak detector", would ever be reliable enough for the word "ensure" to apply, and no sane person would deploy them at all. The "alignment" technologies do not work and nobody knows how to make them work.
I mean, most doctors are spending their entire shifts trying not to inadvertently kill or disable anyone. Yeah that's a completely different type of mental taxation - one far worse IMO than any highly complex problem I've ever encountered in software engineering (and quite frankly, the problems aren't that complex most of the time. If anything, personally the SE stuff that's actually hard is fun and the rest is rather mind-numbing).
I think that's a fair judgement!

There's an expression I've heard here that amounts to "If you lose your job, start a business". People prefer steady jobs, but if that's not available, you either start a business or join the family one.

A side effect is that when I go to industrial markets, a lot of the shopkeepers are working for family, and aren't really being "paid" per se. So they can be a bit cranky at times, there are indeed places they would rather be. So I make sure to have my order ready and zero questions :)

I'm actually setting up a family business in Vietnam right now. Many families have one, but mine does not. I've got relatives coming back from jobs overseas and I want to offer them something better than being a receptionist for USD 250 a month. Or at least something in addition to that.
> If I used IPv6 everywhere in my server room outsiders could see the topology of my internal Network.

When was the last time an attacker punched a hole through a firewall device?

Attacks generally start from compromising a user machine (e.g., phishing) or a server (via server-software exploit), installing some malware on already-internal machine, and start probing from there. Not being able to see the internal topology has hindered precisely zero network compromises.

> While we definitely need firewalls and/or packet filters at the network edge, most of today’s attacks work on application-layer, using SQL injection or “Advanced Persistent Threats” like sending an Excel or PDF file with a 0-day exploit to a click-happy user.

* https://blog.ipspace.net/2011/12/is-nat-security-feature.htm...

You may wish to start thinking beyond the castle-and-moat network security model:

* https://www.cloudflare.com/en-ca/learning/access-management/...

---

IPv4+NAT does not remove any more classes of problems than IPv6+firewall. Firewalls under IPv6 work exactly the same way as they do with IPv4:

An IP connection is started from the 'inside' to the 'outside', and the source-destination tuple is recorded. When an 'outside' packet arrives the firewall checks its parameters to see if it corresponds with an existing connection, and if it does it passes it through. If the parameters do not correspond with anything in the firewall's table(s) it assumes that someone is trying to create a new connection, which is generally not allowed by default, and therefore drops it.

The main difference is that with IPv4 and NAT the original (RFC 1918?) source address and port are changed to something corresponding to the 'outside' interface of the firewall.

With IPv6 the address/port rewriting is not done.† Only state tables are updated and checked.

New connections are not allowed past the firewall towards the inside with either protocol, and only replies to connections opened from the inside are passed through.‡

There's no magical security behind NAT: tuples and packet flags are read, looked up in a state table, allowed or not depending on either firewall rule or state presence.

NAT is not a security feature but a workaround for the lack of IPv4 addresses. The security comes from the state checking.

† It is possible to have private IPv6 addresses using ULA, and then the router/firewall uses NPTv6 to rewrite the prefix (leaving the /64 interface component alone).

‡ Just like with IPv4 (NAT), to allow unsolicited 'new' connections in you have to do do firewall hole punching with (e.g.) UPNP. But by default things are blocked.
> If the showrunners intended it to be unambiguously happy, I feel like they would have omitted that part...

I think this has the same direct purpose as my favourite modern Doctor Who scene but with different larger strategy. To tell the audience something explicitly, because it's not necessarily obvious and otherwise not everybody will have guessed. Often the Doctor understands what's going on and the audience are learning as they go, but in "The Girl In The Fireplace" the Doctor never actually knows why this spaceship chose this girl, in this time. The audience does at the end though, because we pull out to show the spaceship's name.

Both the women know exactly what we're shown at the end of San Junipero. That "Heaven is a place on Earth" in a very literal sense, but while it's explained somewhat, the details aren't mentioned because they'd be clunky as exposition - hence the explicit visualization of the data centre where they're running.

You aren't alone in finding this horrifying, but for Charlie Brooker, myself and a large number of people this is the best case scenario - and since Charlie wrote the show...
This was well recieved, so I thought we might as well master it. https://soundcloud.com/transformance/id-buy-that-song
Per the text: x is a sample (see the tilde symbol) from the density q0; the Jacobian comes from the change of variables in the density. The typesetting could use some work but the definitions are in the snippet you pasted. I agree that people are often sloppy when writing though this is not such a case. If you want to get into this area of research, it still helps to read a bunch, especially the earlier works or review papers, and you tend to pick things up gradually. Some basic math background is required, probably at advanced undergrad level.
Does it report on microplastics too? What about still "unofficial" PFAS
Quantified CSPs are either PSPACE-complete or inside Pi_2
I've heard tell of the place. By chance, did he have a doghouse?
> My question for you is, what is the correct way to use an LLM?

If your application can't accept a large number of users getting the thing to generate any particular kind of text, then there is no correct way to use one.

> How can you accept non trivial user input without the risk of jailbreak?

You can't. If you're worried about it, don't try.
The programmers’ creed: We do these things not because they are easy, but because we thought they would be easy. ;)
My very limited experience with Vietnam officials was that you could avoid bribes, but it was much more convenient to just bribe them.

I was going through the land border from Laos to Vietnam and was told to leave some "coffee money" in my passport on both sides of the border. I think it was either 20k or 50k Dong.

Apparently if you did not do this, you would get seen last and they would stamp it perfectly diagonally in the middle of a fresh passport page to try and ruin that page.

No idea if this was actually true because everyone just paid.
Benchmarking papers are borderline useless. Goodhart’s law is a thing when a measure becomes a target it ceases to be a good measure. That’s why I keep coming back to GPT4. It has the most “magic” and “mind reading ability”. Try to quantify that.
... it says exactly what they are, q0 is an arbitrary density on R^d, and x is a realization from that density, p1 is the transformed density. This is intro graduate level probability.
What Is a Neobank? (2021)
Maybe indium in ITO for those fancy transparent front contacts. Or tellurium in CdTe, supposedly still costeffective compared to “thick” Si cells. I would still give GGP a break it can be tricky to venture even small steps outside ones specialty these days
On the other hand, once they had source code access, does it matter?

People play make believe about this stuff. “The practice I feel strongly about, it’s secure. And the other guy is a moron.” The XZ crisis shows how little credential isolation matters. Maybe even at Google, you could work there and feel very strongly about their security practices, and then governments have access to everything anyway, at the front end proxies or whatever. It’s important to pay attention to security, but I think programmer resources should focus on “cheating,” not “security.”
Show HN: I made a Chrome extension to automatically skips YouTube skippable ad
A chrome extension that can itself detects when there is a skippable ad on a video or a youtube survey and can skip that for you without you wasting time to wait for 5 seconds and click on skip ad.
They let you at least partially separate instructions from data. This is useful for things like "Translate this text to French" - you don't want any instructions in the text you are translating to interfere with that goal.

If this was 100% robust then it would also solve prompt injection, but sadly it isn't.
What’s your hardware? RDS? Nvme storage?
So that’s where the millions of dollars per day of server/gpu time goes to.
I still instruct employees to never use spaces or weird characters in filename because they are a pain when I run into them in a CLI.

I don't foresee that advice ever changing lol
It's especially frustrating that I firmly believe operations is a solved problem, but good luck getting a company to adopt the practices that every other mature tech company has already figured out.
Tesla launches new Long Range rear-wheel-drive Model Y in Europe
Related:

What is a Neobank?:

https://www.nerdwallet.com/article/banking/what-is-a-neobank

List of Neobanks and Digital Banks in the world in 2024:

https://neobanks.app/

Google Search: "List Of Neobanks":

https://www.google.com/search?q=list+of+neobanks
Many servers on Mastodon are also rather aggressive at blocking other "disagreeable" servers. Some even apply this by association, i.e. blocking any server that doesn't block those that they consider inappropriate.
Quick question, you talk about D1 / D10 etc.

Are those postcodes or suburbs or something?
If scalable quantum computers do not exist, we do not need PQC.
Going way back to the start
A new generation of smart robots could take over farm tasks handled by humans [video]
It's also been a while since I had to flex my math muscles and they are quite flabby. I recommend reading things like this slow, they are written by people who know the field forward and backward and aren't supposed to be trivial. If you aren't in the field you got to be a little bit of an active reader.

For example, I also didn't remember why you needed a determinant in the equation you linked so I made a simple example and saw the determinant was there to keep the density normalized, (i.e the indefinite integral of the density = 1).

In this case, the simple example I used was a distribution q0(x) = 1 where x>=0 and x <= 1 (zero elsewhere) and scaling transformation y = ax
Anecdata: I'm a white American who grew up in China and it didn't impact me, nor in my experience most of the kids in my international school. Single adults who go back however are more likely to self select based on attraction.
I have exactly this concern about microplastics.

Can you share your preferred tools for boiling the water? Seems simple enough but at this point I'm very skeptical of online claims, so always prefer something the HN crowd has examined in detail.

I'm in the process of getting rid of my beloved goerge foreman out out concern of the mon sticky surface as well...
You need discoverability to incentivize innovators to add more value, which itself feeds back into the value of the overall ecosystem, etc.

But yes, natural language as an interface requires higher activation energy versus GUI which hampers how much value Alexa Skills (and GPT) can provide.
Perl was a spot on choice for your example.

>> DIY embedded hardware

20 years ago an Arduino was brand new and 50 bucks.

Now any one can get a PCB made. You can do hardware like software (iterative, casual).

This is both silly and amazing!
why is it three logicians? wouldn't it work with just two?
Not to mention that Black Mirror's entire agenda is near-Sci-Fi horror.

The episode is specifically about getting trapped in nostalgia, a non-existent past. Yes, love is found in this pursuit, but so it death. All the music in the show is about living in a box and forgetting about the real world. Other characters talk about forgetting they're in the simulation and they talk about how they live in a graveyard. There's that hole conversation with Greg about how the timelimit exists so people don't kill themselves to permanently leave the world behind and "live" in San Junipero forever.

And I'd expect of all people HN people (computer people) would understand that uploading into a simulated reality is not the same as you entering that reality. Remember, once "you" are data, you can be copied. Then who is the real you. If you can be uploaded without being killed in the process then certainly that entity is not "you," but rather a different entity who has all your memories and is not able to distinguish itself from you. But you are still experiencing your experiences and not their experiences, so you are different entities. It is just an AI double. The promise of an afterlife is no different than the promises of old. A story to help you move on, to help you find comfort in the end. But this story is just more tangible for those who are left. San Junipero is not much different from many of the other stories who approach this topic. Even the happier Upload is quite dystopian between the lines of being a rom-com. It is that happiness that is the dystopia itself, the lure of false promises. The poisoned desert so sweet and tempting it is impossible to not take a bite.
The other big difference is that opinions were isolated not just by geography, but also by social spheres. These days, a casual remark on social media can blow up very quickly, resulting in your employer getting flooded with demands to fire you from an angry mob.
Please consider that using an ad-blocking extension without subscribing to YouTube Premium can impact the income of the content creators you enjoy watching. They earn less when ads are skipped or blocked. It’s that’s ethical to you, have at it.
Why is that an appropriate measure? Are chefs sad that none of the meals they created are still around?
> I have yet to meet an infrastructure engineer or even hear of one who switched to IPv6 on purpose because they thought it was better.

T-Mobile US:

* https://www.youtube.com/watch?v=nNMNglk_CvE

Wells Fargo:

* https://www.youtube.com/watch?v=EzTWjNUb4H4

Microsoft

* https://www.arin.net/blog/2019/04/03/microsoft-works-toward-...

* https://www.youtube.com/watch?v=nd0vgU6WbPo

Google:

* https://www.youtube.com/watch?v=hb98hAb5_W8

LinkedIn:

* https://www.youtube.com/watch?v=6ukwR86BClY

Facebook is famously IPv6-only internally (and as of 2016, 60% of user traffic was over IPv6):

* https://www.internetsociety.org/resources/deploy360/2014/cas...

* https://engineering.fb.com/2017/01/17/production-engineering...

* https://www.youtube.com/watch?v=lU_24f6Wr7E
Out of curiosity, which hobby is it?
You just sparked a memory of FILE_ID.DIZ, a standard file included in zip archives during the BBS era.

Pretty sure the .DIZ stood for “Description In Zip”
Puzzling, given the implications of global warming. According to Miami-Dade's own website:

"By 2040, sea levels are expected to be 10 to 17 inches higher than 2000 levels."

By 2100, 1/3rd of the state is projected to be underwater. But long before that, Florida will get way more serious flooding, and far more powerful hurricanes.
UUID primary key remove hotspots; Sequence primary key increase locality.

Depends on your access pattern, you may prefer the other way, even on the same DBMS.
Slightly off-topic, but ‘choosing a PIN’ is an interesting rabbit hole.

Some banks send you a random PIN in a sealed letter.

Other banks have you key in your choice of PIN in various manners (at a branch, online or by phone).

Some banks support changing PIN at an ATM. Others don’t.
I’m sorry, but I can’t take anything seriously from someone who writes articles for The Epoch Times. That’s not a legitimate news outlet.
You're right, there was absolutely nothing to be pessimistic about vis a vis crypto. Nothing bad ever happened there.
The calm writing style of John Wyndham is something I like about his stories. Not much in the way of action or excitement, no vast space opera with many winding threads. World changing ideas, writ small.

Trouble with Lichen is about the discovery of a genuine anti-ageing compound, but we don't see anyone super old or the social consequences. We see the people who discover it and what they choose to do next.

The Outward Urge is a family with several generations of spacemen in it. Nothing really happens, we see a few snapshots of their lives through the decades as human activity out in the solar system increases.

The Midwitch Cuckoos is perhaps the most unexcitingly told story of its kind (no spoilers) but not worse for it.

Web is a nice weaving of ancient curse and modern (1950s) civilisation into an imminent end of the world.
No I ended up going to a university where CS was probably the smallest major on campus. But I worked my ass off to learn CS on my own. The tests wouldn’t have predicted the outcome I’ve been able to enjoy based on scores I received.
To be fair, it doesn't look like he was far off on crypto.

Of course being able to call that doesn't at all automatically translate into also being right about AI.

There's lots of people that have successfully predicted one particular bubble, but all of their other predictions have completely failed to materialize (to say nothing of all the wrong ones they made before striking gold). That's just how selection/survivorship bias works.

In this particular case, I actually suspect that both things can be true at the same time: We're in the middle of an AI hype bubble and >90% of current startups will not survive the next 3 years, but AI will still profoundly change the way we work.

There's even a nice historical analogy: We once had the dot com bubble, in which lots of people lost lots of money, but ultimately, the Internet did turn out to be kind of a big deal. It's just hard to go from that general bet on vibes to one that identifies actual companies that are going to bring about all of that.
It's a great investment pitch for actual conmen, too.

But you can't just invest your way in a successful fraud, in either system. You generally need to also have the political machine protecting you, otherwise the thing will eventually unravel, and 'your' plunder might get clawed back.
Please do write about that.

I've seen so many Alexa projects at hackathons that were exciting at first glance but didn't go anywhere.

My favourite is event recommendations: lots of people try building an Alexa thing to help you find events, but it turns out listening to a bot read out a list of 20 things happening this weekend is way less useful than browsing a web page with the same information all on a screen at once.
There’s a certain type of person that always has to comment whenever anyone says they have it hard by pointing out how actually those problems are nothing compared to X. It’s like a weird obsession with having to win the suffering competition.
> There also isn't one for "w"

There's dub.

Dub-dub-dub is pretty widely understood to mean www.