v0.22.0
Changes in this version include:
- New command line options:
-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.
- The script can now to be empty. This is useful with
-dbfile
. - You can insert data into an existing table over multiple invocations of Sqawk (with
-dbfile
) or in a single invocation with several input sources. - Most of the input parsers and the output serializers are now lazy. This results in:
- A massive reduction in memory usage (e.g., inserting 1 000 000 rows now takes 40 MiB, not 900 MiB), which makes it feasible to work with larger datasets even in memory.
- Approximately 20% slower parsing and serialization, a price well worth paying in the developer's view.