From SQL to Migratable Functional Code
summary
A practical case study showing how to convert existing SQL code into functional-style code and make that code run against different data sources. It covers the migration approach and implementation details for producing portable, functional queries rather than SQL-specific ones.
AI-written summary · about
chapters (16)
- 0:00Problem introduction
- 1:03Java and JPA solution
- 3:29Scala migration with Slick
- 6:42Code reuse
- 11:33Function composition
- 19:48New service with composition
- 23:09Scala function to class
- 32:55JPA entity adaptation
- 39:31Library setup
- 41:56SQL dependency removal
- 45:25SQL literals vs literals
- 47:07Iterator advantages
- 49:03Spark application
- 50:34Batch processing
- 51:45Streaming integration
- 53:54Summary and conclusions
related talks
45mFrom Imperative to Functional
41mModern SQL: Evolution of a dinosaur
14mAutomated Translation of Functional Big Data Queries to SQL
08mDatabase as Code. Not only migrations
51mFrom Java 7 to Functional Programming
27mFunctional Programming on Top of SQL Engines
01h 00mModern SQL: Evolution of a Dinosaur
30mAn Assessment-to-Adoption Path from Oracle, SQL Server, Sybase, DB2 onto