Development, Open Source, Silverlight, WP7

Open Source Databases for WP7

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
    http://winphone7db.codeplex.com/
    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
    http://www.mcobject.com/perst_eval
    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
    http://developer.db4o.com/
    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
    http://siaqodb.com/
    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.

14 thoughts on “Open Source Databases for WP7

    1. This site reports Windows Phone but not specifically Windowes Phone 7. As a matter of fact, one of the illustrations mensions WM6. Is this in fact a Windows Mobile rather than a WP7 application?

  1. Mark S. is definitely on the right track. If you want to get a professional looking email address, Id recommend buying your name domain name, like or
    Gucci sweaters
    If its common it might be difficult to get, however, be creative and you can usually find something.

  2. I just checked into the pricing for a commercial license of Perst and was shocked to learn that it is $500 for a stand alone WP7 app, plus there is a nominal run time cost per installation that you buy in bulk. Have to say I'll be looking elsewhere for a DB solution.

  3. Thank you for your email! I am currently out of the office attending and speaking at an internal MIcrosoft conference. I will return to the office on Thursday, July 29th. Until that time, I will have limited access to email so responses will be delayed. If this is an emergency, please call my cell phone at 214-385-5616.

    Thanks!
    Chris

  4. Why aren’t any of the established database technologies available? (SQLite, SQLServerCE, JETCE.)

  5. Hey Chris,

    I know this is an older post, but I want to mention that I noticed that while Perst is open source, it’s not free ($395) which is not the case for the others.

    Jay Kimble

Comments are closed.