什么是最好的用户数据库 [英] what is the best why to user database

问题描述

我正在开发桌面应用程序，
这是一个商店管理系统.

我想知道我需要存储该应用程序数据的新项目.
我的意思是我不想在客户PC中安装SQL.这是我为第一个客户提供的第一个实时项目，我只想给他一个应用程序安装程序，即可在他的系统中安装该应用程序，因此在这种情况下我该如何使用数据库.

谢谢

Hi,

I am developing a Desktop Application,
It is a shop management system.

I want to know which new Item i need to store data of that application.
I mean i don''t want to install SQL in my customer PC. this is my first live project for my first customer i just want to give him a application Setup to install the application in his system so how can i use database in this case.

Thank You

推荐答案

如果您仅查看单个用户系统，请查看SqlCE或SqLite-它们都是符合SQL的数据库(有一些限制)，它们专为单用户环境而设计，不需要SQL Server.您还可以查看基于Access的解决方案.

如果您正在查看库存管理等，那么数据库解决方案比序列化或XML文件更好，因为不必重写整个文件即可插入或删除项目.

如果您正在查看多个用户，那么我强烈建议尽管存在安装问题，但MsSql或MySql解决方案是最好的方法-它们使同时更新的所有主要陷阱都非常非常容易(因为它们可以处理所有更新)为您).多用户使用自己的文件才是真正的PITA！

If you are only looking at single user systems, then have a look at SqlCE or SqLite - they are both SQL compliant database (with some restrictions) which are designed for a single user environment and do not require SQL Server. You could also look at an Access based solution.

If you are looking at stock management and so on, then a database solution is better than serialization or XML files, as the whole file does not have to be re-written to insert or remove an item.

If you are looking at multiple users, then I would strongly suggest that an MsSql or MySql solution is the best way to go despite the installation problems - they make working with all the major pitfalls of simultaneous updates very, very easy (as they handle all that for you). Multi user working with your own files is a real PITA!

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