The Swyx Mixtape

Slides and Video: https://www.youtube.com/watch?v=O7KVEwNau6w&lc=UgzJimEUXVWtALFbCZF4AaABAg

Watch him on YouTube: https://www.youtube.com/watch?v=GrHfWKeTDEI

Survey

• Fill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!
• Survey context: https://swyx.io/podcast/learn-in-podcast/rss.xml

Source: the HOSS Talks FOSS podcast https://percona.podbean.com/e/all-things-opensource-data-warehouse-percona-database-podcast-w-robert-hodges/

Feedback/Discuss on Twitter: https://twitter.com/swyx/status/1552842592357949440

Survey

• Fill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!
• Survey context: https://swyx.io/podcast/learn-in-podcast/rss.xml

Source: the Analytics Engineering Podcast: https://roundup.getdbt.com/p/aaron-katz-clickhouse (25mins in)

Feedback/Discuss on Twitter: https://twitter.com/swyx/status/1552838644997791744

Survey

• Fill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!
• Survey context: https://swyx.io/podcast/learn-in-podcast/rss.xml

Show Notes

• CMU Database lecture from Robert Hodges at Altinity

Source: the Analytics Engineering Podcast: https://roundup.getdbt.com/p/aaron-katz-clickhouse (2mins in)

Feedback/Discuss on Twitter: https://twitter.com/swyx/status/1552835669373894656

Survey

• Fill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!
• Survey context: https://swyx.io/podcast/learn-in-podcast/rss.xml

More on Clickhouse

Our previous episode on Clickhouse: https://twitter.com/swyx/status/1502129209111576577

HN comments on Clickhouse: https://news.ycombinator.com/item?id=28595419

https://news.ycombinator.com/item?id=26316401 

UPSIDES

* started a 3-node cluster using the official Docker images super quickly

* ingested billions of rows super fast

* great compression (of course, depends on your data's characteristics)

* features like https://clickhouse.tech/docs/en/engines/table-engines/merget... are amazing to see

* ODBC support. I initially said "Who uses that??", but we used it to connect PostgreSQL and so we can keep the non-timeseries data in PostgreSQL but still access PostgreSQL tables in Clickhouse (!)

* you can go the other way too: read Clickhouse from PostgreSQL (see https://github.com/Percona-Lab/clickhousedb_fdw, although we didn't try this)

* PRs welcome, and quickly reviewed. (We improved the ODBC UUID support)

* code quality is pretty high.

DOWNSIDES

* limited JOIN capabilities, which is expected from a timeseries-oriented database like Clickhouse. It's almost impossible to implement JOINs at this kind of scale. The philosophy is "If it won't be fast as scale, we don't support it"

* not-quite-standard SQL syntax, but they've been improving it

* limited DELETE support, which is also expected from this kind of database, but rarely used in the kinds of environments that CH usually runs in (how often do people delete data from ElasticSearch?)
It's really an impressive piece of engineering. Hats off to the Yandex crew.

more

Totally great and simple on a single node.

I looked at a bunch of analytical databases and had a lot that started with "so here's a basic 10 node cluster". Clickhouse installed and worked instantly with decent but not "big" data with no hassle. A hundred million rows with lots of heavy text blobs and a lot of columns, that kind of thing. Happily dealt with triple nested joins over that, and with billions of entries in arrays on those columns didn't bat an eye.

https://news.ycombinator.com/item?id=29098637 

That being said, ClickHouse also has a ton of clever levers you can pull to squeeze out better performance and compression which aren't used by default, such as using Delta/DoubleDelta CODECs with LZ4/ZSTD compression, etc. Not to mention, MATERIALIZED VIEWs and/or the relatively newer feature MergeTree Projections[1]

Our Twitter space: https://twitter.com/i/spaces/1MYxNngopWOxw

Blogpost: https://dx.tips/bill-nye-the-devrel-guy

Our guests:

• Justin https://twitter.com/rothgar
• Micheal https://twitter.com/micheal
• Zack https://twitter.com/ChekTek

Our hosts:

• https://twitter.com/Chau_codes
• https://twitter.com/RealChrisSean
• https://twitter.com/swyx

Survey

Fill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!

New Daily Themes

• Technical notes
• Business notes
• Creator notes
• Health notes

You can always see the backlog of clips live, at https://github.com/sw-yx/brain

Our 2021-2022 Deadpool

## Life

- https://overcast.fm/+olfN7lGho 20 mins social butterfly gary vee problems  + 50 mins introvert strategy
- https://youtu.be/oH9sJrAVeC0 Brandon Sanderson  life advice from 14 mins in. Goals, learn how you work, break it down
- https://overcast.fm/+b1V1guBD8 23 mins greg mckowen virality vs energy
- how to be employee #8 at stripe https://overcast.fm/+sAoIh6me8 have side project - 18mins
- https://overcast.fm/+HhhiZISrU be the driver 18mins

## misc

https://overcast.fm/+IOVdeY 15 mins william hung

https://overcast.fm/+KebtSrIKA 40 mins about twitter epiphanies - naval

3mins browser user agent https://overcast.fm/+LfVNDuulU

## deadpool

- https://designdetails.fm/episodes/7RL459Ke  8 minutes - proof of curiosity - learn in public
- https://constine.substack.com/p/how-the-creator-crisis-forced-artists jack conte on creators vs influencers 20 mins in
- radical transparency lampshading https://podcasts.apple.com/us/podcast/everyone-hates-marketers/id1221256195
- get spencer rascoff interview on satya nadella. user focus not competitor focus
- spencer rascoff on spacs https://overcast.fm/+RWpv4tXUg 1h 35mins
- https://mebfaber.com/2021/05/14/e311-radio-show/ 7 minutes found money found money startups
- https://overcast.fm/+UwBo3_SRA stackoverflow founding story
- calling in https://www.youtube.com/watch?v=xw_720iQDss
- https://overcast.fm/+G72_S1rVA praxeology 2 mins rory Sutherland 17 mins
- https://overcast.fm/+eZyDpkhOo 50 mins metrics on academic honesty
- https://overcast.fm/+rTsVMkQyQ 13 mins how brianne kimmel started as a nobody
- https://a16z-live.simplecast.com/episodes/one-on-one-with-a-and-z-8 pmarca on agi 30 mins
- https://www.3books.co/chapters/22 tim urban love vs like - 1hr 44 mins
- https://player.fm/series/hanselminutes-with-scott-hanselman/design-systems-with-jina-anne what is a design system
- https://www.youtube.com/watch?v=pqeJFYwnkjE debt metaphor
- https://overcast.fm/+OxeYJmQDA 9 mins not a how to - walter isaacson
- https://overcast.fm/+rTsUkMHLE 40 mins mimetic desire
- https://overcast.fm/+b1V2u0abg 40 mins university advice
- https://overcast.fm/+SustHMll0 11 mins how turkey living with hyperinflation
- https://corecursive.com/063-apple-2001/
- 18 mins shipping ipod
- 29 mins tech debt quit story
- 45 mins knowing the stack
- 4 stages if the ownership economy https://overcast.fm/+YNeSoJsXs 36mins
- k8s documentary https://overcast.fm/+B1yJZf4lw 7mins
- bolt guy https://three-cartoon-avatars.simplecast.com/episodes/ep-10-interview-with-ryan-breslow-the-silicon-valley-mob-twilio-insider-trading-and-why-onlyfans-cant-find-investors

yegge corner

 - yegge on salary https://youtu.be/AKBYbZ1tyyc
 - https://overcast.fm/+0TxbP_0Gk what billionaires talk about - CEOs
 - https://overcast.fm/+0TxYQEOhk google works does well 15mins ish tech stuff
 - https://overcast.fm/+0TxbyakyQ 28mins old school gates
 - yegge reminder https://youtu.be/vKmQW_Nkfk8

covid stories

 - https://delian.substack.com/p/operators-ep-27-nilam-ganenthiran how instacart handled covid
 - https://podcasts.apple.com/us/podcast/id1507293907?i=1000471392336 bchesky rescue of airbnb
 - https://overcast.fm/+L0d0r2BYc 20 mins airbnb during covid
 - https://overcast.fm/+noYBB9bCQ airbnb story

crypto corner
- https://overcast.fm/+YNeQU9S5I 8mins loot
- https://overcast.fm/+YNeQU9S5I 25 min what is loot
- https://overcast.fm/+Lzu3yDXyE bored apes
- https://overcast.fm/+FhW-ynXUE 55. mins tether discussion
- https://overcast.fm/+Jy_w5_2iA nifty gateway 
- https://overcast.fm/+eZyAwm28w eth mev 50 mins
- https://overcast.fm/+JmiPv_PrI bitclout first 8 mins
- https://www.youtube.com/watch?v=jwadHC5ha-E bankless ens dao
- https://overcast.fm/+eZyD3MfIg cruptonomicon
- https://overcast.fm/+Ylhm80Z-4 12 mins constitution dao problems. intro https://overcast.fm/+XcSvlJhAs 2mins
- https://overcast.fm/+pN8f_ULnQ 17 mins ken griffin side of constitutiondao
- https://overcast.fm/+QLdt2a4yQ 45 mins condao leader
- https://overcast.fm/+FaxkphON4 32 mins SBF talking about loss covering until 45mins
- https://www.youtube.com/watch?v=Dur918GqDIw&list=WL&index=18&t=244s pseudonymity  balajis
- vitalik what is eth https://overcast.fm/+Q4m6kgTKA 5-10ish mins
- https://overcast.fm/+qdIBj-7hw 20mins the graph 
- https://overcast.fm/+TRbX793DU 32 mins what is dao until 50ish mins
- 6529 https://overcast.fm/+nRGzZ7yqs
- uncovering dao hack https://overcast.fm/+O-dbduSYI

listen to Webjoy: https://webjoy.fm/episode/season-1-episode-4-creating-something-from-nothing-shawn-swyx

Shawn Wang joins the show to talk about his origin story, starting in the finance industry and how feeling like just a code monkey in a system drew him to learn front-end engineering and start working on product development and ultimately become a developer advocate.

We discuss what the career path for a developer advocate might look like, as well as podcast listening tools Listen Notes and Listenbox and how they help allow people to look up and listen to podcasts on their own terms rather than being stuck in a corporate garden.

• FreeCodeCamp
• Listen Notes
• Listenbox
• The Coding Career Handbook
• Shawn's Twitter: @swyx
• Shawn's Website

The first release of this episode had an extremely bad intro from me which I was unable to rescue. So i've just cut it out with no intro at all. Enjoy anyway!

Listen to Switched on Pop: https://switchedonpop.com/episodes/listening-2-britney-gimme-more (15mins in)

https://www.listennotes.com/podcasts/deep-questions/ep-204-deep-life-principles-eiXE038yljd/?t=5061 1hr 20mins in

• The Deep Life
  • Radically shift your life to align yourself to things you value - deep commitment,  with tradeoffs, focused, not vague
  • Practice - Gain insight from doing the thing you want to do (not thinking about it, or reading about it)
  • Career Capital - Have a foundation of Competence - be good at something valuable before you try something different