[PLUG] Databses

On 4/10/07, Ritesh Khadgaray <khadgaray at gmail.com> wrote:
> why not wrap this around a script ?
>> #!/bin/bash
> xmlstarler "$*" |tee /tmp/out
> cp -f /path/to/db/file /path/to/db/file.bak
> mv -f /tmp/out /path/to/db/file
The file would run into thousands of records after a couple months.
The above steps would become too slow then. Using a real database is a
better choice. sqlite should suite this situation. It does have a
command line way of manipulating the database.
$ sqlite3 [options] [databasefile] [SQL]
--
Vaibhav