SQL – Page 3 – Andrew Fairless, Ph.D.

What I Read: Dataset-Centric Visualization

By Andrew Fairless on May 23, 2022April 25, 2022

https://preset.io/blog/dataset-centric-visualization/ DATA ENGINEERINGThe Case for Dataset-Centric VisualizationMaxime BeaucheminMarch 30, 2022 “Different BI tools offer different approaches to building dashboards. On one end of the spectrum, you have tools that prescribeContinue readingWhat I Read: Dataset-Centric Visualization

What I Read: marketplace ranking infrastructure

By Andrew Fairless on March 15, 2022January 20, 2022

https://craft.faire.com/building-faires-new-marketplace-ranking-infrastructure-a53bf938aba0 Building Faire’s new marketplace ranking infrastructureSam KennyNov 3, 2021 “At Faire, all three of these core surfaces are powered by one unified ranking infrastructure that we refer to internallyContinue readingWhat I Read: marketplace ranking infrastructure

What I Read: Against SQL

By Andrew Fairless on September 1, 2021August 17, 2021

https://scattered-thoughts.net/writing/against-sql/ Against SQLJamie BrandonLast updated 2021-07-09 “The core message that I want people to take away is that there is potentially a huge amount of value to be unlocked byContinue readingWhat I Read: Against SQL

What I Read: Understanding Key-Value Databases

By Andrew Fairless on April 29, 2021April 10, 2021

https://www.kdnuggets.com/2021/04/nosql-explained-understanding-key-value-databases.html NoSQL Explained: Understanding Key-Value DatabasesBy Alex Williams, Hosting Data UK “Among the four big NoSQL database types, key-value stores are probably the most popular ones due to their simplicityContinue readingWhat I Read: Understanding Key-Value Databases

What I Read: How Build Production Workflow SQL

By Andrew Fairless on February 22, 2021January 27, 2021

https://shopify.engineering/build-production-grade-workflow-sql-modelling How to Build a Production Grade Workflow with SQL Modellingby Michelle Ark Data Science & EngineeringNov 19, 2020 “We’ll show you how we moved to a SQL modelling workflowContinue readingWhat I Read: How Build Production Workflow SQL

What I Read: Why is dbt important?

By Andrew Fairless on February 12, 2021January 14, 2021

https://stephen.sh/posts/why-is-dbt-so-important Why is dbt so important? “Last summer, we migrated Monzo’s entire analytics infrastructure to dbt from a homegrown solution. This took significant effort, but I’m glad we did it.Continue readingWhat I Read: Why is dbt important?

What I Read: Architectures for Modern Data Infrastructure

By Andrew Fairless on February 4, 2021January 10, 2021

https://a16z.com/2020/10/15/the-emerging-architectures-for-modern-data-infrastructure/ Emerging Architectures for Modern Data Infrastructureby Matt Bornstein, Martin Casado, and Jennifer Li “We’re now starting to see the rise of massive, complex systems built around data – whereContinue readingWhat I Read: Architectures for Modern Data Infrastructure

What I Read: Developers Databases

By Andrew Fairless on December 21, 2020December 9, 2020

https://medium.com/@rakyll/things-i-wished-more-developers-knew-about-databases-2d0178464f78 Things I Wished More Developers Knew About DatabasesJaana B. DoganApr 21 “In data-heavy systems, databases are at the core of system design goals and tradeoffs…. I’m sharing a fewContinue readingWhat I Read: Developers Databases

What I Read: Strictly-Typed Schemas

By Andrew Fairless on December 14, 2020December 1, 2020

https://www.kdnuggets.com/2020/02/loving-memory-strictly-typed-schemas.html In Loving Memory of Strictly-Typed SchemasPrateek SanyalFeb 13 “Today, as I lead a team of highly skilled data engineers, it pains me to watch our sprints get crowded withContinue readingWhat I Read: Strictly-Typed Schemas

Tag: SQL