Version 0 of Sqawk

Updated 2015-01-16 22:05:53 by dbohdan
What Sqawk
Where https://github.com/dbohdan/sqawk
Description An Awk-like program that uses SQL and can process multiple files at once. It is powered by SQLite.
Platforms Linux, Windows XP/7/8.x, OS X, FreeBSD.
Prerequisites Tcl 8.5 or newer, Tcllib, SQLite3 bindings for Tcl.
Updated 01/2015
License MIT

Examples

Sum up numbers

find . -iname '*.jpg' -type f -printf '%s\n' | sqawk 'select sum(a1)/1024/1024 from a'

Shuffle lines

sqawk -1 'select a1 from a order by random()' < file

Find duplicate lines

Print them and how many times they are repeated.

sqawk -1 -OFS ' -- ' 'select a0, count(*) from a group by a0 having count(*) > 1' < file

Sample output

13 -- 2
16 -- 3
83 -- 2
100 -- 2

See also