skysight-inc/HackerNews huggingface dataset:
ClickHouse has the `transform` function for this purpose:

SELECT transform(id, [1, 2, 11], ['ClickHouse', 'Postgres', 'MongoDB'], '')

It creates a lookup table. When you are using the CASE operator, in simple cases it will use the `transform` function under the hood.

There are more advanced capabilities:

- The `Join` table engine. It is a pre-warmed state for joining, a hash table kept in memory.

- Dictionaries. Pre-warmed, automatically updated lookup data structures from various sources. For example, you can connect a dictionary of company names from your operational database while keeping only the ids in ClickHouse.

And, just in case, the same CTE works as in SQLite:

WITH countries AS (
SELECT c1 AS code, c2 AS name FROM VALUES(
('us', 'United States'), ('fr', 'France'), ('in', 'India')))
SELECT data.code, name FROM data LEFT JOIN countries ON countries.code = data.code;

Example:

milovidov-desktop :) WITH countries AS (
SELECT c1 AS code, c2 AS name FROM VALUES(
('us', 'United States'), ('fr', 'France'), ('in', 'India')))
SELECT data.code, name FROM (SELECT 'us' AS code) AS data LEFT JOIN countries ON countries.code = data.code;

┌─code─┬─name──────────┐
│ us │ United States │
└──────┴───────────────┘

Disclaimer: I'm working on ClickHouse.
Yeah, basically.

But that's the story of my life, really.
Dude, we’re talking about explaining away a Tesla failure here.

Pedantic analysis of DMV regulations is absolutely essential. Clearly any dolt practicing defensive driving would anticipate the self driving car cutting him off and hard braking.

Stories like this make people think that full self driving is actually a car the drives itself fully. The car is safer than any human and by critically thinking about this we are preventing sales and essentially killing people, since Tesla has fewer deaths per mile travelled.
I understand it's RV64GCB + a few Z extensions.

As RVA22 is not done (although almost there), we can't know whether it's compliant, but we will once it is. Expectation is yes.

Otherwise, most stuff out there will be RVA20 compliant once that's ratified, as that reflects what was already common back in chips designed in 2020, what most have been calling RV64GC.
Well it’s the only company that charges 20k for “full self driving capability”
Gas or engine failure would have given the cars involved in the crash much more time to react. There probably would have been zero collisions.
Not at all - there's sufficient range in a 32 bit unsigned integer and any values used after the initial assigned values can have details in a lookup table modifiable as time passes.

In actual practice, the Australian Government found it sufficient to expand gender on passports from [M]ale [F]emale to simply include [O]ther (2011) [1].

[1] https://www.theguardian.com/world/2011/sep/15/australian-pas...

[2] https://www.passports.gov.au/getting-passport-how-it-works/d...
The Foundation framework is basically the standard library of Objective C (and thus pretty much the standard library for most of the Apple ecosystem as well).
“Enterprise” product: why spend the resources making something people _want_ to use when you can instead focus on just getting one person (who doesn’t use it) to buy it, then force it on an entire organisation of users.
It's a fairly recent ("recent" = changes every few years) change; your municipality probably hadn't adopted the newest code yet.
I agree with what you said regarding American driving habits, but that doesn't absolve Tesla from its own share of responsibility. The car that was driving in front of the other lane was not following anything; Tesla swerved into its path, so the resulting distance between the cars is on Tesla. What speed would you expect the other car to maintain to avoid such an accident?
The site consistently crashes in Firefox v108.0.2 (64-bit) on macOS Monterey v12.6.
Reuben Scheckter was working in a solar call centre when he decided to ask his boss for a budget to test creating solar leads using Facebook ads instead of cold calling.

He quadrupled the size of that company within 12 months, and from there, his own digital marketing agency was born with his former boss!
It’s also just not realistic. If everyone was that defensive (5+ seconds distance) on such a busy road it would severely lower its capacity, leading to constant traffic jams. Leaving that gap will just mean others taking it.
They are definitely brighter. I had a 2009 Ford Fusion and could barely see the road. Now I have a Mazda and I legit feel bad at how bright they are for other drivers. A lot of cars also now have auto brights, which of course never turn off quite fast enough. I always turn my auto brights off, but my wife doesn’t and it drives me nuts.
I, like some other people, hate all these subscriptions (and prefer local-only where feasible). That’s one of the reasons I haven’t considered Fantastical. But its feature set is indeed a lot richer.
Say what? Pentax ES cameras where made in the 70s and had a good selection of wideangle and telephoto lenses. These were not even new, automatic shutter speed control was.
Well, I'd be talking about things like "I'd like it to be an error if a make rule claims to make a certain dependency and it fails to do so.", like I said in the next sentence.

While we're at it, undefined variables should be errors, not turned into empty strings, and like I said, were I working with it routinely I'm sure I could come up with more. There's a lot more to make than just its shell invocations.

Furthermore, embedding shell's default error handling behavior into make isn't exactly a comforting thing. It's way quirkier than a lot of people understand, and unfortunately it all comes to the surface when people start using make. "It stops at a non-zero exit code!" is, unfortunately, far, far from the simple thing it sounds like.

And encountering the "errors? pshaw, whatever" attitude in multiple languages is precisely why I know it's such a bad idea. Were it just Perl or something, I wouldn't be able to tell if it's a bad idea or if Perl is just a bad implementation, but after the decades I've been using these languages, I've come to the conclusion it's just a bad idea everywhere I encounter it.
This makes me wonder: 1) Does Wikipedia / Wiki* not have a JS pan & zoom tool for graphics like these and 2) Has no one else made something like that just for this graphic?

Asking because the graphical linux genealogy concept / this illustration have been around for a while, as have JS pan & zoom plugins, and it's totally worth having something like this in that format.[1]

Edit: OK, there is Gadget-ZoomViewer (below), but maybe it doesn't work for SVGs? I don't see the option to open ZoomViewer from the Commons image page for this image.

https://zoomviewer.toolforge.org/index.php?f=Quaternary_Geol...

https://commons.wikimedia.org/wiki/Help:Gadget-ZoomViewer

1. See "Expand" tool here: https://digitalcollections.lib.washington.edu/digital/collec...
I'd love to see this in blog post form!

This seems like a case where it would be nice to be able to pass in a parameter `vals (x, y)`.
Language understanding doesn't magically spawn itself as a process on your computer! Someone has to write that program first.

Do you think it's impossible for such a program to emerge as weights in a Turing complete neural network architecture?
Our prayers were answered! I now have the "stop generating" button above the chatbox!!
“… encourage a new industry of medical professionals who specialize in certain areas without unneeded training in other areas.”

Sounds stifling. What’s the problem with holistic training? Except some admin does not want to pay for it?

Extreme division of labor will just create backups for some specialists and time to twiddle thumbs for others.

The opposite across society seems necessary; people need to become more self reliant across contexts. Remove industrial manufacture pipelines so more raw materials are available to the general public and make more holistic and well rounded people.
Energy policy has been the gravest mistake in recent European history and it wasn’t for lack of viable alternatives.

We Europeans like to make fun of Americans, but at least they managed to become energy independent in the same time span. All that we have in Europe is a shrinking industrial base and the largest war on European soil in 80 years (yet I’m sure we will still find a way to feel morally superior to the rest of the world somehow).
What if it is something that is impossible for you to improve?
Well maybe this isn't for teenagers with iphones
This post changed my opinion completely on its matter. This post is one of the greats, I recommend it to anybody
Linux works somewhat, with some duct taped drivers.

Freebsd boots, but that's it.

Of course, as this board is the first large production run, decent spec'd and reasonably compliant <$100 RISC-V SBC, this is expected to improve quickly as they reach developers and quickstart the ecosystem. That's the true intent of this board.

This is an order of magnitude more boards than accumulated RISC-V development boards distributed to date.
Agree, one thing though is some places you want the fresh slice out of the oven, other places you want the reheated slice (as they undercook the pizza with the expectation that it will be reheated later, and may even have to specify you want it “well done”)
> Patients yell, they are demanding, they are untrustworthy.

This gets a lot of comment, but it's half the story. I get most of my medical care abroad, but have escorted family through through local medical visits. I've noticed a marked decline in empathy among medical staff the past few years, even in the secretaries at the front desk. This seems to be a general social trend, not just a problem of bad patients.
Foundation was developed for the needs of EOF so it makes sense there was a version for the Java WebObjects. There's almost certainly NeXT-derived code in macOS/iOS with a longer pedigree and a bunch of it will probably outlast the Foundation rewrite. As software evolution goes, it's an astonishingly long run, no doubt. Especially for a technology that very nearly went extinct.
> autopilot starts braking even slightly and it shouldn't, I immediately take control

I think this is the thing that makes the most sense. But if I were to bend over backwards giving the benefit of the doubt - is it possible the driver feared resuming the previous speed because they were worried the car saw an obstacle that they couldn't?

Like the article suggests - if you're not fully engaged, it's as if you're driving impaired. And there's so much automated that it's difficult to be so vigilant. Once the car starts braking, how much latency can I afford just assessing what caused it to slow down? How hard is it braking and how closely is traffic following me?
Not my intention here. My snarky tone was due to the lack of caffeine in my bloodstream and the number of all-nighter(s) I've been pulling. I apologize if you feel I'm doing any damage to the broader community. Not my objective at all.

I'm honestly deeply interested in why projects choose C++. It's harder to teach to newcomers. I'm guessing this project shares some legacy code with Dolphin?

I'm looking forward to Rust accruing enough tools to attract emulator developers. I'd be happy to put my money where my mouth is and pay for developers via sponsorship that would be willing to undertake this.

I'm currently funding a lot of Rust projects that I like, and I honestly want to accelerate Rust adoption. I don't think there's a harm in that. Big projects like this would generate lots of tools, helper libraries, and other utilities for the broader ecosystem.
That isn't the passing lane as its a bridge (not just a highway) and the left most lane before that area is an exit, so not guaranteed to be the "fast" lane.
The goal is the end product, yes. But there's joy to be had in getting there. And more importantly, I know I won't be able to achieve it without a good feedback loop for iterating on my designs, which means doing at least some machining on my own.

For one thing, sketching out variations on a design typically reveals there's a wide space of possible parameters in the spec. In many cases it's obvious that only a small subset will actually be technically feasible (either for machining or for reasonable functionality of the finished artifact or both), but not obvious exactly what that subset will be.

I'm not even talking about what could be revealed by finite element analysis or other formal methods (though I'm not averse to learning those too). I mean the feel, the taste, and the intuition I can't get from just drawing and doing the math. Like Jackie Stewart said, "You don't have to be an engineer to be be a racing driver, but you do have to have Mechanical Sympathy." I have mechanical sympathy for computing systems, for rapidly narrowing down appropriate design spaces in software projects, but I don't yet have mechanical sympathy for mechanical systems.
Sometimes I wish there was an archive of all the small tips like these

But other days I kind of like the piecemealed nature of sharing "tribal knowledge" when you bump shoulders with others
I don't see how the trailer can force a car to swerve without any loss of traction through skidding.
What you say is correct, except that a hobbyist can source parts from Ebay and the like. Which you could never do for a production machine. That can bring the cost WAY down.
Likely the diagram of the multiphase multi-tape sort diagram that was a foldout in the first edition of TAoCP. As tape fades from memory and usage, the diagram has been removed. It is a sentimental favorite of mine as tape was important in the early part of my career.
People still text? Between Facebook and WhatsApp and some others I rarely send an actual text.
one interesting 'hack' that could be done with an AR headset's output would be its ability to project onto a film which is on the inside of a windscreen, and interacting with the OBD (or whatever the EVs have) and giving a HUD of the available data it received.

This would allow using a [PI/Whatever] to interact with the systems avail to the OBD, slurp that and display onto the HUD-film on the windscreen...

With the ability to display HUD info in even the most analog of vehicles...

(I havent figured out how to make the HUD cheap or safe based on this comment - but in higher-end options, flex OLED film layers on the glass... or a small projector which simply projects onto a semi-opaque area in the lower-center section of the vehicle, with a simple device, pico projector (with a BRIGHT light) onto a smei-opaque sticker above the dash.

Full screen HUD integration is cool, but expensive.

but we have all the tools and resources to make this happen....

Just make sure that Apple 'iWindscreen/shield' never makes it into the wild....

run the PI in the machine, and track your bullshit in a new way (as tied in with vid cams...)

but thats just me and my what ifs...
You’d be surprised how hard it is to find pizza by the slice in many cities in the US
Tesla has much more of an issue with phantom braking than any other manufacturer because they chose to rely only on cameras, and that system simply does not work as well when it comes to this particular issue.

Additionally, how can you blame the driver? Did you watch the video? It's not as if the car slowly stopped. It slammed on the brakes. There wasn't time for the driver to correct for this before the car behind -- which Autopilot had just moved in front of -- slammed into them.

Tesla's Autopilot and Full Self Driving get a lot of focus and criticism for two big reasons; 1) their product names clearly and deliberately paints a picture that the features do not live up to and disclaimers do not fix that. 2) they are unsafe on public roads as they operate today. They are a menace to public safety.
Thanks, I’ll forward that. And yeah, we bring a beefy powerbank anyway.
> because I was doing Ludum Dare this weekend

As a copilot skeptic this is the first compelling use case I've seen. Love it!
Here's my take... if the pizza place isn't covered in little league baseball team portraits and autographed photos from the 90s and earlier, I don't want to hear about it. And who suddenly made it a contest about where there's more better pizza? And since when did Brooklyn become an inner borough? oh since you moved here and decided you needed to find the 'best slice'? Here's a suggestion, go find a new yorker and ask them to take you to their favorite pizza place where they grew up. Go do that, and then tell me how fucking amazing inner brooklyn is. The point isn't that L'Industrie isn't good. The point is that if all you do is go to popular pizza places, because that's what's popular, you don't really get what's awesome about NYC pizza. I'm glad you enjoy the food. But what makes NYC Pizza what it is, is the fact that everyone knows a good spot where they are from. It's all over the city, but folks like you gotta make lists.

Oh, and you heard that Queens has good food too? Wow, we've got Pete Wells over here! Share more secrets.
> Why don't they wander off into some deep national forest land and build their own place?

There’s really nowhere in the lower 48 that fits this description at this point. I’m currently living in MT, and there are plenty of people trying to make this work with trailers, tents, etc. They all get kicked out eventually and often their belongings get taken. If they were growing food, they lose access to it.

> Why do you put assumptions in my writing that are not there? Need a strawman?

You said “I prefer civilization”, implying it’s relevant to the conversation. If it’s not relevant, why say it?

> It does by the simple proof that most people don't just wander out of civilization

People are constantly trying to do this. They can’t without being disrupted by government forces. It’s possible there’s somewhere in the world where you could make a life for yourself without having police called on you, but it’s not easy to find, and the reason it’s uninhabited is probably because it lacks food, habitable weather etc.
Seems like you can safely define it for a single run of any script or anything where you don't need to factor in a timezone change. Unless I've mistaken everything I've read.

To personalize PHP execution I used to putenv("TZ=America/Los_Angeles") for example at the top of a script based on the user's desired timezone. It wound up making all the other time based calls localized which was great.

date_default_timezone_set() is how I do it now, I wonder if it's as efficient (I should strace it)
It's a media campaign. They have agendas and they prosecute them vigorously.
This article is from October 2020.
They should, and I said as much.

It does not absolve the other person from responsibility for not following the required safety protocol. The car in front of them might have had to brake for a perfectly legitimate reason.

I mean, suppose that the other driver was driving while drunk. They might have arrived to their destination safely without the asshole in front, but that's not an excuse against a DUI ticket.
Everyone loves the pizza from where they grew up.
Heck, my $400 vacuum robot has lidar and its advantage when navigating are immediately obvious to anyone paying attention. Rather than cost it feels more like laziness - sensor fusion is hard, so let’s just delete the problem.
In the last example, it seems like it would be nice for the DB to let you omit the `SELECT * FROM` part.
I debated putting in the explicit reference to trains.

But it's funnier if I don't.
That's an oversimplification. Plenty of enterprise tech products are a drastic improvement over what the orgs were doing before (usually no tech).

The problem is the products themselves are usually garbage due to the bureaucratic/"management" driven sales process that adopts the tech, where product development is driven by saying "yes" to every customer's demands.

The good consumer products figure out what people want for a demographic by listening to them (or being them) - but not actually letting them design the software itself by doing everything they ask. Yet there's still plenty of low-quality enterprise software which is miles better than previous 'processes'.
Syscalls can be heavier than expected. One example is when an application is run inside gVisor. Another example is when a lot of eBPF code is attached. A third example is when a program is run under strace.

Disclaimer: I'm working on ClickHouse[1], and it is used by thousands of companies in unimaginable environments. It has to work in every possible condition... That's why we set the TZ variable at startup and also embed the timezones into the binary. And we don't use the glibc functions for timezone operations because they are astonishingly slow.

https://github.com/ClickHouse/ClickHouse/
Not true e.g. I have a large amount of bespoke ISOs/installers/etc I don't want to lose and have to find again but I don't really give a damn if someone got access to them and was able to e.g. install Sim City 4 without my permission. This is even true with a good amount of my unique data. I'm not worried if someone has access to my video game saves or anything in my dotfiles that isn't explicitly crypto (e.g. an SSH key) or so on but it'd be a real PITA to lose those.

I backup a good deal of things but I encrypt only a small subset.
Don't let your out of date[0] knowledge of imatech hold you back.

0. https://www.phoronix.com/news/Open-Source-PowerVR-Vulkan
By the time its close to makes popularity, it will.
Sure you can. C++ has reference-counted garbage collection with its smart pointers and RAII, just like Swift. People certainly write high-throughput systems in C++.

Swift is slower than C++, yes, but not because of its memory management scheme.
How do you plan to compete against

https://autocode.com/
https://pipedream.com/
https://modal.com
https://telefunc.com/
?
Your reasoning seems sort of circular.

I’m sure there have been many technical problems in all of the FAA’s systems in 20 years. And, yes, none have caused a full ground stop. But you seem to doubt it happened because it hasn’t happened before.

Something to keep in mind is the NOTAM system never had an outage like this in those 20 years. And a full ground stop in the event of no one getting NOTAMs is completely reasonable.

So, I think you’re only left with two options: 1. NOTAM system went down by natural failure 2. NOTAM system was taken down intentionally to cause a full ground stop.

I’ll consider them independently then compare. Option 1 to me seems incredibly likely given a long enough timeline. It’s easy to say now in retrospect, but I think an 80% probability of a multi hour outage over 20 years is my best guess. These systems mostly go back to the 60s and are held together with bailing wire and bubblegum.

Option 2 is a hell of a blast radius for not much effect. You want to secretly keep an airplane from flying for a few hours so you… ground every plane in the US? There seem to be easier ways to go about that. Maybe you want no one to be in the air for a few hours? The motivations that would require that are beyond “special operations mission” and into “testing alien technology” territory. I’m not sure this even achieved the goal of putting everyone on the ground. It may have only been takeoffs.

Anyway, I think this comparison is hard. I mean, it’s easy for me. 80% on 1, 0.1% on 2, so 800:1.

But it’s probably hard to change someone’s mind about this. You either think the government is willing to ground every plane in the US for a few hours and lie about it plus has motivation to do so or you don’t. I’m probably not going to sway many people with the argument “yes, these systems are essential and yes, they are shitty” but maybe I will.