Type of data bases to use

Question

0.00/5 (No votes)

See more:

I have been working on an idea for a database for high school class reunions where you can pull statistics from it for who attended certain reunions, how many male or females attended and so forth. I keep getting brain lock on the relational design but I recently thought of another potential problem. My developer system has the SQL Server on it but, what if the end user of the program does not have it installed and also does not want to install it?
Is there a way to create this database and still be able to get all of the robust stats I want to be able to get at?
The only other thing I can think of is to save it as a XML document but not sure of the performance.
The current implantation would have at least 350 people that I would need to add.
Thank you for your time.

Posted 30-Jun-12 7:59am

ledtech3

Add a Solution

2 solutions

Solution 1

SQLite will be a good option for you.
http://stackoverflow.com/questions/271319/lightweight-sql-database-which-doesnt-require-installation[^]

Posted 30-Jun-12 8:18am

DamithSL

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2012-06-30T08:22:00

Solution 2

A Dataset can read your XML file and work with it in memory. For 350 people or records it is perfectly fine.

Relational databases have been over used and promoted where you can do perfectly fine with out it.

Try looking at Sqlite http://sqlite.org/[^] if you need a relational database that is embedded and doesn't require an install.

If you feel adventurous take a look at RaptorDB - the Document Store[^] for a nosql document database engine.

There are numerous other embedded database engines.

Posted 30-Jun-12 8:22am

Mehdi Gholam

Comments

Sergey Alexandrovich Kryukov 30-Jun-12 14:53pm

Nice suggestions, especially interesting is the unusual RaptorDB. I'll take a look at your article. My 5, of course.
--SA

Mehdi Gholam 30-Jun-12 15:02pm

Thanks Sergey!

Sergey Alexandrovich Kryukov 30-Jun-12 14:55pm

I would also warn against file-based of fileserver-based RDBMS like MS Access. If file based, just the XML (say, data contract) is better, at least it does not depend on Office installations or 3rd parties.
--SA

ledtech3 30-Jun-12 16:27pm

Yes, the RaptorDB does look interesting,I will have to take a closer look at it, already went thru the article.
As sqlite has been sugested twice now,I was looking into that but am having trouble finding information on how to use it with a vb.net windows forms.

Mehdi Gholam 1-Jul-12 1:02am

There are a lot of resources on sqlite and .net, all you need to do is search or ask another question :)

ledtech3 1-Jul-12 1:05am

The hardest part some times is finding the "Right" Questions :)

ledtech3 30-Nov-12 11:32am

I'm thinking this may be the way to go for this project.
Encrypting a dataset using AES
http://www.codeproject.com/Articles/455805/Encrypting-a-dataset-using-AES-including-compressi?msg=4420126#xx4420126xx
I just have to finish converting it from a WPF (VS 2010) to A Win Form version (VS2008).

ledtech3 3-Dec-12 9:57am

I have accepted this as the Solution since it first mentioned using XML.
The RaptorDB is way to advanced for me. SqlLite still requires extra files and I never did get far enough with it to be able to impliment a test project to see how to use it.