小型个人应用程序(SQL数据库，XML或其他文件类型)的最佳数据存储方法 [英] Best data storage method for small personal application(SQL Database, XML, or other file type)

问题描述

我在这里做了一些关于SO的研究，但没有找到我真正需要的东西.我目前正在学习C ++，以帮助将我公司MSSQL Delphi驱动的应用程序过渡到C ++.为了帮助促进学习，我正在研究个人应用程序以供家庭使用.由于我实际上并不认为需要数据库功能，因此我在寻找其他存储数据的方法.如果您知道该程序将执行的操作，则可能会有助于回答我的问题.

I have done a little research here on SO and haven't found exactly what I was needing. I am currently learning C++ to help transition my companies MSSQL Delphi driven application over to C++. In order to help facilitate my learning I am working on a personal application for my home use. Since I don't really think I will need to power of a database I was looking at other methods to store data. It may help answer my question if you know what the program will do.

它是什么:家庭预算，医疗和计划申请.

What it is: Family Budget, medical and planning application.

我要处理的事情:与其将预算电子表格保留下来，不如将PDF医疗文档和其他面向家庭的数据以无组织的方式放在拇指驱动器上.我想构建一个具有多个工具的前端.

What I want to do with it: Instead of keeping budgeting spreadsheets, PDF medical documents and other family oriented data on a thumb drive in an unorganized manner. I want to build a front-end that has multiple tools.

我希望能够存储和访问常规个人信息，完整的家庭医疗记录(包括糖尿病追踪工具，例如每日葡萄糖量和依赖的胰岛素)，预算信息，有关当前/历史账单的信息(帐户号，到期，已付款，到期日等)数据以及我想使我的个人数据更有条理的其他任何内容.我还计划能够打印报告并为此数据制作图表.我可能希望对数据进行加密，但是目前不确定.

I want to be able to store and access general personal info, full family medical records (including diabetic tracking tools such as daily glucose numbers and insulin delievered), budget information, information on current/historical bill (account #'s, amounts due, paid, due dates, etc) data and really anything else I can think of to make my personal data more organized. I also plan to be able to print reports and make charts and graphs for this data. I may wish to encrypt the data but I am unsure at this time.

现在，我知道一个实际的sql，mysql或progress数据库对于此项目而言绝对可以，但是我真的希望使用其他更小，更简单的工具.XML将是有效的选择吗?是否有其他文件类型可以用来存储所有数据.我正在寻找一种占用空间小，可快速访问并且能够对数据执行按摩"的功能.

Now I know that an actual sql, mysql or progress database would be absolutely fine for this project, however I really wish to use something else that may be smaller and simpler. Would XML be a valid option? Are there other file types out there that I could use to store all the data. I am looking for a small footprint, with quick access and the ability to perform "massaging" on the data.

推荐答案

使用SQLite.它为您提供了DBMS的强大功能，其中包括几乎完整的SQL-92实现，但完全嵌入在您的应用程序中，而且没有安装空间.

Use SQLite. It gives you much of the power of a DBMS, including a mostly complete implementation of SQL-92 but is completely embedded in your app, and has no installation footprint.

对于C ++，可以使用几个将OO API包装在相当原始的C接口周围的库.有关建议，请参见此SO问题.

For C++, several libraries are available that wrap an OO API around the fairly RAW C interface. See this SO question for recommendations.

甚至都不要考虑使用XML.数据库是存储您正在使用的信息的理想场所.

Don't even think about using XML. A database is the perfect place to store the kind of information you are working.

这篇关于小型个人应用程序(SQL数据库，XML或其他文件类型)的最佳数据存储方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！