https://ottertune.com/blog/the-part-of-postgresql-we-hate-the-most The part of PostgreSQL we hate the mostBohan Zhang | Andy PavloApr 26, 2023 “But as much as we love PostgreSQL at OtterTune, certain aspects of it are not
What I Read: SQL order
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 Learn: SQL, Malloy
https://carlineng.com/?postid=sql-renaissance#blog SQL, Malloy, and the Art of the RenaissanceCarlin Eng02.05.2023 “By allowing sub-tables within resultsets, Malloy results are able to faithfully represent the true dimensionality of the underlying data.”