The Swyx Mixtape

Watch him on YouTube: https://www.youtube.com/watch?v=GrHfWKeTDEISurveyFill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!Survey context: https://mixtape.swyx.io/episodes/swyx-mixtape-survey-refactor-and-deadpool-swyx

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/1552842592357949440SurveyFill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!Survey context: https://mixtape.swyx.io/episodes/swyx-mixtape-survey-refactor-and-deadpool-swyx

Source: the Analytics Engineering Podcast: https://roundup.getdbt.com/p/aaron-katz-clickhouse (25mins in)Feedback/Discuss on Twitter: https://twitter.com/swyx/status/1552838644997791744SurveyFill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!Survey context: https://mixtape.swyx.io/episodes/swyx-mixtape-survey-refactor-and-deadpool-swyxShow NotesCMU 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/1552835669373894656SurveyFill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!Survey context: https://mixtape.swyx.io/episodes/swyx-mixtape-survey-refactor-and-deadpool-swyxMore on ClickhouseOur previous episode on Clickhouse: https://twitter.com/swyx/status/1502129209111576577HN comments on Clickhouse: https://news.ycombinator.com/item?id=28595419I'd like to thank the creators of ClickHouse as i hope they are reading here. We've been using it since 2019 in a single server setup with billions of rows. No problems at all. And query speeds that seem unreal compared to MySQL and pg.https://news.ycombinator.com/item?id=26316401 Also wanted to share my overall positive experience with Clickhouse.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.moreI'd like to add an upside which is: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 This has been my experience with ClickHouse as well...that is, you can basically close your eyes while writing the schema and still maintain to get extremely impressive performance.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/1MYxNngopWOxwBlogpost: https://dx.tips/bill-nye-the-devrel-guyOur guests:Justin https://twitter.com/rothgarMicheal https://twitter.com/michealZack https://twitter.com/ChekTekOur hosts:https://twitter.com/Chau_codeshttps://twitter.com/RealChrisSeanhttps://twitter.com/swyx

SurveyFill out our 2022 Survey! https://forms.gle/g2s1Np9wS5qmrKSRA!New Daily ThemesTechnical notesBusiness notesCreator notesHealth notesYou can always see the backlog of clips live, at https://github.com/sw-yx/brainOur 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## mischttps://overcast.fm/+IOVdeY 15 mins william hunghttps://overcast.fm/+KebtSrIKA 40 mins about twitter epiphanies - naval3mins 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-investorsyegge 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_Nkfk8covid 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 storycrypto 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-swyxShawn 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.FreeCodeCampListen NotesListenboxThe Coding Career HandbookShawn's Twitter: @swyxShawn'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 inThe Deep LifeRadically shift your life to align yourself to things you value - deep commitment, with tradeoffs, focused, not vaguePractice - 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

Listen to Deep Questions: https://www.listennotes.com/podcasts/deep-questions/ep-184-replay-the-y_ucZrt6CDB/Time Block Plan - give every minute a jobSetup Task Boards - keep track of every task and their statusthis weekambiguousmajor projectswaiting to hear backFull Capture - by end of day - every obligation is out of head, in a trusted systemEmail inboxCalendarTask BoardWeekly Plan - at beginning of each week, build plan for weekblock time for critical thingsinterfaces with daily Time Block PlanStrategic PlanThe Vision for your professional life (for quarter)Vision interacts with weekly planAutomate and Eliminatereduce amounts of context switchesbatch stuff, handing off, outsourcingsay no, leave, step awayGo for ittake really ambitious projects, big swings

Listen to Deep Questions: https://www.listennotes.com/podcasts/deep-questions/ep-169-how-do-i-manage-my-time-gTNFVbZvLQA/Three requirements of time managementCapture: don't store anything in your head. Your ideas, info, commitments, plans.Configure: make effort organizing. Gather relevant info in one place.Control: proactively make a plan for your time in advance: quarterly, weekly, dailyConstrain (bonus!): figure out how to automate, consolidate interruptions with office hoursActual tools usedCaptureworkingmemory.txtshutdown: -> go thru workingmemory -> trello, gdocConfigureseparate kanban board for every role - researcher, etc columns"to be processed""waiting to hear back from""persistent initiatives"daily: just add stuffweekly: reorganize and reviewControldaily, weekly, quarterly, time blocking

Listen to Deep Questions: https://overcast.fm/+b1V3EeycY (8mins in)

Listen to JSParty: https://changelog.com/jsparty/226Reactathon talk: https://www.youtube.com/watch?v=CGnlBU3K_eMIn 2020, Shawn (swyx) Wang wrote:Every 10 years there is a changing of the guard in JavaScript. I think we have just started a period of accelerated change that could in thge future be regarded as the Third Age of JavaScript.We’re now in year three of this third age and Swyx joins us to look back at what he missed, look around at what’s happening today, and look forward at what might be coming next.Notes & LinksReactathonswyx’s talk at ReactathonThe Third Age of JavaScriptLydia Hallie’s talk on rendering patternsanalytics.usa.govThe Birth and Death of JavaScriptThe Rise of WebAssembly (Infoworld)Ryan Dahl on JavaScript containersswyx on The Changelog #467The other thing I like about esbuild is that it’s a static Go binary, so I feel more confident that I’ll be able to get it to work in the future than with tool written in Javascript, just because I understand the Javascript ecosystem

Starter: How Will I Know https://www.youtube.com/watch?v=QOez2zaLHvgSongsTrouty Mouth https://www.youtube.com/watch?v=_zEd9Zioo2USongbird https://www.youtube.com/watch?v=CJUgLEtA-74Girl on Fire https://www.youtube.com/watch?v=3DuVml2-BfwRain on my Parade https://www.youtube.com/watch?v=TvnxXj9K_74Brave https://www.youtube.com/watch?v=py3WJIR-N7cSomeone Like You https://www.youtube.com/watch?v=d3BjcKq5w2AIf I Die Young https://www.youtube.com/watch?v=TlWHTfrGhoYWikipedia: https://en.wikipedia.org/wiki/Death_of_Naya_RiveraCouldn't fit it inDance with Somebody https://www.youtube.com/watch?v=g-Q9AH9ou5A

From the Moth: https://themoth.org/radio-hour/live-from-the-united-palace

https://www.listennotes.com/podcasts/business-breakdowns/mckinsey-company-the-first-pAbhz6JnPGv/ (28mins in)

Listen to SDT: https://www.softwaredefinedtalk.com/365

Acquired: https://www.acquired.fm/episodes/american-dynamism-with-katherine-boyleAll-in Summit: https://www.youtube.com/watch?v=nK0NfL2M5L4

When people ask about how I got started, I send them to this podcast. Here is the audio, edited for ums.source: https://podcast.freecodecamp.org/ep-59-shawn-wang-left-a-350kyear-finance-job-to-learn-to-code

Intro: https://www.youtube.com/watch?v=ysrHJMxgisAConcerto: https://www.youtube.com/watch?v=h7KlnK39Up0

https://www.levelshealth.com/podcasts/one-ceos-81-pound-weight-loss-using-glucose-monitoring-betsy-mclaughlin-casey-means (from 2min - 18mins)

Listen to Levels: https://www.levelshealth.com/podcasts/from-selling-cars-to-building-rockets

Listen to the BranSan pod: https://www.listennotes.com/podcasts/intentionally-blank/titanic-2-sink-harder-TNZRE4xOQvX/ (25mins in)

Listen to the Jorgenson pod: https://www.ejorgenson.com/podcast/solocast-metagames-feedback-loops-and-transcending-the-muggle-world(about 40mins in)

Listen to Purrfect.dev: https://codingcat.dev/podcast/2-21-linking-your-microservices-with-workflowswatch video version: https://www.youtube.com/watch?v=Q0P-Uod19NYReads:https://www.swyx.io/self-provisioning-runtimehttps://www.swyx.io/why-temporal/

The way you make me feelIt's gonna be meYou're the one that I want

Listen to AEP: https://www.listennotes.com/podcasts/the-analytics/coalesce-you-dont-need-9OHhYXco26r/

Listen to Data Brew: https://databricks.com/discover/data-brew/s1-e2-welcome-to-lakehouseEquity 101 for software engs: https://blog.pragmaticengineer.com/equity-for-software-engineers/

- From 30mins in to ep 348: https://www.softwaredefinedtalk.com/348Bonus: swyx segment on ep 347 https://www.softwaredefinedtalk.com/347

From: https://www.listennotes.com/podcasts/drill-to-detail/drill-to-detail-ep-5-2tru1cMz5TI/ (23mins in)

From: https://www.youtube.com/watch?v=iBUkwL9PJ9oSamuel Kim: https://www.youtube.com/c/samuelkimmusic0:00 Imperial March x Duel of The Fates2:55 The Force Theme (Binary Sunset)4:49 Star Wars Main Theme6:27 Rey's Theme8:38 The Mandalorian10:51 Vode An12:40 Droid Army March14:45 The Clones Theme17:10 Ahsoka's Theme

From: https://www.podbean.com/media/share/pb-n2ntb-1208eadit's also on youtube: https://www.youtube.com/watch?v=NqAGxYWgYZk

The Ribbit of the Night: https://www.youtube.com/watch?v=V-L2yXwPVbQThe Muffin Song: https://www.youtube.com/watch?v=QgqLJzmgPs8The Dryer Songhttps://www.youtube.com/watch?v=r_fYAQhpSpwhttps://www.youtube.com/watch?v=ZivIAhxzFyk

Dave: “So you can listen to a baseball game on your computer. Does radio ring a bell?”Bill: “Well Dave, in 27 years you’ll publish this video clip on YouTube.”https://www.youtube.com/watch?v=fs-YpQj88ew

From Bankless: https://www.youtube.com/watch?v=RXHITeaGB8Q (24mins in)

From IGN: https://www.youtube.com/watch?v=vUULNTLw0Ko (8mins in)

listen to the GCP podcast: https://www.gcppodcast.com/post/episode-297-fathers-of-the-internet-with-vint-cerf/

From: https://www.youtube.com/watch?v=DcPeCes4w9Yhttps://history-computer.com/visicalc-of-dan-bricklin-and-bob-frankston-guide

Listen to DevDiscuss: https://devpods.herokuapp.com/podcasts/devdiscuss/episodes/246

Youtube: https://www.youtube.com/watch?v=u3ePPA0yzSU

Listen to the OSS Startup Podcast https://oss-startup-podcast.launchnotes.io/announcements/episode-27-security-operations-at-scale-with-panther-and-from-open-to-closed-source (20min in)

2hrs in to the Lex Fridman pod: https://lexfridman.com/peter-wang/

https://about.sourcegraph.com/podcast/max-howell about 15mins in

Listen: https://www.compressed.fm/episode/6400:00 Introduction02:06 Introducing Swyx03:28 Why Writing?07:16 Priority and Time09:45 Better to be Part-Time Creator than a Full-Time Creator12:16 Do you set up a business entity?13:22 Consistency16:49 Lower the Barrier to Entry21:17 How much do you pay attention to growth?22:37 What is the leading indicator?24:17 Engaging with your Audience25:24 Ratio of One for me, One for Them31:44 Networking34:43 Niching38:04 What's a sustainable action plan for part-time content creation40:23 Getting your stuff stolen41:41 Creating Luck48:31 Community ShoutoutsRead: https://swyx.io/part-time-creator-manifesto

Listen to Tiny Desk Concerts: https://www.youtube.com/watch?v=XfzpYcwiUrA

listen to the Levels podcast: https://www.levelshealth.com/podcasts/one-ceos-81-pound-weight-loss-using-glucose-monitoring-betsy-mclaughlin-casey-means (7mins on)

Watch Wendy's TED talk: https://www.ted.com/talks/wendy_suzuki_the_brain_changing_benefits_of_exercise?language=enListen to Huberman lab: https://hubermanlab.com/dr-wendy-suzuki-boost-attention-and-memory-with-science-based-tools/ (30mins in)

From https://www.youtube.com/watch?v=92kYDVjX0G0

From the Lex pod: https://lexfridman.com/john-abramson/ (1h 57mins in)

I was super honored to join Adam Wiggins (cofounder of Heroku's) podcast to share thoughts on tools for thought, LIP, and Creating Luck.Full show notes on Metamuse: https://museapp.com/podcast/53-career/