skysight-inc/HackerNews huggingface dataset:
There are only a few ways to determine it before running the query - by the amount of rows/bytes to scan. But most of the logic happens when query is already started - by the possibility to stop it and throw exception if some metrics became too large.

For example, this query will not start, because the amount of rows to scan is greater than the limit: https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...

This query will fail with the error: https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...

Code: 160. DB::Exception: Estimated query execution time (580.1882010677873 seconds) is too long. Maximum: 60. Estimated rows to process: 9946243959: While executing MergeTreeThread. (TOO_SLOW) (version 22.13.1.294 (official build))
Music and Ayahuasca’s Role in Treating Substance Use Disorders in Men
HN is for eminently interesting or important things. This i believe falls into the latter for many people.
I think a statement that there are too many covid shots is fundamentally the same point I made, but feel free to make yourself clear at any time.
I wondered what this should be about.

After all Interactive Theorem Proving is well established and there are great success stories (e.g. Lean Mathlib).

Who needs automatic theorem proving that mimics interactive theorem proving?

After reading the blog posts on the site:

That endeavour is really about understanding what mathematicians do and replace them with an AI.
Wish I could share the enthusiasm. Felt like it wasn’t saying anything interesting. That or I missed the point because much of the dialogue was hard to understand in the theater.
There's football before Pele and after Pele.
For PoC Firebase Authentication

https://firebase.google.com/docs/auth

You get hosted + UI + OAuth

There are many others:

https://supabase.com/docs/guides/auth/overview

https://www.keycloak.org/

https://www.permify.co/

...

..
It's likely a mobile typo for "lots".
"The driver had apparently tricked the car's safety systems. … In the footwell of the car, the officers found what is known as a steering wheel weight … A preliminary investigation into the criminal offense of endangering road traffic was initiated against the Tesla driver."

Sounds more like the driver defeated the safety systems which stop the vehicle if the driver is incapacitated.
Interesting, the status page blocks Mullvad (Edge reports: It looks like api.twitterstat.us closed the connection). Twitter itself works fine. Doesn't seem to be an Atlassian thing, given that Dropbox's status page works fine.
It says producthunt product of the month, but I can't a product page there. The github repository is a week old so I'd assume it was this month.
Haha, I got a great laugh at the end-of-article scroll. Well played!
Yeah, I heard it was about the filter names, but previously had no idea what those filter names actually were. If they're common, obvious names like "blur" and "enhance", then I doubt Instagram would have a case, but if they're really the same as Instagram's, and Instagram's filters are indeed those on https://picturepan2.github.io/instagram.css/ , and those names originated with Instagram, then Pixelfed needs to come up with some good names of their own, and fast.

I'm a big fan of all the open source Fediverse platforms, but copying these sort of unique names is rather obviously a bad idea.
So? Acting like Musk is making a point on behalf of LGBT people is so incredibly disingenuous it speaks to your character as a liar no different from Musk himself. There's a world where it's possible that could be what he meant, but it's not the one we are living in! Look around.
I suspect a lot of commenters will miss this part, so it's probably good to emphasize it.

> In the footwell of the car, the officers found what is known as a steering wheel weight, which is used to trick the security systems. It attaches to the steering wheel and gives the car the illusion that your hands are on the wheel.

This seems pretty clear-cut, and Autopilot's capabilities and other safeguards (or lack therefore of) are irrelevant. The driver was mitigating safety features. It'd be pretty much the same story with adaptive cruise control and lane-keep assist.

At the end of the day, there's only so much you can do to stop someone from shooting themselves in the foot. Once you have to deal with drivers mitigating the driver awareness detection, it's probably a lost cause.
"Slept with parents, eaten by a sabertooth-tiger"

Sorry the statement is not wrong, but it made me laugh a bit, the rates are probably all messy across the years.
Possibly, but that would be 10 of thousands of dollars worth of GPUs.
Can someone clarify this statement from the original nanoID site (https://github.com/ai/nanoid) for me?
"random % alphabet is a popular mistake to make when coding an ID generator. The distribution will not be even; there will be a lower chance for some symbols to appear compared to others."

If random is picked such that it's in the range of alphabet (i.e. 0 to 25), then the bias should not exist, right? Is that what he's alluding to? Thanks in advance.
parents ARE charged with a crime when they crush / axphyxiate the baby to death.

SIDS happens also when baby is alone in bed. You relating it to parents rolling on baby tell me you don't know much about the argument.
Rust is getting there, but I don't think it's production ready yet: https://github.com/esp-rs
> But full time remote is a disaster for junior engineers.

Nonsense. If you have a good boss, you’ll be mentored to success in person or remotely. Source: I’m the boss who’s done that!

Before you say “but but but”, all the buts will point back to a bad boss, who isn’t fixed by in-person presence.
Oh Supreme Court insurance policy doesn't cover ransomware attack on software
In most jurisdictions, you have a legal obligation to pull over when emergency vehicles are operating their sirens. Perhaps they need to pull you over, or perhaps perhaps they just need you out of the way so they can get to some other emergency. If you are selling a vehicle with autopilot/self-driving, then it needs to respond to common driving situations like emergency vehicles.

I am well aware the driver was on drugs and deliberately defeated the safety mechanism. That is not relevant. If s/he had a heart attack or stroke and was slumped over the wheel, the vehicle should still be able to stop in response to emergency vehicles. Sirens and emergency lights are easy to detect, by design.
>Carthage most prominently

They had it coming. The Romans weren't lying about the ritual child sacrifice.
This reminded me of the great song of Sadistik named Petrichor. Great rapper and lyricist. Highly recommended.

https://www.youtube.com/watch?v=un2wO_v35_I
There is a banned commenter who tried to reply to you to point out (without any substantive explanation) that fútbol is the Spanish word, while futebol is Portuguese. So Pelé himself would have referred to his sport as "futebol".
GPT's code and docs for this is way out of date. I tried it a couple weeks ago.
So this guy may have been high, but I've heard of other drivers falling asleep and relying on self driving features.

It is a long, long time before my body would even physically allow me to fall asleep when I'm in the driver's seat. Maybe it's just me, I just wouldn't be able to even if I tried.
If all you're looking for is cheap, you can find action cameras like that for around $20 on Amazon, probably even cheaper through AliBaba or similar.
Possessor is on Hulu... thanks!
To be fair it seems like Southwest management fell for the same trap.
Thanks for sharing your experience. I definitely have given up on marketing/selling my projects after just a month or two of trying.

Going to try a little longer this time.
Wow, a drug user fell asleep at the wheel and the car saved his life and probably other road users by keeping the vehicle operating safely until he woke up? Modern technology is remarkable!
Reporter Says Ukrainian Intelligence Tried to Coerce Her to Write Propaganda
You seem fun
I’ve been revisiting Promise Theory (https://en.m.wikipedia.org/wiki/Promise_theory) and it is interesting to analyze this with PT:

1. Promises are not obligations

2. Promises are best-effort intentions made by autonomous agents, and made known to an audience

3. Assessment of how agents keep promises is local to the observer

4. Only autonomous agents can make promises. If an agent is not capable of making promises, it is not autonomous.

5. Non-autonomous machines and systems are proxies for humans making and keeping promises with each other

6. Tesla’s driver assist technology is a proxy for promise-making humans

7. Tesla, the company, composed of humans, makes certain promises on the safety properties of their cars and driver assist

8. Human drivers are making promises to other drivers, as well as the governing body, in regards to operating the vehicle (with penalties defined by obligations defined by the governing body)

9. Since the driver assist tech is not fully autonomous, it is a proxy for the human driver’s promises, as well as Tesla

10. Therefore, a human driver falling asleep is breaking his promises regarding the operation of the vehicle

11. But Tesla has also made promises on the _autonomy_ of the vehicle.

12. It isn’t so much that the promise (the intention) is false, but that Tesla has not been keeping its promises regarding safety

13. Contrast this Waymo, who spent a lot of effort to make and keep promises about safety, including documenting a framework to work with first responders.
Shouldn't FSD understand how to drive properly when emergency vehicles are approaching from behind? Otherwise an ambulance could get stuck behind a Tesla blocking the road. Or was this just adaptive cruise control?
Those statements are not contradictory. One could easily "have no criminal record" AND "had prior criminal charges"

Record is when you are convicted, while charges are simply that someone somewhere claimed something, but a jury of peers found said claim not certain beyond a reasonable doubt.
Could just be dysfunction, but Musk’s behavior makes it look more likely it’s an intentional lie: his only comments have been “Works for me” in the midst of it [1], and “Significant backend server architecture changes rolled out. Twitter should feel faster.” just after [2].

[1]: https://twitter.com/elonmusk/status/1608273870901096454

[2]: https://twitter.com/elonmusk/status/1608324539779551232
Shocking, does this happen regularly in Germany? Is this something you experienced yourself?
It's been a great run for the past few decades getting improved performance for "free" (i.e. through extremely advanced CPU engineering), and I'm glad they're still able to eek out another generation of hardware improvement. Curious how hitting limits/diminishing-returns in silicon will force innovation in architecture and software. Will be amazing to see the pendulum swing back toward software optimization. So much performance is being wasted or left on the table.
Sounds great but also kind of a bummer this doesn't exist on Windows natively.
> Take a look at a graph of infant mortality rates since time began, chief

Thats cool. I have. But we co-slept anyway because for us the benefits outweighed the risks. Especially while breastfeeding... Raw facts and data alone are not the only things required to make an informed decision on any subject. They only serve as inputs.
Since you often can't return a product that has been worn next to human skin perhaps the companies selling bras have realized that being able to sell more bras until a person figures out the right size is profit? Just one example of where obfuscating size/quantity/other_parameters is used for profit. For example, a "2x4" is actually 1+1/2 inches by 3+1/2 inches? This has been going on since the time of the Egyptians when you had to bring your own scale to the market to weigh goods, and watch out for the thumb on the scale.
After about 15 minutes, the man finally woke up and followed the instructions of the police. During the check, he showed typical drug failure symptoms.

Well, I imagine passing out and driving usually gets people in a more dangerous situation such as a car accident.
Anyone know of a similar search engine that allows the user to filter search results by year?
The return of the car should have its own entry, separate from when the rental expires.

It doesn't mean you shouldn't have a an expiration field.
The ISP is probably blackholing the DNS on their end, and customers who use their DNS by default (everyone) get an nxdomain.
> my own solution that did everything I wanted

Your ideas are intriguing to me and I wish to subscribe to your newsletter!

(I really would appreciate any pointers to additional info on something that actually works...)
The post covers this:

> Our API is a Ruby on Rails application. For all public-facing models, we have added a `public_id` column to our database. We still use standard auto-incrementing BigInts for our primary key. The `public_id` is only used as an external identifier.
Has LibGen already caught up to Z-Library? I thought that was still very much a work in progress.
Only solution is to regulate the companies. Musk is using his army of cultish followers to do QA with other people's lives. In my opinion this should be highly illegal, and prosecuted.

Imagine your kid gets killed by a Tesla influencer trying to prove that autopilot is everything Elon promised them.

[disclaimer] i worked for a while at Cruise, and that company cares deeply about security and works hard with the government to move regulation forward as we move the technology forward.
He also played in NYC for a few years at the end of his playing career for the NY Cosmos.
Even if it wasn't intentional, it's not like he's going to admit it.
I wonder if this is a deliberate attempt to try to claim later there was no Dec. 28 outage. After all, in a year or two the Twitter status page will be considered pretty authoritative in online debates.
I think what we did is much more similar to what you describe, with the crate door left open, so she didn't feel isolated when the other pets and humans were in other rooms. we moved the crate upstairs and left the door to it open, and she took a liking to it as her own space, and would choose to go sleep in it like it was her bedroom (or whatever), but having it at the distant end of the house clearly alone for the sake of isolating her is what I found counterproductive.
As a brazilian football fanatic, who grew with my dad and uncle who are equally fanatics, the "greatest of all time" or "that I have seen" conversation has happened my entire life. For that reason, Pelé is one the human beings I most talked about. It is also surely the football player who stopped before I was even born that I most watched, from entire games I was able to find to movies to clips... just so I could have a better argument at the table with the grown ups... Sad day, RIP.
I don't know how to call this blend of virginiality and pioneering. Being both breaking barriers when there's a lot of barriers to break in a way.
FSD isn't Autopilot. Autopilot does detect emergency lights (in the US at least) but it only slows down.

I've wondered why the car doesn't have detection for approaching cars behind to get out of the way but people say the rear camera angles are not good enough - I think that's a terrible excuse.
A few questions for those familiar with chip production:

1. How much smaller can we make the silicon process before we run into physical limitations? How many years do you think that gives us?

2. What are the most promising alternatives to silicon? Carbon nanotubes, photons? How many years are we realistically away from these being commercially viable?
I read process as meaning the film is about systemic effects in a variety of contexts, as opposed to being plot- or character- driven.

Like, "it's about the journey, not the destination", but one step further, because journey implies people and meaningful events.
Considering that human lives are at stake, shrugging at the issue is not a good solution. I think two solutions are 1) criminal liability for drivers disabling safety features that endanger others (e.g. on traffic stops) and 2) adversarially strengthening against safety workarounds.
Can you get any taste of the supporter features before paying? I opened an account, got 60 activities imported from Strava, I can see them individually from citystrides, but clicking on one of the "Lifemap" buttons just zooms out, and shows nothing on the map.
Further reading:

https://www.justice.gov/usao-sdny/pr/united-states-citizen-p...

https://medium.com/@virgilgr/ethereum-is-game-changing-techn...

https://news.ycombinator.com/from?site=medium.com/virgilgr

https://www.nytimes.com/2008/11/23/magazine/23wwln-medium-t....
> All it takes is for one or 2 strong employees to go off into the dark forest for a while and come back with a potential prize.

I wish there was a more prevalent culture! My most productive work comes about this way, and I've yet to find a job where I'm able to do this regularly.
Seems like your typical instagram vanlifer... how did she make a living to afford all that gear? And I guess being French she at least has socialized healthcare and welfare to fall back on... harder for an American to do, especially later in life :(

Not that I don't admire her -- I wish MORE people could live like that!
A long term world famous name .. his loss resonates weirdly.
Sorry, I still think I am right about the media rarely lying
It does, but it still requires unlocking the session on resume, which is a minor inconvenience if you're just moving to a neighbouring room with a coffee cup in your other hand. Slightly more importantly, sometimes it's also convenient to keep network connections open, e.g. for ssh sessions.

Those aren't really problems, but it can be a minor matter of convenience, and I've set both my work and personal laptops to not suspend when the lid is closed.

I'm not saying that's in any way a better idea than keeping the typical default, and I have absolutely no opinion on what anybody else should do.

FWIW, I also don't care whether macOS gives an option for not triggering sleep when closing the lid, which was the original matter. But I don't agree that there's no reason to close the lid except for suspending.
Modern Javascript: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/c...

For the "task pane", if you need one, you can use React or Angular, but I prefer to use Vue (or no front-end framework is fine too).

For the backend logic, just straight up Node + webpack. You could probably do this better with Vite, but I think Microsoft's starter templates all use webpack.

You end up distributing a manifest file that tells Excel which server your assets and API live at.

Warning: hot reload and dev debugging is quite a pain on macOS.
Thanks heaps, for this. This is really cool and useful!
> Er, if GOG decides to ban you, you'll lose all your stuff on there as well.

Whenever I get a game on GOG, I download and keep a local copy of the DRM‐free installer. If my account got banned, I would lose nothing except access to future updates.

> Steam's DRM is opt-in for developers and there are lists of DRM-free games on Steam

It’s nice that some Steam games lack runtime DRM, but as far as I’m aware every Steam game uses DRM at install time.
There are two factors at play here. The first one is a matter of archaeology. During the majority of the Roman period, most things were written on papyrus (or sometimes slices of wood or wax tablets). (Stone and clay tablets were also used - just not for everyday things.) This was true of the majority of places Rome conquered as well - although those places tended to produce much less writing to begin with anyway. The trouble with papyrus and these other materials is that it doesn't preserve very well, which means that the vast majority of papyrus that archaeologists have uncovered comes specifically from Egypt (because of climate reasons), and may give rise to the impression that Romans eradicated local histories in some places while preserving them in others. Roughly contemporaneous with the decline of the (Western) Roman Empire, parchment became much more common in writing, and parchment preserves much better than papyrus. The timing of parchment's adoption means much more writing survived from late antiquity than earlier periods.

Secondly, while it's true that the Romans weren't particularly interested in preserving local history and culture, that doesn't seem to have been particularly unusual of any civilization throughout antiquity. We don't have evidence for, say, the transmission of Bronze Age inscriptions that were carved into stone. It's actually far more unusual that people preserved Roman stuff!
> Because the JVM had no buffer overflow?

Happens extremely rarely and is frequently not in JVM core code but rather something like the 2d renderer or applets. Code not likely to be executed on a server.

Take a deeper look into those CVEs and count how many are for Java 8+ and server code (it's a pretty short list).

You might as well argue the linux kernel is insecure because there's been buffer overflows in the various drivers.

> Shellcodes could ptrace() and inspect the memory of the program.

Certainly, and they can redirect socket traffic and inject a MITM for any process to directly intercept a password. Even if you are zeroing memory, there will be a period of time when a password is present in memory which means the ptrace attack also works with C.

The bad part of a managed language is that passwords stay in memory for longer, but that risk is somewhat moot considering exploiting requires a compromised system. In which case, there's little reason to pull out passwords by sniffing memory.
They said it was Autopilot, not FSD. So yes, this was just adaptive cruise control.
I also now see Pattinson's involvement in a film as a sign it's gonna at least be worth a watch.

All I can figure is the script and director demanded wooden, bad acting in the Twilight films, for whatever reason.
You can't stop clippy!
This post should have [German] after it.

By the way, I am not sure exactly what happened (I do not speak German) but if the police are worried that a sleeping driver is using autopilot they can drive up with a police car in front of it and gently slow down to a stop in front of it. The autopilot should slow down as well.
That's great to understand: Just messaged :) Totally hadn't thought of the empty-nester persona yet makes a lot of sense - I wonder if it represents a decently sized segment..?
Made readable:

Promise Theory[0] is an interesting way to analyze how autonomous agents make and keep promises. It's interesting to think about how this applies to Tesla's driver assist technology. While the driver assist is not fully autonomous, it is still a proxy for the human driver's promises, as well as Tesla's. For example, when a human driver falls asleep, they are breaking the promises they have made regarding the operation of the vehicle. Contrast this to Waymo, who have taken extra steps to make and keep promises about safety, including having a framework to work with first responders.

[0] https://en.m.wikipedia.org/wiki/Promise_theory
Trading Bitcoin: My Method, and Insight into Renaissance Technologies
I can understand that, but this isn't even a return. The poster presumably will keep it, since it's non-returnable and get a refund.
It's really not that hard to learn the Greek alphabet. It's just 24 letters almost all of which represent sounds common in English. I'm currently learning the devanagari script for Sanskrit, which isn't exactly an alphabet, and it's a much steeper climb, though I think I'm making progress.
> Autopilot's capabilities and other safeguards (or lack therefore of)

The car had an incapacitated driver and no one got hurt! Surely that particular capacity is very relevant here. If all incapacitated drivers had autopilots that drove safely, the world would be a safer place, right?

I really don't understand the resistance to this feature.