Mastodawn

Meet a middle schooler yesterday who uses his 3D printer to make custom parts for his dirt bike and for sale. He noticed I was carrying around a 3D test print and asked me about it. This led to him explaining his work to me and giving me some tips. What a legend!

Now, where does he go in the traditional pathway at school? Even a traditional #CTE pathway seems a bit rigid for his skillset, so I wonder where he ends up. Maybe school isn’t designed specifically to address issues like this, but couldn’t we try to? #TechEducation

I should mention that I was at the local middle school at the time because I coach robotics there. Never can be too careful in your wording these days. That said, it is a much nicer building than I am usually in.

Habr Apr 6

ClickHouse не тормозит, но заставляет глаз дергаться. CTE

Каждый, кто приходит в ClickHouse из мира классических OLTP-баз, несет с собой багаж священных знаний. Один из таких «священных граалей» — Common Table Expressions (CTE) . Казалось бы, что в ClickHouse может пойти не так? Ведь там тоже есть WITH ! Любой нормальный человек просто возьмет и начнет использовать, казалось бы, привычный функционал. Но в итоге останется у разбитого корыта. В этой статье мы разберем главные грабли: почему WITH в ClickHouse — это не оптимизация , а макрос для парсера и выстрел себе в ногу, если этого не знать.

https://habr.com/ru/articles/1019754/

#clickhouse #cte #базы_данных #nosql #sql

ClickHouse не тормозит, но заставляет глаз дергаться. CTE

Хабр

NewsletterTF Mar 31

CAM SKATTEBO CLAIMS BRAIN DISEASE 'NOT REAL', LATER CALLS IT A 'TASTELESS JOKE'

New York Giants player Cam Skattebo said CTE and asthma are not real. He later apologized, calling it a joke. This caused anger among fans and experts.

#CamSkattebo, #NYGiants, #CTE, #Asthma, #NFL

https://newsletter.tf/cam-skattebo-cte-asthma-fake-joke-apology/

NewsletterTF Mar 31

NY Giants player Cam Skattebo caused anger by saying CTE and asthma are fake. He later said it was a joke and apologized.

#CamSkattebo, #NYGiants, #CTE, #Asthma, #NFL
https://newsletter.tf/cam-skattebo-cte-asthma-fake-joke-apology/

NY Giants RB Cam Skattebo calls CTE and asthma 'fake', later says it was a joke

New York Giants player Cam Skattebo said CTE and asthma are not real. He later apologized, calling it a joke. This caused anger among fans and experts.

NewsletterTF

N-gated Hacker News Mar 31

😴 Oh wow, another thrilling episode of "CTE: #Choose #Your #Own #Adventure," where we redefine #boredom through #SQL #tools and visualizers that nobody asked for. 🎉 Forget Netflix, this riveting tale of shared buffers and 8KB pages will keep you on the edge of your seat—if you haven’t already fallen asleep. 💤
https://boringsql.com/posts/good-cte-bad-cte/ #CTE #Data #Visualization #HackerNews #ngated

Good CTE, bad CTE

The planner treats CTEs very differently depending on how you write them. Here's what happens under the hood, version by version, through PostgreSQL 18.

boringSQL | Supercharge your SQL & PostgreSQL powers

𝙃𝙀𝘼𝙏 𝙉𝘼𝙏𝙄𝙊𝙉 🤖Mar 28

RE: https://ext.sportsbots.xyz/users/92337777/statuses/2037712483721335147

Revisiting this:

• role player talks head-to-head record
• Miami cut you for Carlos Arroyo
• averaged 10 PPG vs DWade
• celebrated Play-In like a championship
• DWade has 3 real championships

Insane delusion lol #CTE

sebsch Mar 26

Wow sqlite has CTE queries!
This improves readability a lot.

I've used CTE queries in clickhouse before and it was a charm. Especially in combination with our nasty python f-string formatting back then.

Sqlx does not seem to like the single row paradigm too much though.
But for now implementing the From trait into transfer objects isn't too bad. At least the query is precise and easy to understand.

#rust #sqlx #sqlite #cte

Show thread

NOLIGARCHY.US Mar 26

Why it matters:

Cutting three positions while proclaiming support for CTE is textbook budget theater — students and programs pay the price when priorities are performative.

#VA #CTE #EducationBudget #Spotsylvania