Like awk but with SQL and table joins
arrays
and dicts
are unified into one option: kv
(for "key-value"). kv=true
acts as dicts=true
; kv=false
acts as arrays=true
.indent
option for the JSON serializer is renamed to pretty
.lines
and pretty
.dict_exists
, dict_get
, lindex
, llength
, lrange
, regexp
, regsub
.This is a bugfix release.
close
in the current directory.Changes in this version include:
-dbfile
to store the SQLite database on disk rather than in memory. It lets you parse the data once and query it later, saving time.-noinput
, which stops Sqawk from reading from the standard input if it is given no input files. Use it with -dbfile
when you only want to query an existing database file.-dbfile
.-dbfile
) or in a single invocation with several input sources.Changes in this version include:
fields
for the default parser awk
lets you skip as well as merge parts of the input. It replaces the option merge
.a0
, b0
, etc.) with the file option F0
.raw
is no longer a synonym for the parser awk
.