Recently, I want to write an dongdong, need to use similar functions like embedded database, similar to desktop database, but do not need the kind of server.
Stroll on the internet, looking for a few related databases, mostly free or open source, license Limited, here do a summary of the index bar.
0.SQL Server Compact 3.5--through this period of comparison, and testing, feel this version of the more reliable.
The reasons are as follows: 1 deployment: There are a variety of options that can be packaged separately with the application and can be published to
Desktop, smart devices, Tablet PC and other multiple target application platform.
2 The Windows series of 32, 64 have good support.
3 SQL Compatibility is good, later can be logically easy to upgrade to the server side of the SQL Server Enterprise Edition
4 license aspect, complete free. Although there is no source code, but still choose to believe that the reliability of MS products
5) easy to use. Because I use. NET C # Open, good compatibility.
6 Help the document is more complete, the Chinese translation quality is good, especially to me this kind of English farm laborers is very good to look up the material
7 performance, because the application of small amount of data, so the performance gap is not carefully compared.
The above points are considered from my application purposes, so in the test and screening on the Assumption, you reader if you fancy is the source code, and the application of the target and scope have additional assumptions and requirements, certainly here to the database selection, there will be their own judgments, in this need to remind you that, The following 2-8 of the database are mostly open source, but license should be aware that open source is not free, not freely, not no charge, may not be suitable for enterprise internal or commercial embedding, but also please choose carefully, respect for copyright.
1.access
2.sqlite, this is a transplant version of C #, called Csharpsqlite.
3.Berkeley DB
4.Firebird
5.perst.net--http://www.mcobject.com/perst/
6.sharphsql--A pure Java Hypersql DB, the product of the transplant http://sharphsql.codeplex.com/
7.EffiProz
8.DeveelDB