The Swyx Mixtape

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