Scale By The Bay 2018 Unconference: Rob Norris
summary
Skunk is a Scala Postgres client that talks the Postgres wire protocol — no JDBC — and composes with cats-effect, fs2 and nio to give resource-safe sessions, prepared statements and streaming portals. It uses explicit encoders/decoders and symmetric explicit codecs instead of implicit derivation, shows how preparing statements up front avoids double preparation, demonstrates fs2 streaming of query chunks and Postgres LISTEN/NOTIFY for push updates, and surfaces enriched Postgres error reports (position, hint, previous messages) to make schema/type mismatches and runtime failures diagnosable.
AI-written summary · about
chapters (8)
- 0:00Introduction to type-driven mapping
- 2:46Codec composition for migrations
- 7:47Parameter validation with queries
- 13:35Database structure analysis
- 18:01Postgres async notifications
- 22:39Improving error messages
- 29:12Error reporting inspiration
- 32:37Query fragment interpolation
related talks
54mPure Functional Database Programming‚ without JDBC
36mData pipelines engineering made simple with Scala
44mTaking the plunge - a deep dive into streaming with fs2
31mFUNCTIONAL EVENT-DRIVEN ARCHITECTURE
03mScalar Conference 2015 Summary
44mLeveraging Scala And Akka To Build A Distributed Time-series Database
38mScaling Scala
02mScale By the Bay 2021 by Bill Venners