One of the most frequent questions I get about the WP7 platform is “when are we going to get local database support?” Thanks to the heroic efforts of the Open Source community, there are now several alternatives for local database support on WP7:
- Windows Phone 7 database
Hosted on CodePlex, this project implements a Isolated Storage (IsolatedStorage) based database for Windows Phone 7. The database consists of table objects, each one supporting any number of columns.
- Perst Embedded Database For Microsoft Windows Phone 7
Perst is an open source / dual license embedded database for .NET and .NET Compact Framework. Andy Wigley, an APPA Mundi principal and Microsoft MVP, wrote a blog post outlining some of the changes he made to the open source database which have now been incorporated back into the mainline build at McObject.
- db4o Open Source Object Database
db4o is an object-based database (as opposed to a relational database) designed for use in Silverlight and .NET applications. Since there is Silverlight 3 support, it *should* work on WP7. I’ve downloaded it and proved that it will launch a WP7 app with the db40 DLLs referenced, but haven’t tried really exercising the toolset yet. I’ll update the post when I have more data to share.
- siaqodb Open Source Object Database
siaqodb is an object database engine that currently runs on .NET 3.5+, Mono 2.4+, Silverlight 3 and 4 as well as WP7. It’s database management application allows you to use LINQ to run ad-hoc queries against the database, which is kind of a cool and unique feature.
It looks like I’m going to have to do a WP7 Database Smackdown at some point and share the results with you.