[PLUG] Databses

Vaibhav Kulkarni netvaibhav at gmail.com
Tue Apr 10 01:20:54 PDT 2007


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



More information about the plug-mail mailing list