Database – Looking for a good why to create a generic database

[asheraslan]

Hello Guys,

My app uses different types of persistent data (setting) that I would like to save in one DB table.
The values I want to keep in the DB are from different kind of types (e.g. int, strings, bin…)

I thought about create columns for each type that I need(IntCol, StrCol, BinCol…) but it will be a waste of space since I will only use one columns in a row. I also thought about the option of keep them all as binary type but then I will have to do the right casting for each value.

Is anybody can advice for a better why to do it?

Thanks,
Asher

[symbianyucca]

Have you considered stores ? For example CDictionaryStore works pretty well on saving settings data.

yucca

[asheraslan]

Thanks for your advice!

Asher

[Mr. Buttington]

The dictionary store would be usful if you need independant access to the settings (i.e. you want to save/restore one without accessing the others). But if you save/restore them all in one go you could also simply save them in a plain old file (accessed directly or via RFileRead/WriteStream).