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

Room2.1 DatabaseView あるある

494a2760dceccc31c4bcdb689041c614?s=47 Koji Wakamiya
January 28, 2020
Technology
0
280

Room2.1 DatabaseView あるある

494a2760dceccc31c4bcdb689041c614?s=128

Koji Wakamiya

January 28, 2020
Tweet

More Decks by Koji Wakamiya

See All by Koji Wakamiya
FlutterKaigi2021
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
0
570
Flutter?
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
0
120
AAC Paging & Kotlin化の紹介
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
0
770
JavaからKotlinに書き換えてハマる話
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
0
6.8k
CircleCI + fastlaneで快適Androidアプリビルドの巻
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
0
540
夏のDispatchers.Main探検
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
1
850
SDKアップデート is 何
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
0
45
Android Studio 3.5 Betaを プロダクト開発環境に投入して捗っている話
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
1
140
FlutterでAAB配信
494a2760dceccc31c4bcdb689041c614?s=48 d_r_1009
3
730

Other Decks in Technology

See All in Technology
聊聊 Cgo 的二三事
B3a7c0d5c590642dbce68bce8929a2df?s=48 david74chou
0
330
CloudWatchアラームによるサービス継続のための監視入門 / Introduction to Monitoring for Service Continuity with CloudWatch Alarms
107ea34bd4da51e40f1c30b9ca0c459e?s=48 inomasosan
1
430
合同IT企業説明会から学ぶエンジニア向けの広報戦略
Ac0a1eb49d6f0f2f1ce3644941050acb?s=48 nagutabby
1
240
You're M̶u̶t̶e̶d̶ Rooted
Cc23340e1d811f083fb8d2dd1213c42b?s=48 patrickwardle
1
5.9k
ログラスを支える技術的投資の仕組み / loglass-technical-investment
F109e64829df9d89239079d68689c938?s=48 urmot
9
1.9k
eBPF-based Container Networking
98b5759510e487ade4145247bc856366?s=48 johnlin
2
1.1k
Istioを活用したセキュアなマイクロサービスの実現/Secure Microservices with Istio
00851927294532e0742c2c174730dff0?s=48 ido_kara_deru
3
430
SPAとWebアプリケーションでCognitoの使い方はどう変わるのか？ / How do we use cognito with SPA and web applications?
7d75345644fa75da12a5e5215ac2352a?s=48 kitano_yuichi
0
410
データをコネコネ！メール配信用データ生成の仕組み
Cdb7fe48c050935995f8a6a58a5ceba9?s=48 kappezoro
0
120
AWSを使う上で意識しておきたい、クラウドセキュリティ超入門（駆け足版）
Cc073a7c6b0a79918ff1da48acb709e7?s=48 kkmory
0
210
ぼくらが選んだ次のMySQL 8.0 / MySQL80 Which We Choose
A3966f193f4bef226a0d3e3c1f728d7f?s=48 line_developers
PRO
7
3k
ECS on EC2 で Auto Scaling やってみる！
5a6e159c3f74fb7bd85e62efe5f34e2b?s=48 sayjoy
1
260

Featured

See All Featured
The World Runs on Bad Software
20bfe76b3d6105641f879fe45cfc9272?s=48 bkeepers
PRO
57
5.4k
YesSQL, Process and Tooling at Scale
D09fad3e36ae6841f54820be0e907f7a?s=48 rocio
157
12k
Building Adaptive Systems
06f8b41980eb4c577fa40c41d5030c19?s=48 keathley
25
1.2k
Designing Experiences People Love
1b75d89772b7eea1f6c89fbf362607d9?s=48 moore
130
22k
Testing 201, or: Great Expectations
A9704266587836f7e784235e5073b93e?s=48 jmmastey
21
5.5k
The Mythical Team-Month
E6c6e133e74c3b83f04d2861deaa1c20?s=48 searls
210
39k
How to train your dragon (web standard)
053e75a5b48b44d6dd0612795dfb326d?s=48 notwaldorf
60
3.9k
Agile that works and the tools we love
462dad0dd24c568a32dcdb0ae895ae1b?s=48 rasmusluckow
319
19k
Practical Orchestrator
168ccec72eee0530b818d44f3fedaacf?s=48 shlominoach
178
8.7k
The Power of CSS Pseudo Elements
5b6a2bd86ef643786a381a212e0ef2f1?s=48 geoffreycrofte
47
4k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
88f4e84b94fe07cddbd9e6479d689192?s=48 soudai
39
13k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
B3ace07412a5178ea778e7eec161fc0a?s=48 jcasabona
12
940

Transcript

  1. Room2.1 DatabaseView ͋Δ͋Δ ͋Δ͋ΔLTʙ ͓ਖ਼݄ͩΑʂAndroid & iOS߹ಉ େLTେձ ʙ Vol.10

  2. ࣗݾ঺հ • Koji Wakamiya • Studyplus, inc. • @koji-1009 (Github)

    • @D_R_1009 (Twitter, Hatena, etc…) 

  3. DatabaseView ࢖ͬͯ·͔͢ʁ

  4. DatabaseViewʹ͍ͭͯʢ͓͞Β͍ʣ • Room 2.1Ͱ௥Ճ͞Εͨػೳ • Inner/Outer joinΛRoomͰ࣮ݱ • ςʔϒϧΛ͋Δ΂͖ܗʹ෼ׂ͠ දࣔ(View)ʹ߹ΘͤͯσʔλΛ߹੒͢Δ͜ͱ͕Ͱ͖Δ

    

  5. ෳ਺ͷςʔϒϧͱForeignKey • ؔ࿈ͷ͋Δෳ਺ͷςʔϒϧΛѻ͏͜ͱʹͳΔͨΊ ForeignKeyΛར༻͢Δ͜ͱ͕͋Δ • ؔ࿈෇͚Λߦ͏͜ͱͰɺத৺ͱͳΔrowΛ࡟আͨ࣌͠ʹ ଞͷςʔϒϧͷrow΋࡟আ͢ΔͳͲͷߟྀΛߦ͏ 

  6. OnConflictStrategy.REPLACEͰ σʔλ͕ফ͑ͪΌ͏ࣄ݅

  7. OnConflictStrategy • InsetॲཧதʹConflict͕ൃੜ(row͕طʹଘࡏ)ͨ࣌͠ ͲͷΑ͏ͳѻ͍Λ͢Δ͔ΛܾΊΔ͜ͱ͕Ͱ͖Δ • DBͷར༻༻్΍໨తʹ߹Θͤͯར༻͢ΔStrategy͕มΘΔ 

  8. OnConflictStrategy • ABORT (default) • OnConflict strategy constant to abort

    the transaction. • REPLACE • OnConflict strategy constant to replace the old data and continue the transaction. • Ignore • OnConflict strategy constant to ignore the conflict. 

  9. ࣄ݅ঢ়گ • ΞΠςϜςʔϒϧͱΞΠςϜฒͼॱςʔϒϧ͕ଘࡏ • ΞΠςϜ͸ΞϓϦىಈ࣌ʹαʔόʔͱಉظ • @InsertͱOnConflictStrategy.REPLACEͰશσʔλߋ৽ • ฒͼॱͷσʔλ͸ΞϓϦ಺ʹ͔͠ଘࡏ͠ͳ͍ͨΊอ࣋ 

  10. ࣄ݅ঢ়گ • αʔόʔͱΞϓϦ಺DBΛಉظ(ϦϑϨογϡ)͢Δͱ ΞΠςϜϦετ͕දࣔ͞Εͳ͘ͳΔ • ௐ΂ͯΈΔͱʮΞΠςϜʯͷσʔλ͸͋Δ͕ ʮΞΠςϜฒͼॱʯ͕ଘࡏ͠ͳ͘ͳ͍ͬͯΔ • Inner JoinͷͨΊDatabaseView͕ੜ੒͞Ε͍ͯͳ͍……ʁ

    

  11. Ͳ͏ͯ͠σʔλফ͑ͪΌ͏Μ……

  12. REPLACEʹΑΔUpdateॲཧ • REPLACE͸࣮࣭తʹUpdateॲཧʢͩͱࢥ͍ͬͯͨʣ • Conflictൃੜ͠ͳ͍ → ৽نrow࡞੒ॲཧ • Conflictൃੜ͢Δ →

    طଘrowߋ৽ॲཧ 

  13. REPLACEʹΑΔUpdateॲཧ • REPLACE͸࣮࣭తʹUpdateॲཧʢͰ͸ͳ͍ʣ • Conflictൃੜ͠ͳ͍ → ৽نrow࡞੒ॲཧ • Conflictൃੜ͢Δ →

    طଘrowߋ৽ॲཧ طଘrow࡟আॲཧ + ৽نrow௥Ճॲཧ 

  14. REPLACEʹΑΔUpdateॲཧ • طଘrowͷ࡟আ + ForeignKeyʹΑΔؔ࿈෇͚ʹΑΓ ʮΞΠςϜʯͷ࡟আͰʮΞΠςϜฒͼॱʯ͕࡟আ͞Ε͍ͯͨ • @InsertͰ͸ͳ͘@UpdateΛར༻͠ͳ͚Ε͹ͳΒͳ͔ͬͨ • ௥Ճͱߋ৽ॲཧΛϝιουͰ੾Γ෼͚Δ͜ͱͰ

    ͜ͱͳ͖ΛಘΔ͜ͱ͕Ͱ͖ͨ 

  15. υΩϡϝϯτ͸ͪΌΜͱಡΉ ʢ͋ͱɺԣண͠ͳ͍ʣ

  16. Thanks!