arecurrence

I would be careful treating this article as relevant in September 2026. The pace of advancement in the field is such that 6 months is relatively ancient let alone when the models in the study were released. GPT-4o was May 13, 2024. Far before November 2025 when people collectively noticed a turn in LLM value.

LLMs earlier this year were surpassing numerous health related benchmarks when scored against human physicians. Only 2 months after this nature article Harvard posted that LLMs were now outperforming ER docs when given authority to order tests. https://www.harvardmagazine.com/ai/ai-outperforms-doctors-di...

Carney's speech is here https://www.youtube.com/watch?v=b7Y9eFJFZfo

The text of the speech is at https://www.pm.gc.ca/en/news/speeches/2026/09/17/prime-minis...

The wording is such that it sounds like he is pushing a very ambitious portfolio. It appears that the idea is to make this a model for a new alliance that will include other countries over time.

The other deals Canada has made with the EU have been very substantive. CETA was the first major trade deal that the EU passed.

Scott Aaronson remarks in this article that the labs are sitting on a whole pile of incredible results that they cannot figure out how to release given the reception to the Navier-Stokes proof.

One wrench to throw into this is that there are a lot of bugs around Lean and they have been incidentally exploited in the past. Hence, we still need a level of human verification today.

I've worked at companies where we transfer people to Canada during periods like this in the same time zone. Sometimes they enjoy it so much they don't want to transfer back to the US.

Very interesting speech and Q&A from Prime Minister Carney on YouTube https://www.youtube.com/watch?v=Dx9ExdjaREg .

He provides some details about the last minute demands that the US made including restricting Canada's ability to trade with other countries. He also refers to the US signature as being written in "pencil".

Another 10/10 free course is Scotty West’s Absolutely Understand Guitar on YouTube. Filmed in the 90s and it’s still one of the best classes out there.

Sounds similar to HDMI allowing varying levels of specification completeness to all be called the same thing.

The Clickhouse docs are so good that I'd point straight to them https://clickhouse.com/docs/sql-reference/statements/alter/d... .

The reason I mentioned it is because it's a huge surprise to some people that... from the docs: "The ALTER TABLE prefix makes this syntax different from most other systems supporting SQL. It is intended to signify that unlike similar queries in OLTP databases this is a heavy operation not designed for frequent use. ALTER TABLE is considered a heavyweight operation that requires the underlying data to be merged before it is deleted."

There's also a "lightweight delete" available in many circumstances https://clickhouse.com/docs/sql-reference/statements/delete. Something really nice about the ClickHouse docs is that they devote quite a bit of text to describing the design and performance implications of using an operation. It reiterates the focus on performance that is pervasive across the product.

Edit: Per the other part of your question, why inserts create new parts and how they are merged is best described here https://clickhouse.com/docs/engines/table-engines/mergetree-...

Clickhouse has a wide range of really interesting technologies that are not in Postgres; fundamentally, it's not an OLTP database like Postgres but more-so aimed at OLAP workloads. I really appreciate Clickhouse's focus on performance and quite a bit of work goes into optimizing the memory allocation and operations among different data types.

The heart of Clickhouse are these table engines (they don't exist in Postgres) https://clickhouse.com/docs/engines/table-engines . The primary column (or columns) is ordered in some way and adjacent values in memory are from the same column in the table. Index entries span wide areas (EG: By default there's only one key record in the primary index for every 8192 rows) because most operations in Clickhouse are aggregate in nature. Inserts are also expected to be in bulk (They are initially a new physical part that is later merged into the main table structure). A single DELETE is an ALTER TABLE operation in the MergeTree engine. :)

This structure allows it to literally crunch billions of values per second (brutally, not with pre-processing, erm, "tricks" although there is a lot of support for that in Clickhouse as well). I've had tables with hundreds of columns and 100+ billion rows that are nearly as performant as a million row table if I can structure the query to work with the table's physical ordering.

Clickhouse recommends not using nullable fields because of the performance implications (it requires storing a bit somewhere for each value). That's how much they care about perf and how close to the raw data type it is that their memory allocation uses. :)

I've worked at a number of companies using Clickhouse and they all self-hosted. I imagine Clickhouse corporate is focused on large customers.

This is one of the most interesting interviews I've ever read/listened to. Reminds me of when I first heard a Lex Fridman interview (the style is completely different but it hits on a lot of material that is interesting purely due to the openness of the interviewee to talk about whatever and how the interviewer drives the conversation).

If you are at all interested in the current challenges being grappled on in this space, this does a great job of illuminating some of them. Many many interesting passages in here and the text transcript has links to relevant papers when their topics are brought up. Really like that aspect and would love to see that done a lot more often.

I too wish deprecation with migration path was a more common pattern in today's language development. The language has very much needed work and the numerous bugs within Apple's own libraries certainly hasn't helped.

That said, some of the, erm, "new ways" to solve problems have been significant advancements. EG: Async/Await was a huge improvement over Combine for a wide variety of scenarios.

I made a bug like this once where a database default was set to a value evaluated at runtime instead of on every insert. Oops

However, luckily in my case, it was caught immediately in the staging env since collisions caused exceptions.

Realizing when an expression is evaluated is pretty easy to miss. That code is probably live somewhere else right now surreptitiously causing issues.

This is a very well done attack. Enjoyed reading about your efforts to gain community credibility. You rapidly transformed this from a small number of victims into an epidemic.

I'm surprised that VSCode extensions don't have a permissions system (EG: "Request network access").

I don't understand all the hate. I've been listening to this all morning and it's fantastic.

Sure, it's not going to trend on Apple Music... but it's the best we've ever done and a genuine step above previous efforts.

I suspect that's a bug because if you connect Xt to Ht twice... it succeeds.

Edit: This no longer repros and only the correct solution works now from what I can tell.

Yeah, I've written a few of these and should probably release a package at some point but each version has been somewhat domain specific.

The last time we measured an immediate 99% performance improvement over SNS+SQS. It was so dramatic that we were able to reduce job resources simply due to the queue implementation change.

There's a lot of useful and almost trivial features you can throw in as well. SQS hasn't changed much in a long time.

If the iPad could run Mac apps when docked to Magic Keyboard like the Mac can run iPad apps then there may be a worthwhile middle ground that mostly achieves what people want.

The multitasking will still be poor but perhaps Apple can do something about that when in docked mode.

That said, development likely remains a non-starter given the lack of unix tooling.

While this is true, the remaining stores are continuing to capture more business. Users who only make legal source purchases are over 70% of the market now https://globalnews.ca/news/10367758/legal-cannabis-sales-pro...

"Dewdney was a member of the 9/11 truth movement, and theorized that the planes used in the September 11 attacks had been emptied of passengers and were flown by remote control.[13] He based these claims in part on a series of experiments (one with funding from Japan's TV Asahi) that, he claimed, showed that cell phones do not work on airplanes, from which he concluded that the phone calls received from hijacked passengers during the attacks must have been faked."

well... I must admit that was unexpected.

Is this not fraud? Why have users not been able to recoup their funds?

I believe it requires webgl. Can you confirm whether your browser has webgl enabled?

Very cool site. Their 3d models are fascinating to look at. I've often wondered what all goes into the construction of these and while I've seen one off scans in the past... being able to click and scroll around through the slices and whatnot is really cool.

Would be awesome if these were donated somewhere like Wikipedia some day.

Been in a similar environment as an intern. Can concur was worst professional experience of my life. Very glad I experienced this early on to avoid whenever possible for the rest of my days.

Staff couldn't even be disciplined without going through the union rep and everything was based on seniority... with no other reason.

That business no longer exists... its competitors that were non-unionized are still thriving.

Click the reader mode button, makes it far more palatable :)

You can get 1 year global plans from esimdb.com pretty affordably for this use case right now.

This sort of thing is more common with postgres than you'd think. I interviewed a candidate once whose company completely replaced querying in their postgres with elasticsearch because they could not figure out how to speed up certain text search queries. Nothing they tried would use the index.

This is a great idea in that they’ll likely also patch their stuff when they discover the other team has exploited it.

That's actually one of the goals of thunderbolt. With thunderbolt you can be assured of certain capabilities whereas usb-c is increasingly the Wild West.