Hi all,
i plan to use a sqlite database in a situation, where data needs to be
imported from different sources with changing 'structure' regularly.
to get concrete: for a scientific project - a database for pattern recognition
test pictures - i have lots of pictures which can be characterized by a large
number of parameters (e.g. when / where taken by whom, bw or colour, etc...).
i plan to store the parameters and the relative path to the file (i don't want
to have the pictures themself in the database).
i will regularly get collections of pictures from different people.
the values for the parameters stored in the database may be coded in the path
and/or in the filename within the collection or be missing.
My approach would be to have some sort of script language which allows me to
easily formulate rules in order to extract parameter values from filenames,
and combine this with extra information.
small example:
given the following directory structure and files:
collection/
bw/
2009_10_11_pic1.png
2009_10_11_pic2.png
2009_10_11_pic3.png
assume we would have to fill the follwing parameters for the database:
author
mode (bw/color)
year
month
day
I could use xml snippets to provide missing information, e.g.
<author>nameoftheauthor</author>
mode could be extracted via string tokenizer:
between 1. and 2nd /
year: between 2nd / and following _
and so on.
does there exist some approaches to deal with situations like this?
thanks
alex
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
