软件设计问题
我有一个应用程序将分发给我公司内的大量人员。我需要为这个应用程序建立一些中央数据存储,但没有 SQL Server 或类似的预算。我注意到VS2008中有一个叫做本地数据库的东西...这适合中央数据存储吗?数据量不大
谢谢!
注:
我没有服务器来托管它,这不是我的选择,这只是我必须工作的条件。我能得到的最好的就是共享驱动器上的空间
I have an application which will be distributed to a large number of people within my company. I need to have some central data store for this application and dont have the budget for SQL server or anything like this. I noticed that there is a thing called a Local Database in VS2008... will this be suitable for a central data store? the volume of data is not large
thanks!
Note:
I do not have a server to host it on, This is not my choice, its just a condition i have to work under. The best i can get is space on the shared drive
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
MySQL 是一个免费的开源数据库,您也可以使用。
MySQL is a free, open source database that you can use as well.
为什么不使用SQL Server Express?它是免费的且功能齐全。
Why not SQL Server Express? It's free and fully featured.
您可以访问您公司的 Web 服务器吗?
如果客户端只需要读取数据,您只需从众所周知的 URL 提供 xml 文件即可。
Have you got access to a Web Server at your company.
If the clients only need to read the data you could just serve up an xml file from a well known URL.
如果您必须使用文件共享系统,我会使用 Access 数据库。但是,您很可能会在某个阶段遇到某些类型的文件损坏,并且如果您有许多并发用户,则可能会发生难以预料的不良情况。基本上,文件共享数据库对于本地 PC 上的一个用户来说效果很好,仅此而已。
If you have to use a file share system I would use an Access database. But there is a good chance you will experience some kinds of file corruption at some stage, and if you have many concurrent users untold bad stuff could happen. Basically a file share database works well for one user on a local PC and that's about it.
还有 Postgres,它比 MySQL 更强大一点,而且同样是免费的。
System.data.sqlite 对于与 Visual Studio 一起使用也是一个不错的选择,它也是免费的(但对于大量客户端来说可能不是最佳选择,尽管到目前为止设置是最简单的)。
There is also Postgres, its a bit more robust than MySQL and is free just the same.
System.data.sqlite is a decent option as well for use with Visual Studio, it is also free (but may not be the best option for a large number of clients, although the setup would be easiest by far).