alf - Relational algebra at your fingertips

SYNOPSIS

    alf [--version] [--help]
    alf -e '(lispy command)'
    alf [FILE.alf]
    alf [alf opts] OPERATOR [operator opts] ARGS ...
    alf help OPERATOR

OPTIONS

    -e, --execute                    Execute one line of script (Lispy API)
    --rash                       Render output as ruby hashes
    --text                       Render output as a text table
    --yaml                       Render output in YAML
    --json                       Render output in JSON
    --csv                        Render output in CSV
    --examples                   Use the example database for database
    --db=DB                      Set the database to use
    --input-reader=READER        Specify the kind of reader when reading on $stdin (rash,csv,json,ruby)
    -Idirectory                      Specify $LOAD_PATH directory (may be used more than once)
    -rlibrary                        Require the library, before executing alf
    --ff=FORMAT                  Specify the floating point format
    --[no-]pretty                Enable/disable pretty print best effort
    -h, --help                       Show help
    -v, --version                    Show version

RELATIONAL OPERATORS

    extend           Relational extension (additional, computed attributes)
    frame            Relational framing (aka offset/limit, yet sounder)
    group            Relational grouping (relation-valued attributes)
    intersect        Relational intersection (aka a logical and)
    join             Relational join (and cartesian product)
    matching         Relational matching (join + project back on left)
    minus            Relational minus (aka difference)
    not-matching     Relational not matching (inverse of matching)
    page             Relational pagination (like frame, but easier)
    project          Relational projection (clip + compact)
    rank             Relational ranking (explicit tuple positions)
    rename           Relational renaming (rename some attributes)
    restrict         Relational restriction (aka where, predicate filtering)
    summarize        Relational summarization (group-by + aggregate ops)
    ungroup          Relational un-grouping (inverse of group)
    union            Relational union
    unwrap           Relational un-wrapping (inverse of wrap)
    wrap             Relational wrapping (tuple-valued attributes)

EXPERIMENTAL RELATIONAL OPERATORS

    hierarchize       Relational hierarchy (recursive relation-trees)
    infer-heading     Relational heading inference (print the relation type)
    quota             Generalized quota-queries (position, sum progression, etc.)

NON-RELATIONAL OPERATORS

    autonum       Extend its operand with an unique autonumber attribute
    clip          Clip input tuples to a subset of attributes
    coerce        Force attribute coercion according to a heading
    compact       Remove tuple duplicates
    defaults      Force default values on missing/nil attributes
    generator     Generate a relation with an auto-numbered attribute
    sort          Sort input tuples according to an order relation
    type-safe     Check that input tuples are of a specified heading

OTHER NON-RELATIONAL COMMANDS

    exec     Executes an .alf file on current database
    help     Show help about a specific command
    show     Output input tuples through the default renderer in a specific order.

See 'alf help COMMAND' for details about a specific command.

SystemExit