News for hackers. Stuff that matters.
Re:Why you should learn just a little Awk - A Tutorial by Ex... by LiveTheDream on Saturday August 27, 2011 @06:36PM (#2932742)
Depends on how complex the expected operations are. I think awk is absolutely essential for dealing with things like logfiles. Do you have a reason against using sqlite[1]? That works just fine in the console, doesn't need a server. You could still use awk with it, technically. For example:

    bash..$ sqlite3 books.sqlite
    sqlite$ create table books ( title varchar(128), author varchar(128) );
    sqlite$ insert into books (title, author) values ("Snow Crash", "Neal Stephenson");
    sqlite$ .quit
    bash..$ echo "select * from books;" | sqlite3 books.sqlite
    Snow Crash|Neal Stephenson
[1] http://sqlite.org/
Re:Why you should learn just a little Awk - A Tutorial by Ex... by adamjernst on Saturday August 27, 2011 @06:47PM (#2932762)
You don't even need to pipe the command in; just put it as the second argument after the database file.

    $ sqlite3 books.sqlite "select * from books"
Re:Why you should learn just a little Awk - A Tutorial by Ex... by LiveTheDream on Saturday August 27, 2011 @07:33PM (#2932846)
Thanks for the tip