Approaches for Building Real-Time ML Systems

Heterogenous Maps and Dynamic Case Classes in Scala 3

How Materialize and other databases optimize SQL subqueries

Issue #86

9/8/2021

A Byte of Coding Issue #86
Howdy
Anyone else get frustrated when you're having a discussion with someone on an unfamiliar topic and they litter their speech with technical jargon and acronyms? Maybe I just need to stamp ELI5 on my head (yeah, the irony is intentional). Fortunately our sponsor always explains it like you're five, so check them out (see what I did there?). Anyway here's the issue.

Approaches for Building Real-Time ML Systems

Published: 7 September 2021
Tags: machine learning


Using machine learning in real time is becoming more common place in every industry, from marketing to stock trading. It doesn't come without its own challenges though. In this insightful article, Ben Weber outlines the intricacies of implementing real-time machine learning garnered from his owned experiences.

Read Full Article

Heterogenous Maps and Dynamic Case Classes in Scala 3

Published: 7 September 2021
Tags: scala


With the release of Scala 3 come new features, among which is "Mirror, a new given type that can give you information about case classes". Mark's concise article explores the titular features that are required to programmatically generate new types and use them like normal case classes, with examples of implementations and detailed explanations.

Read Full Article

How Materialize and other databases optimize SQL subqueries

Published: 16 February 2021
Tags: sql


After writing SQL for a while, you start realizing that some queries take A LOT longer than others, especially when you're using CTEs or subqueries. Being a proponent of "do first, read later", I've just developed an intuitive feel. Well now I have an explantion, because Jamie Brandon explains the effect nested loops have on SQL queries, how other databases attempt to replace them, and a deep dive into the approaches of CockroachDB and Materialize.

Read Full Article
Twitter
Website
Thanks for your Support! 

Thanks to supporters like Євген Грицай, Scott Munro, zturak, pek, Emil Hannesbo, and Joe Hill this newsletter is provided to you for (ad) free. If you'd like to also show your support and help out, you can donate on the Patreon page. It's not necessary, but it lets me know that I'm doing a good job and that you're finding value in the content.
Donate Here

Stats (updated daily)

Sent: 1509

Opens: 839

Clicks: 162

Link Clicks Clicks % Unique Clicks Unique Clicks %
How Materialize and other databases optimize SQL subqueries 72 44.44% 62 42.47
Approaches for Building Real-Time ML Systems 61 37.65% 56 38.36
Heterogenous Maps and Dynamic Case Classes in Scala 3 26 16.05% 25 17.12
Today's Sponsor: Retool 3 1.85% 3 2.05

Previous

Back to Issues

Next