Dali's DAL - Designing a Data Access Layer Like an Artist
Did you know that Dali’s melting clocks were inspired by the pain of refactoring to support a DB migration? Ok, not really - but they totally could’ve been. Fortunately, there’s a solution: a well-designed Data Access Layer. It separates database operations from the business logic while offering a simplified interface for data interactions, letting each side evolve independently - without melting your sense of time. In this talk, we'll cover key DAL design patterns like Data Access Objects, Repository, and Query Builder, showing how we implemented them at Hud.io to support multiple database technologies and TBs of data ingested daily, simplify queries, and improve code testability. Even our code generation agent is happier! You'll leave with practical implementation strategies and a fresh perspective on bringing artistic vision to technical architecture.
