Printable View
I want to develop a small utility that insert and fetch student's data to and from a simple data table!
And most important is that I dont want the user to become depend upon any specific data base (like MySQL) but I want to use any C or may be C++ library that can work as a stand alone database means having no external dependencies with it!
Can any one please help me for this?
So what's wrong with a simple text file in say CSV format -> Comma-separated values - Wikipedia, the free encyclopedia
Quit help full! But What if the data grows and reaches to a count of 10000 or may be greater! it ought to become slow if I search some thing like this:
SELECT * FROM student WHERE Basic_Subject LIKE "Chemistry";
Hey, you're the one who doesn't want to depend on a database.
If you want good performance and a generic query interface, then expect to write quite a lot of code yourself.
OTOH - SQLite Home Page
If you want to learn and or practice working with database code, then this is perfect to take on and code one yourself! You'll learn a TON I'm sure!
If you want to make something as a product instead, why try and re-invent the wheel? SQLite seems perfect for a standalone database.
SQLite is wonderful, and comes as a single C file that you just insert into your project. I use it to record student scores in a program we use in the school I work in. Writes everything to a normal file but has enough power and interface to just be used as an ordinary SQL database and you never know how the database is stored.
It even works well with multiple concurrent writers (you have to write the code to properly retry but I don't have any problems with 30+ simultaneous users) writing to a shared network file as the "database". And I can just throw standardised SQL at it from the programming end and it all just works. If SQLite ever isn't sufficient, I can just swap out the database code and still execute those same SQL statements against, say, MySQL, PostgreSQL, MS-SQL, etc. and see the same results.
I'd go for SQLite, personally. If nothing else, it's a wonderfully simple interface to an SQL database that you can always upgrade if performance starts to drop but, to be honest, I don't see it happening for casual use. To my knowledge, Opera uses an SQLite database for it's mail stores and I have about 8Gb of mail spread over 10 years of archives in my copy of Opera and it still does narrow-as-you-type search over the body of ALL those emails so fast it's scary. Lots of games use it for their savegame format too.
Yes I also think SQLite would help!
Thanks a lot for advice!
Yes But a last thing to ask! If go around for an application on .NET espacially in C# they have provide a .NET version of SQLite known as system.Data.SQLite As I found it here!
would I need these dependencies to be installed on the target system also in this case?