Hi, no, its neither about the database structure to be changed ( i know about ALTER TABLE ADD COLUMN) nor about xml (I have xerces in use). the question is about: given a fixed database and serveral different sources with partly encoded information e.g. in filenames and (relative) paths in the collection.
this means that i regularly need to formulate 'rules' how to extract the needed parametervalues (to be stored in the database) from filenames and paths etc. background: my application code is in c/c++. I have xml parsing posibilities -> my approach would be to partly tokenize filenames and paths in c++. the rules for forming the tokens etc. could be provided to the importer via xml, as well as the missing information (in the example above the authors name). another example: suppose we would have an importer-layer understanding rules written in xml as follows: <month> <basestring>filename</basestring> <lefttoken nr='1'>_</lefttoken> <tighttoken nr='2'>_</righttoken> </month> lets say this would extract the needed parameter 'month' from the filename. this however would allow me import the 'day' without changing the importer code - only the riles need to be adapted: <day> <basestring>filename</basestring> <lefttoken nr='2'>_</lefttoken> <tighttoken nr='3'>_</righttoken> </day> with a set of simple basic rules, importing from different sources would be just a matter of writing the xml rules without the need to change the importer code itself. did this become clearer now? my question again: does something like this already exist? alex > Alexander Poddey wrote: > > does there exist some approaches to deal with situations like this? > > It isn't clear exactly what your question is. You can quite happily add > columns to an existing table at any time using ALTER TABLE ADD COLUMN. > > If each "entry" will have a random set of arbitrary columns then you'll be > better off with a schema less database - CouchDB is my favourite and the > Javascript it includes has XML processing primitives. > > If your question is generally about dealing with XML then I suggest fixing > a large amount of padding on the table in front of you right in the spot > where you will be repeatedly banging your head. > > Roger > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
