FloorPlan: Visualize databases' evolution
summary
Grounded claim: an open source Kotlin library automates turning SQLite/Room and SQLDelight schemas into readable ER diagrams and diffs, integrated as a Gradle plugin, CLI and CI job that posts schema changes as GitHub PR comments. It parses Room JSON or DB files via JDBC, converts to DBML, renders with Graphviz into SVG with interactive metadata, and publishes via MKDocs; used across a 20+ Android team with ~15 databases, 200+ modules and unchanged developer workflows.
AI-written summary · about
chapters (9)
- 0:00Introduction to FloorPlan
- 5:51SoundCloud's Android database history
- 12:51Documentation challenges at SoundCloud
- 21:13Introducing FloorPlan tool
- 26:08FloorPlan pipeline architecture
- 31:48Integrating FloorPlan into workflow
- 37:02Visualizing database evolution
- 41:36Key takeaways and future plans
- 46:28Q&A and resources
related talks
19mYour database like you've never seen it before
44mEvolutionary Database Design & Architecture
14mYour database like you've never seen it
50mDirect2DB: Radically simplified app architecture with Kotlin
31mRoom: An SQLite Object Mapping Library
01h 10mReal World Iterative Database Development
36mGet a Room
31mData Unleashed: A Developer's Perspective on Navigating the Architecture Maze