NoSQL - Relational Database Management System

command arguments...

This manual page briefly documents NoSQL 2.4.7. 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.

The commands are stored in command -h. The following table lists a short overview of the NoSQL commands: (Tables are NoSQL tables, unless explicitly mentioned otherwise) center, expand, tab(@); l l. addcolumn@ append new empty column(s) addrow@ append a new empty record column@ select column(s) from table compute@ apply AWK to table data, using column names ctime@ convert values of a column from seconds since epoch into a C date depend@ assess functional dependency between two table columns edittable@ edit a table in list or row format filter@ run standard utilities on a table gregorian@ convert selected date columns from Julian to Gregorian calendar index@ 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 keysearch@ display records where first field begins with a given string listtotable@ convert list into table maketable@ build a valid table header from a table cross-reference file nblparser@ NoSQL Brokering Language (NBL) interpreter number@ insert a unique record identifier into a table prtable@ experimental table formatter for character displays random@ pick one or more records at random from a table rdbtotable@ converts an /rdb table into NoSQL format rename@ rename a table column repair@ repair a broken table rmcolumn@ remove selected columns from a table row@ select rows matching a given AWK expression using column names search@ fast-search of an indexed 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@ sum up selected table columns union@ concatenates multiple tables unique@ makes a table unique on the key field update@ insert/update/delete rows according to an edit table viewtable@ comfortable table viewer xreftable@ cross-reference a table

awk(1), perl(1), rcs(1), lockfile(1).

Carlo Strozzi <carlos@linux.it>.

Manual page by David Frey <dfrey@debian.org>