什么是最好的用户数据库

本文介绍了什么是最好的用户数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在开发桌面应用程序， 这是一个商店管理系统. 我想知道我需要存储该应用程序数据的新项目. 我的意思是我不想在客户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!