NoSQL(1)
NAME
NoSQL - Relational Database Management System
SYNOPSIS
command arguments...
INTRODUCTION
This manual page briefly documents NoSQL 4.0.14. It was written for
the Debian GNU/Linux distribution (but may be used by others), because
the original program does not have a manual page. Instead it contains
documentation in HTML format.
NoSQL is a fast, portable, relational database management system without arbitrary limits other than memory and processor speed.
NoSQL uses the 'operator/stream' DBMS paradigm described in "Unix
Review", March, 1991, page 24, entitled "A 4GL Language". The operators are Unix filters, in other words, they read tables or lists from
stdin and write output (also tables or lists) to stdout. They are typically connected by pipes to do staged processing.
The operators work with relational data in ASCII files. The fields in
each row are separated by a 'TAB' char and the row is terminated with a
'NEWLINE' char. The first row (the header) contains the names for each
column preceded by the ASCII character SOH (0x01). Subsequent rows
(the body) contain the data values.
DESCRIPTION
- The commands are stored in /usr/lib/nosql Their help pages can be
printed out with command -h. The following table lists a short overview of the NoSQL commands: (Tables are NoSQL tables, unless explicitly
mentioned otherwise)
- addcolumn append new empty column(s)
- addrow append a new empty record
- awktable filter table trough awk
- column, notcolumn, project, getcolumn select column(s) from table
- compute apply AWK to table data, using column names
- csvtotable convert a CSV file into a NoSQL table
- ctime convert values of a column from seconds since epoch into a C date
- depend, deptable assess functional dependency between two table columns
- edittable edit a table in list or row format
- envtotable Convert environment into NoSQL table
- filter, filtertable run standard utilities on a table
- formtable print a report from a NoSQL table
- gregorian convert selected date columns from Julian to Gregorian calendar
- index, indextable create an index file for the given columns
- islist check for list correctness
- istable check for table correctness
- jointable join two sorted tables on a common field
- julian convert selected date columns from Gregorian to Julian calendar
- justify, prtable experimental table formatter for character displays
- keysearch display records where first field begins with a given string
- ldaptolist turns LDAP entries into a NoSQL list
- listtotable convert list into table
- maketable build a valid table header from a table cross-reference file
- nblparser NoSQL Brokering Language An(NBL) interpreter
- nltable number lines in table
- number insert a unique record identifier into a table
- random, rndtable pick one or more records at random from a table
- rdbtotable converts an /rdb table into NoSQL format
- rename, renamecol rename a table column
- repair, repairtable repair a broken table
- rmcolumn remove selected columns from a table
- rndtable pick one or more records at random from a table
- row, getrow, select select rows matching a given AWK expression using column names
- searchi, searchtable fast-search of an indexed table
- seektable extract rows beginning at selected offsets from a NoSQL table
- setnames set new column names on the input table
- sorttable sort a table on one or more columns
- soundex computes soundex codes for specified columns
- subtotal compute subtotals on selected table columns
- tabletocsv convert a table into CSV (comma-separated values) format
- tabletolist convert from table to list format
- tabletordb convert a table into /rdb format
- tmptable temporary table creator
- total, totaltable sum up selected table columns
- union, uniotable concatenates multiple tables
- unique makes a table unique on the key field
- update, updtable insert/update/delete rows according to an edit table
- viewtable comfortable table viewer
- xreftable, template cross-reference a table
SEE ALSO
awk(1), perl(1), rcs(1), lockfile(1).
AUTHOR
- Carlo Strozzi <carlos@linux.it>.
Manual page by David Frey <dfrey@debian.org>