Colby Rabideau

33 Followers
95 Following
49 Posts

@hotdogsladies I've got one for you. Laura Stevenson was my introduction to Jeff Rosenstock. They're buds

https://open.spotify.com/playlist/6aac4pW5V1OwlhkjYyPHXd?si=feYTxUgpT867jr1pMdR5Og

A Gentle Introduction to Laura Stevenson

Playlist · colbyr · 7 items

Spotify

Hey Seattle Tech Folks! I've been helping to run a "build tools" meetup here. So far this meetup is very informal: simply gathering at a place and chatting, but in the fall we hope to host a meetup with talks. That's partially the purpose of the June meetup: to brainstorm ideas for talks!

We're meeting Wednesday, June 12th at Fremont Brewing, hopefully outside, weather willing. If you're interested please RSVP here so I can make sure we have enough space.

https://www.eventbrite.com/e/seattle-build-enthusiasts-meetup-summer-edition-tickets-895722870217

Seattle Build Enthusiasts Meetup - Summer Edition

A meetup all about builds, build tools, build speed, monorepos and the people who care a lot about them!

Eventbrite
The Radiolab about how they mapped Chinese characters onto a QWERTY keyboard is such a good one
https://overcast.fm/+E79ivp0u8
The Wubi Effect — Radiolab

When we think of China today, we think of a technological superpower. From Huawei and 5G to TikTok and viral social media, China is stride for stride with the United States in the world of computing. However, China’s technological renaissance almost didn’t happen. And for one very basic reason: The Chinese language, with its 70,000 plus characters, couldn’t fit on a keyboard. Today, we tell the story of Professor Wang Yongmin, a hard headed computer programmer who solved this puzzle and laid the foundation for the China we know today. Episode CreditsReported by - Simon AdlerProduced by - Simon AdlerTHE DETAILS TO SIMON ADLER’S LIVESHOW!For People in ChicagoSimon will be performing at the Chicago at the Frank Lloyd Wright Unity Temple on Saturday, September 30th (https://zpr.io/jePmFHyKUqiM).For People in BostonSimon performs at the WBUR City Space on Friday, December 8th (https://zpr.io/jePmFHyKUqiM). Our newsletter comes out every Wednesday. It includes short essays, recommendations, and details about other…

And there's a helpful hint safely testing for cycles by setting a `LIMIT` on the outer query which stops the recursive CTE evaluation after it reaches the limit like...

```
WITH RECURSIVE t(n) AS (
SELECT 1
UNION ALL
SELECT n+1 FROM t
)
SELECT n FROM t **LIMIT 100**;
```

The `UNION` takes care of cycles in a lot of cases, but there are examples of how to handle cycles manually when it doesn't... and again there's built-in cycle detection syntax too.
https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-CYCLE
7.8. WITH Queries (Common Table Expressions)

7.8. WITH Queries (Common Table Expressions) # 7.8.1. SELECT in WITH 7.8.2. Recursive Queries 7.8.3. Common Table Expression Materialization 7.8.4. Data-Modifying …

PostgreSQL Documentation
The docs walk through selecting results in breadth first or depth first order by hand but also theres built-in syntax for it.
https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-SEARCH
7.8. WITH Queries (Common Table Expressions)

7.8. WITH Queries (Common Table Expressions) # 7.8.1. SELECT in WITH 7.8.2. Recursive Queries 7.8.3. Common Table Expression Materialization 7.8.4. Data-Modifying …

PostgreSQL Documentation
Trapped on a plane waiting to take off and reading the #postgres docs. We built half the good stuff in @metaplane with recursive queries (https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-RECURSIVE), but there are deeper bits that I didn't know about.
7.8. WITH Queries (Common Table Expressions)

7.8. WITH Queries (Common Table Expressions) # 7.8.1. SELECT in WITH 7.8.2. Recursive Queries 7.8.3. Common Table Expression Materialization 7.8.4. Data-Modifying …

PostgreSQL Documentation
I get my best results when I design in the work itself. There’s only so much you can do before you try to make the a thing for real.

Ooooh! a schematic. I can't wait to check out all the details and see how it wor--

--damn you midjourney!! I've been foiled again!!

Is there a better way to debug #typescript errors in #vscode than the mouse over dialog thing? It’s so small and they get so long sometimes 😞