[GTALUG] capturing the output of any program and inserting in db

[Jamon Camisso]

On 2014-10-29 12:13 PM, Myles Braithwaite wrote:
> Dave Cramer wrote:
>> Is there anything out there that is written simply ? By this I mean I
>> don't want to have to install a framework or a jvm or any large
>> dependencies. Ideally this would be written in bash or the like.
> 
> You could use the sqlite. Running something like:
> 
> #!/bin/sh
> sqlite3 log.db 'INSERT INFO log (message) VALUES ($MESSAGE);'
> 
> in a table setup like this:
> 
> CREATE TABLE log (
> 	id INTEGER PRIMARY KEY,
> 	timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
> 	message TEXT
> );

What if $MESSAGE == 'foo); DELETE FROM log;'

Just saying.. :p