Hallo
Do somebody know of a simpel, small database engine for C??
This is the scenario:
Car information (Make, model name, year etc) are presented in a Excel spread sheet. The information is text based. The same information is then put onto the targets data flash (Either as raw text, binary or other format). The car information is presented to the user in a sorted manner, depending on the user selection. (so it must be sorted run time)
So the idea was to either pre-generate a database file, that is flashed to the data flash. A database engine are then using this file, for getting the needed information to the GUI.
Or the car information are flashed to the data flash as a simpel text/binary file. The data are then read by the application. All sorting and string formating is done by the application.
As for know the car information is around 46 kBytes. I do have 8 MB flash and 16 MB RAM so no problem having space for it.
I use a LPC2478.
I have SQLite in mind, but is it overkill for the task ??
Any one know SQLite??
/Thomas
I have SQLite in mind, but is it overkill for the task ??;
Only about as much as using a 5 pound sledgehammer to squash a mosquito would be. ;-) For the job at hand, you don't need a database engine at all, much less a relational DBMS toting SQL.
For the amount of data you're looking at, your controller can quite probably go through the entire dataset before the human user notices that you're using any time at all. I.e. there's not even a strict necessity to precompute anything.