Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Introduction to SQLDelight

Shohei Kawano
May 25, 2016
Programming
1
3.2k

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

Shohei Kawano

May 25, 2016
Tweet

More Decks by Shohei Kawano

See All by Shohei Kawano
Android / Mobile Dev Tips
shoheikawano
0
310
Leveraging KMM in Tapple (JP)
shoheikawano
0
120
Tips for implementing Android Dynamic Feature Module
shoheikawano
1
1.3k
Checking Dependency Updates
shoheikawano
0
85
Tech Strategy for Boosting App Growth(JP)
shoheikawano
3
5k
Dive into AndroidX
shoheikawano
0
130
Touching motif - DI library for Android and Java applications
shoheikawano
1
2.8k
Caching on Bitrise Android
shoheikawano
0
620
Engineer's Work/Pull Request Review(JP)
shoheikawano
0
82

Other Decks in Programming

See All in Programming
JavaでLチカしたい！ / JJUG CCC 2024 Fall LT
nhayato
0
120
Streams APIとTCPフロー制御 / Web Streams API and TCP flow control
tasshi
2
340
みんなでプロポーザルを書いてみた
yuriko1211
0
230
色々なIaCツールを実際に触って比較してみる
iriikeita
0
320
LLM生成文章の精度評価自動化とプロンプトチューニングの効率化について
layerx
PRO
2
180
as（型アサーション）を書く前にできること
marokanatani
4
840
CSC509 Lecture 11
javiergs
PRO
0
180
2024/11/8 関西Kaggler会 2024 #3 / Kaggle Kernel で Gemma 2 × vLLM を動かす。
kohecchi
4
790
プロジェクト新規参入者のリードタイム短縮の観点から見る、品質の高いコードとアーキテクチャを保つメリット
d_endo
1
1.1k
とにかくAWS GameDay！AWSは世界の共通言語！ / Anyway, AWS GameDay! AWS is the world's lingua franca!
seike460
PRO
1
810
Duckdb-Wasmでローカルダッシュボードを作ってみた
nkforwork
0
110
讓數據說話：用 Python、Prometheus 和 Grafana 講故事
eddie
0
390

Featured

See All Featured
Reflections from 52 weeks, 52 projects
jeffersonlam
346
20k
Scaling GitHub
holman
458
140k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
232
17k
We Have a Design System, Now What?
morganepeng
50
7.2k
Mobile First: as difficult as doing things right
swwweet
222
8.9k
Large-scale JavaScript Application Architecture
addyosmani
510
110k
Navigating Team Friction
lara
183
14k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
44
6.8k
GitHub's CSS Performance
jonrohan
1030
460k
The Straight Up "How To Draw Better" Workshop
denniskardys
232
140k
Agile that works and the tools we love
rasmusluckow
327
21k
The World Runs on Bad Software
bkeepers
PRO
65
11k

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

  26. None
  27. None

  28. SQLDelight + AutoValue + Retrolambda

  29. Map Insert

  30. None

  31. SQLDelight https://github.com/square/sqldelight

  32. Delightful Android DB Development shaunkawano fin.