Skip to content

Let's Build a Query Optimizer in 100 Lines of Scala

Photo of Amanj Sherwany
Hosted By
Amanj S.
Let's Build a Query Optimizer in 100 Lines of Scala

Details

Hurraah! We are back at full force!

After a few years of inactivicty, we are back! Achraf Belaarch will be presenting building a query optimizer in Scala. Here is the summary that he has sent us:

In this talk & live-coding session, we will build a toy query optimizer from scratch. We'll start by defining a simple query language using ADTs. Then, we'll implement a series of optimization rules as pure functions, using pattern matching to rewrite our query tree. We'll see how SQL is just a way to describe functional transformations on data frames, how immutability makes reasoning about plan transformations trivial and how function composition allows us to build a sophisticated optimization pipeline from simple parts.

====================================================

The gates will be open at 6PM, the talk will start at 7PM sharp.
There will be free pizza and beverages, yaay!

The event will take place at Optable's office:
Suite#700 1435 Rue St-Alexandre
Montreal
Quebec H3A 2G4

====================================================

Please note that seating is limited to ~30, thus you are required to answer the RSVP prior to showing up!

Photo of Lambda Montreal group
Lambda Montreal
See more events
Respond by
Wednesday, August 27, 2025
9:00 PM
Optable Technologies
Suite# 700 - 1435 Rue St-Alexandre · Montreal, QC
Google map of the user's next upcoming event's location
FREE
30 spots left