独立数据库 [英] standalone database

问题描述

我目前正在设计一个小的应用程序。在过去，我一直使用MSAccess作为独立的数据库，我可以与程序一起发货。
但是我想知道，在这一天和年龄有没有替代解决方案，因为易于集成在.Net应用程序，对用户透明，可能更好的性能与大量的数据？

解决方案

您的选择是：

• www.sqlite.org - http://sqlite.phxsoftware.com/


• Firebird - http://www.firebirdsql.org/


• Sql Server CE - http://www.microsoft.com/Sqlserver /2008/en/us/compact.aspx


• VistaDB - http ：//www.vistadb.net/ （商业）


• ESE - 难以与.Net集成

当您需要多线程写入时，SQL CE和Firebird要快得多，sqlite是单线程访问或多线程读取的王。 VistaDb是100％管理，所以你可以运送在嵌入式设备上。

这些DB通常会为您提供更好的可靠性和性能。我强烈建议不要使用任何这些dbs的网络共享。

I'm currently designing a small application in .Net and in the past I've been using MSAccess as standalone database that I can ship with the program. But I was wondering if in this day and age there wasn't alternative solutions, as easy to integrate in a .Net app., as transparent for the user and maybe better performance with large amount of data?

解决方案

Your options are:

• Sqlite - www.sqlite.org - http://sqlite.phxsoftware.com/
• Firebird - http://www.firebirdsql.org/
• Sql Server CE - http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx
• VistaDB - http://www.vistadb.net/ (commercial)
• ESE - Which is hard to integrate with .Net

SQL CE and Firebird are a lot faster when you need multithreaded writes, sqlite is king for single threaded access, or multithreaded reads. VistaDb is 100% managed so you can ship it on embedded devices.

These DBs in general will give you better reliability and performance to access. I would strongly recommend against using any of these dbs over a network share.

这篇关于独立数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！