Slide 1

Slide 1 text

8JOEPXT1IPOFͱ42-JUF ૉఢͳ͓ͻ͛

Slide 2

Slide 2 text

ࣗݾ঺հ ¨  H/N : γόλ(ૉఢͳ͓ͻ͛) ¨  Twitter : @stknohg ¨  Blog : http://d.hatena.ne.jp/stknohg/ ¨  ࡳຈͰಇ͘SIerͰ͢ɻ ओʹಓ಺اۀͷجװγεςϜͷઃܭɾ੡଄ɾอक ౳ʑ͍Ζ͍Ζத్൒୺ʹ΍͍ͬͯ·͢ɻ ࠷ۙ͸αʔόɾσʔλϕʔεߏஙͳͲΠϯϑϥد Γͷ࢓ࣄ͕ଟ͍Ͱ͢ɻ

Slide 3

Slide 3 text

εϚʔτϑΥϯͰσʔλϕʔεͱ͍͑͹…

Slide 4

Slide 4 text

SQLite ¨  ެࣜαΠτ http://www.sqlite.org/ ¨  ࠷৽όʔδϣϯ͸3.7.3 (2010/10/31࣌఺) ¨  ಛ௃ ¤  ύϒϦοΫυϝΠϯ ¤  ϥΠϒϥϦܕͷ1ϑΝΠϧRDBMS ¤  SQL92Λαϙʔτ ¤  Transaction/View/TriggerΛαϙʔτ ¨  ༷ʑͳϓϥοτϑΥʔϜͰར༻͞Ε͍ͯΔ

Slide 5

Slide 5 text

iPhone/AndroidͰ͸ඪ४Ͱར༻Մೳ

Slide 6

Slide 6 text

iPhone/AndroidͰSQLite ¨  iPhoneͷ৔߹ libsqlite3.0.dylibϥΠϒϥϦ ¨  Androidͷ৔߹ android.database.sqliteύοέʔδ

Slide 7

Slide 7 text

͡Ό͋Windows Phone 7ͷ৔߹͸…

Slide 8

Slide 8 text

ͦ΋ͦ΋ ¨  Windows Phone 7ͷ෼཭ετϨʔδͰ͸ σʔλϕʔεΛαϙʔτ͍ͯ͠ͳ͍ ¨  ϕʔεͱͳΔSilverlightࣗମ͕෼཭ετϨʔδ ্ͷσʔλϕʔεΛαϙʔτ͍ͯ͠ͳ͍ ¨  ࠓޙͷαϙʔτ΋ະఆʁ

Slide 9

Slide 9 text

Windows Phone 7 ͰͷσʔλΞΫηε ¨  σόΠε্ʹσʔλΛஔ͔ͳ͍ WEBαʔϏε্ʹσʔλΛอଘɾऔಘ ¨  LINQ to XML ΦϒδΣΫτΛXMLγϦΞϥΠζͯ͠อଘɺ LINQ to XMLͰऔಘ

Slide 10

Slide 10 text

ͦ͏͸ݴͬͯ΋σʔλϕʔε࢖͍͍ͨͰ͢…

Slide 11

Slide 11 text

C#-SQLite ¨  SQLiteΛC#ʹҠ২ ¤  σʔλϕʔεࣗମΛC#Ͱॻ͖௚͍ͯ͠Δ ¨  Ҡ২ͨ͠ਓ͸Noah Hart͞Μ ¨  Google CodeͰެ։ http://code.google.com/p/csharp-sqlite/

Slide 12

Slide 12 text

ಛ௃ ¨  100%C#Ͱهड़͞Ε͍ͯΔ ¨  ͍͔ͭ͘ͷίϯύΠϧΦϓγϣϯ͸αϙʔτ֎ (SQLITE_THREADSAFEͳͲ) ¨  ੑೳ͸ΦϦδφϧͷSQLiteͷ2ഒఔ౓஗͍ ʢ࠷৽ͷϕϯνϚʔΫΛͬ͟ͱݟͨײ͡) ¨  Siliverlight༻ͷίϯύΠϧΦϓγϣϯ͋Γ

Slide 13

Slide 13 text

SilverlightͰ࢖͑ΔͳΒ…

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

͜Μͳײ͡ ¨  σʔλϕʔεͷ࡞੒ ¤  SQLiteConnection.Open()

Slide 16

Slide 16 text

͜Μͳײ͡ ¨  Transaction/SQL࣮ߦ(Insert) ¤  SQLiteConnection.BeginTransaction() ¤  SQLiteConnection.CommitTransacton() ¤  SQliteConnection.CreateCommand() ¤  SQLiteCommand.ExecuteNonQuery()

Slide 17

Slide 17 text

·ͱΊ ¨  (ਖ਼ࣜͰ͸ͳ͍͚Ͳ)ؤுΕ͹Windows Phone 7 Ͱ΋SQLite͸࢖͑Δ ¨  ެ։͢ΔΞϓϦʹ͸·ͩ࢖͑ͳͦ͞͏ ¨  SQLiteʹݶΒͣσόΠε্Ͱ࢖༻Ͱ͖ΔRDBMSΛ αϙʔτͯ͠ཉ͍͠

Slide 18

Slide 18 text

͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠

Slide 19

Slide 19 text

͓·͚ ¨  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 Ͱ࢖͑ΔσʔλϕʔεΛ ༗ঈɾແঈ໰Θͣద౰ʹूΊͯΈ·ͨ͠