Windows Phone 7 と SQLite

第52回CLR/H勉強会で発表したLTのスライドです。

1. 8JOEPXT
   1IPOF
   
   ͱ
   42-JUF
   ૉఢͳ͓ͻ͛
   
2. ࣗݾ঺հ
   ¨  H/N : γόλ(ૉఢͳ͓ͻ͛) ¨  Twitter : @stknohg ¨  Blog : http://d.hatena.ne.jp/stknohg/ ¨  ࡳຈͰಇ͘SIerͰ͢ɻ ओʹಓ಺اۀͷجװγεςϜͷઃܭɾ੡଄ɾอक ౳ʑ͍Ζ͍Ζத్൒୺ʹ΍͍ͬͯ·͢ɻ ࠷ۙ͸αʔόɾσʔλϕʔεߏஙͳͲΠϯϑϥد Γͷ࢓ࣄ͕ଟ͍Ͱ͢ɻ
3. εϚʔτϑΥϯͰσʔλϕʔεͱ͍͑͹…
   
4. SQLite
   ¨  ެࣜαΠτ http://www.sqlite.org/ ¨  ࠷৽όʔδϣϯ͸
   3.7.3 (2010/10/31࣌఺) ¨  ಛ௃ ¤  ύϒϦοΫυϝΠϯ ¤  ϥΠϒϥϦܕͷ1ϑΝΠϧRDBMS ¤  SQL92Λαϙʔτ ¤  Transaction/View/TriggerΛαϙʔτ ¨  ༷ʑͳϓϥοτϑΥʔϜͰར༻͞Ε͍ͯΔ
5. iPhone/AndroidͰ͸ඪ४Ͱར༻Մೳ
   
6. iPhone/AndroidͰSQLite
   ¨  iPhoneͷ৔߹ libsqlite3.0.dylibϥΠϒϥϦ ¨  Androidͷ৔߹ android.database.sqliteύοέʔδ
7. ͡Ό͋Windows Phone 7ͷ৔߹͸…
   
8. ͦ΋ͦ΋
   ¨  Windows Phone 7ͷ෼཭ετϨʔδͰ͸ σʔλϕʔεΛαϙʔτ͍ͯ͠ͳ͍ ¨  ϕʔεͱͳΔSilverlightࣗମ͕෼཭ετϨʔδ ্ͷσʔλϕʔεΛαϙʔτ͍ͯ͠ͳ͍ ¨  ࠓޙͷαϙʔτ΋ະఆʁ
9. Windows Phone 7 ͰͷσʔλΞΫηε
   ¨  σόΠε্ʹσʔλΛஔ͔ͳ͍ WEBαʔϏε্ʹσʔλΛอଘɾऔಘ ¨  LINQ to XML ΦϒδΣΫτΛXMLγϦΞϥΠζͯ͠อଘɺ LINQ to XMLͰऔಘ
   
10. ͦ͏͸ݴͬͯ΋σʔλϕʔε࢖͍͍ͨͰ͢…
11. C#-SQLite
    ¨  SQLiteΛC#ʹҠ২ ¤  σʔλϕʔεࣗମΛC#Ͱॻ͖௚͍ͯ͠Δ ¨  Ҡ২ͨ͠ਓ͸Noah Hart͞Μ ¨  Google CodeͰެ։ http://code.google.com/p/csharp-sqlite/
12. ಛ௃
    ¨  100%C#Ͱهड़͞Ε͍ͯΔ ¨  ͍͔ͭ͘ͷίϯύΠϧΦϓγϣϯ͸αϙʔτ֎ (SQLITE_THREADSAFEͳͲ) ¨  ੑೳ͸ΦϦδφϧͷSQLiteͷ2ഒఔ౓஗͍ ʢ࠷৽ͷϕϯνϚʔΫΛͬ͟ͱݟͨײ͡) ¨  Siliverlight༻ͷίϯύΠϧΦϓγϣϯ͋Γ
13. SilverlightͰ࢖͑ΔͳΒ…
    
14. 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
15. ͜Μͳײ͡
    ¨  σʔλϕʔεͷ࡞੒ ¤  SQLiteConnection.Open()
16. ͜Μͳײ͡
    ¨  Transaction/SQL࣮ߦ(Insert) ¤  SQLiteConnection.BeginTransaction() ¤  SQLiteConnection.CommitTransacton() ¤  SQliteConnection.CreateCommand() ¤  SQLiteCommand.ExecuteNonQuery()
    
17. ·ͱΊ
    ¨  (ਖ਼ࣜͰ͸ͳ͍͚Ͳ)ؤுΕ͹Windows Phone 7 Ͱ΋SQLite͸࢖͑Δ ¨  ެ։͢ΔΞϓϦʹ͸·ͩ࢖͑ͳͦ͞͏ ¨  SQLiteʹݶΒͣσόΠε্Ͱ࢖༻Ͱ͖ΔRDBMSΛ αϙʔτͯ͠ཉ͍͠
18. ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠
    
19. ͓·͚
    ¨  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 Ͱ࢖͑ΔσʔλϕʔεΛ ༗ঈɾແঈ໰Θͣద౰ʹूΊͯΈ·ͨ͠