I asked a the question on twitter if anyone knew anything about someone trying or had tried to implement SQLite in Windows Phone 7 Silverlight projects, and through gcaughey, a device application development MVP, I got a link to Dan Ciprian Ardelean´s blog; Mobile Development.
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. It is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform – you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. It would be the perfect database “engine” for the Windows Phone 7 platform.
About a month ago he wrote an article on a proof-of-concept application for Windows Phone 7 and SQLite. Maybe this is how we can work around the lack of database support on wPhone7, bringing back the power of relational data.
Great article! check it out and and download his code to play around with.
A couple of good articles to read, also from the Mobile Development blog is an article on persisting the isolated storage between emulator restarts, and a post on isolated storage performance.
These links are now “invite only” or something… and everything I find on the subject links to them! Are there any other resources you know of for sqlite for wp7?
Any help would be much appreciated.