Compositional, Expressive, Performant Database Queries: Choose 3
summary
Claims use Slick as a typesafe embedded DSL and a new library called Sloppy to build query transformers that compose into a single SQL query so you avoid N+1 round trips. Techniques power a generic RDF-ish layer and an entitlements system that reduced ~300k lines of PHP to ~10k lines of Scala in production. Sloppy itself is not yet production-deployed, compilation and implicit shapes are tricky, and common-table-expression support is missing.
AI-written summary · about
chapters (11)
- 0:00Start
- 0:51Presentation Overview
- 1:30SQL: This is why we can't have nice things
- 7:28Slick example
- 9:07The Cast
- 16:11Abstract Reuse: detour
- 17:48Reuse: Operads
- 20:25Reuse: Solution
- 37:22Sloppy -A Slick Operad Library
- 40:20Slick: The ugly
- 42:10Summary
related talks
43mHow to pretend we don't have a database
43mHow to pretend we don't have a database
37mTyqu: Typesafe SQL Queries in Scala
36mData pipelines engineering made simple with Scala
14mAutomated Translation of Functional Big Data Queries to SQL
52mPolymorphic record types in a lifted enbedding
49mScylla, Charybdis, and the mystery of Quill
26mComposable Queries with Ecto