[PLUG] Databses

Vaibhav Kulkarni netvaibhav at gmail.com
Tue Apr 10 13:50:54 IST 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]


More information about the Plug-mail mailing list