Elixir Mentor Isaak Tsalicoglou on ECTO Modeling
12 snips
Mar 22, 2025 Isaak Tsalicoglou, author of "Northwind Elixir Traders" and former mechanical engineer, shares his journey into software development. He dives into database modeling with Ecto, detailing lessons learned from the Northwind project. Topics include optimizing query performance, managing migrations, and the advantages of using SQLite for learning. Isaak also discusses the challenges of schema changes, agile methodologies, and the interplay between hardware and software in product design. His insights offer practical wisdom for both new and seasoned developers.
AI Snips
Chapters
Transcript
Episode notes
Model Databases Incrementally
- Start with a clear ERD and implement incrementally rather than following only happy-path tutorials.
- When you change schema design, test consequences and refactor with small, controlled steps.
Import Order Bug Led To DFS Implementation
- Isaac wrote an algorithm to import tables in dependency order and later found a bug.
- He implemented a depth-first search in Elixir to determine correct import ordering.
GenServer Overuse Taught Bottleneck Limits
- Isaac built a Phoenix LiveView directory over six weeks and overused GenServer patterns initially.
- He learned GenServer bottlenecks when everything went synchronously through a single server.