Introduction to SQLDelight

I have talked about SQLDelight, a library for Android that generates Java models from CREATE TABLE statements.

* https://github.com/square/sqldelight

Transcript

1. Delightful Android DB Development shaunkawano
2. Common DB implementation in Android
3. https://developer.android.com/training/basics/data-storage/databases.html
4. https://developer.android.com/training/basics/data-storage/databases.html
5. https://developer.android.com/training/basics/data-storage/databases.html
6. https://developer.android.com/training/basics/data-storage/databases.html
7. https://developer.android.com/training/basics/data-storage/databases.html
8. https://developer.android.com/training/basics/data-storage/databases.html
9. • Very Boilerplate 
 Static final Strings, ContentValues.. • Java × SQL Mixed up • Very fragile
 “CREATE TABLE”, “INTEGER PRIMARY KEY”
10. →
11. SQLDelight
12. SQLDelight https://github.com/square/sqldelight
13. SQLDelight • Static analysis of your SQL • Completely separated SQL from Java codes • Auto generated Java Models based on SQL
14. Dependency
15. Dependency https://github.com/square/sqldelight
16. Dependency https://github.com/square/sqldelight
17. IntelliJ Plugin https://github.com/square/sqldelight
18. Create .sq File
19. Create .sq File • com/your/package/model/Potatotip.java
20. Create .sq File • com/your/package/model/Potatotip.java • sqldelight/com/your/package/model/ Potatotip.sq
21. Create .sq File • com/your/package/model/Potatotip.java • sqldelight/com/your/package/model/ Potatotip.sq Same package as your model class!
22. Potatotip.sq
23. Completely separated SQL from Java codes sqlidelight/com/your/package/Potatotip.sq
24. Static analysis of your SQL
25. • Auto generated Java Models based on .sq file
28. SQLDelight + AutoValue + Retrolambda
29. Map Insert
31. SQLDelight https://github.com/square/sqldelight
32. Delightful Android DB Development shaunkawano fin.