Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Windows Phone 7 と SQLite
Search
Takuya Shibata
PRO
November 06, 2010
Technology
0
250
Windows Phone 7 と SQLite
第52回CLR/H勉強会で発表したLTのスライドです。
Takuya Shibata
PRO
November 06, 2010
Tweet
Share
More Decks by Takuya Shibata
See All by Takuya Shibata
アップデート紹介:AWS Data Transfer Terminal
stknohg
PRO
0
390
CloudFrontの継続的デプロイを試してみたはなし
stknohg
PRO
0
1.3k
Snapshot & Backup
stknohg
PRO
0
3.9k
AWSエンジニアのためのActive Directory入門
stknohg
PRO
1
3.1k
EC2 Image Builder
stknohg
PRO
0
450
Windows on AWS の “基礎”
stknohg
PRO
0
780
Azure Dedicated Host と2019年10月1日からのライセンス改定のはなし
stknohg
PRO
0
510
Windows on AWS 入門
stknohg
PRO
0
560
普通の人が普通にブログを継続するためにやっていること
stknohg
PRO
0
770
Other Decks in Technology
See All in Technology
面倒な作業はAIにおまかせ。Flutter開発をスマートに効率化
ruideengineer
0
390
いつの間にか入れ替わってる!?新しいAWS Security Hubとは?
cmusudakeisuke
0
140
OpenTelemetryセマンティック規約の恩恵とMackerel APMにおける活用例 / SRE NEXT 2025
mackerelio
2
790
VS CodeとGitHub Copilotで爆速開発!アップデートの波に乗るおさらい会 / Rapid Development with VS Code and GitHub Copilot: Catch the Latest Wave
yamachu
2
190
MobileActOsaka_250704.pdf
akaitadaaki
0
170
Contributing to Rails? Start with the Gems You Already Use
yahonda
2
110
ABEMAの本番環境負荷試験への挑戦
mk2taiga
4
310
関数型プログラミングで 「脳がバグる」を乗り越える
manabeai
2
210
American airlines ®️ USA Contact Numbers: Complete 2025 Support Guide
airhelpsupport
0
390
How to Quickly Call American Airlines®️ U.S. Customer Care : Full Guide
flyaahelpguide
0
150
AWS CDK 入門ガイド これだけは知っておきたいヒント集
anank
3
290
事例で学ぶ!B2B SaaSにおけるSREの実践例/SRE for B2B SaaS: A Real-World Case Study
bitkey
1
160
Featured
See All Featured
Optimizing for Happiness
mojombo
379
70k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
161
15k
How STYLIGHT went responsive
nonsquared
100
5.6k
Git: the NoSQL Database
bkeepers
PRO
430
65k
Scaling GitHub
holman
460
140k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
970
YesSQL, Process and Tooling at Scale
rocio
173
14k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
7
740
Navigating Team Friction
lara
187
15k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
Site-Speed That Sticks
csswizardry
10
690
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
233
17k
Transcript
8JOEPXT1IPOFͱ42-JUF ૉఢͳ͓ͻ͛
ࣗݾհ ¨ H/N : γόλ(ૉఢͳ͓ͻ͛) ¨ Twitter : @stknohg ¨
Blog : http://d.hatena.ne.jp/stknohg/ ¨ ࡳຈͰಇ͘SIerͰ͢ɻ ओʹಓاۀͷجװγεςϜͷઃܭɾɾอक ʑ͍Ζ͍Ζத్ʹ͍ͬͯ·͢ɻ ࠷ۙαʔόɾσʔλϕʔεߏஙͳͲΠϯϑϥد Γͷࣄ͕ଟ͍Ͱ͢ɻ
εϚʔτϑΥϯͰσʔλϕʔεͱ͍͑…
SQLite ¨ ެࣜαΠτ http://www.sqlite.org/ ¨ ࠷৽όʔδϣϯ3.7.3 (2010/10/31࣌) ¨ ಛ ¤
ύϒϦοΫυϝΠϯ ¤ ϥΠϒϥϦܕͷ1ϑΝΠϧRDBMS ¤ SQL92Λαϙʔτ ¤ Transaction/View/TriggerΛαϙʔτ ¨ ༷ʑͳϓϥοτϑΥʔϜͰར༻͞Ε͍ͯΔ
iPhone/AndroidͰඪ४Ͱར༻Մೳ
iPhone/AndroidͰSQLite ¨ iPhoneͷ߹ libsqlite3.0.dylibϥΠϒϥϦ ¨ Androidͷ߹ android.database.sqliteύοέʔδ
͡Ό͋Windows Phone 7ͷ߹…
ͦͦ ¨ Windows Phone 7ͷετϨʔδͰ σʔλϕʔεΛαϙʔτ͍ͯ͠ͳ͍ ¨ ϕʔεͱͳΔSilverlightࣗମ͕ετϨʔδ ্ͷσʔλϕʔεΛαϙʔτ͍ͯ͠ͳ͍ ¨
ࠓޙͷαϙʔτະఆʁ
Windows Phone 7 ͰͷσʔλΞΫηε ¨ σόΠε্ʹσʔλΛஔ͔ͳ͍ WEBαʔϏε্ʹσʔλΛอଘɾऔಘ ¨ LINQ to
XML ΦϒδΣΫτΛXMLγϦΞϥΠζͯ͠อଘɺ LINQ to XMLͰऔಘ
ͦ͏ݴͬͯσʔλϕʔε͍͍ͨͰ͢…
C#-SQLite ¨ SQLiteΛC#ʹҠ২ ¤ σʔλϕʔεࣗମΛC#Ͱॻ͖͍ͯ͠Δ ¨ Ҡ২ͨ͠ਓNoah Hart͞Μ ¨ Google
CodeͰެ։ http://code.google.com/p/csharp-sqlite/
ಛ ¨ 100%C#Ͱهड़͞Ε͍ͯΔ ¨ ͍͔ͭ͘ͷίϯύΠϧΦϓγϣϯαϙʔτ֎ (SQLITE_THREADSAFEͳͲ) ¨ ੑೳΦϦδφϧͷSQLiteͷ2ഒఔ͍ ʢ࠷৽ͷϕϯνϚʔΫΛͬ͟ͱݟͨײ͡) ¨
Siliverlight༻ͷίϯύΠϧΦϓγϣϯ͋Γ
SilverlightͰ͑ΔͳΒ…
C#-SQLite on Windows Phone 7 (WP7 SqliteClient) ¨ C#-SQLiteΛWindows Phone
7༻ʹվ ¤ C#-SQLiteຊମͷमਖ਼ ¤ Monotouch༻ͷSqliteClient.csΛϕʔεʹͨ͠ϥούʔ ΫϥεΛ࡞ ¨ ࡞ͬͨਓDan Ciprian Ardelean͞Μ ¨ Dan͞Μͷϒϩά(Mobile Development)Ͱެ։ http://sviluppomobile.blogspot.com/2010/03/sqlite-for-wp-7-series-proof-of-concept.html ¨ ߴڮɹ͞ΜͷϒϩάͰհ͞Ε͍ͯ·͢ http://blogs.msdn.com/b/shintak/archive/2010/08/31/10055921.aspx
͜Μͳײ͡ ¨ σʔλϕʔεͷ࡞ ¤ SQLiteConnection.Open()
͜Μͳײ͡ ¨ Transaction/SQL࣮ߦ(Insert) ¤ SQLiteConnection.BeginTransaction() ¤ SQLiteConnection.CommitTransacton() ¤ SQliteConnection.CreateCommand() ¤
SQLiteCommand.ExecuteNonQuery()
·ͱΊ ¨ (ਖ਼ࣜͰͳ͍͚Ͳ)ؤுΕWindows Phone 7 ͰSQLite͑Δ ¨ ެ։͢ΔΞϓϦʹ·ͩ͑ͳͦ͞͏ ¨ SQLiteʹݶΒͣσόΠε্Ͱ༻Ͱ͖ΔRDBMSΛ
αϙʔτͯ͠ཉ͍͠
͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠
͓·͚ ¨ Windows Phone Database http://winphone7db.codeplex.com/ ¨ Sterling Isolated Storage
Database http://sterling.codeplex.com/ ¨ Siaqodb http://siaqodb.com/ ¨ Perst for Windows Phone 7 http://www.mcobject.com/perst Windows Phone 7 Ͱ͑ΔσʔλϕʔεΛ ༗ঈɾແঈΘͣదʹूΊͯΈ·ͨ͠