https://lukianovihor.medium.com/sql-order-of-query-execution-8c7cd926400 SQL — order of query executionIhor LukianovSep 24, 2023 “To maximize your query’s speed on any SQL engine, it’s essential to have an understanding of the SQL execution order.”
What I Read: Database Disassembly
https://materializedview.io/p/databases-are-falling-apart Databases Are Falling Apart: Database Disassembly and Its ImplicationsChris RiccominiJan 29, 2024 “Why are engineers taking databases apart and putting them back together, again?”
What I Read: Chatbots Understand Text
https://www.quantamagazine.org/new-theory-suggests-chatbots-can-understand-text-20240122/ New Theory Suggests Chatbots Can Understand TextAnil Ananthaswamy1/22/24 “Far from being “stochastic parrots,” the biggest large language models seem to learn enough skills to understand the words they’re processing.”
What I Read: Confidence intervals, balanced accuracy
https://code.groundlight.ai/python-sdk/blog/confidence-intervals-for-balanced-accuracy Tales from the Binomial Tail: Confidence intervals for balanced accuracyTed SandlerSenior Applied Scientist at GroundlightLeo DiracCTO and Co-founder at GroundlightJanuary 16, 2024 “…we put careful thought into measuring the
What I Read: Smooth Noisy Data
https://towardsdatascience.com/the-perfect-way-to-smooth-your-noisy-data-4f3fe6b44440?gi=a6f62aaf2818 The Perfect Way to Smooth Your Noisy DataAndrew BowellOct 25, 2023 “Insanely fast and reliable smoothing and interpolation with the Whittaker-Eilers method.”