SQLITE2HTML(1) General Commands Manual SQLITE2HTML(1)


sqlite2htmlconvert sqlite3 schema to an HTML5 fragment


sqlite2html [-v] [-p prefix] [schema]


The sqlite2html utility converts an sqlite3(1) schema file to an HTML5 fragment. Its options are as follows:
Causes the parser to emit informational messages on stderr.
-p prefix
Prefix to use for creating HTML ID tags.
An SQLite schema file.
The outputted HTML5 fragment consists of a <dl class="tabs"> list consisting of tables; and then for each table, a <dl class="cols"> list of columns. The <dt> for each list entry consists of the name of the table or column and has its ID attribute set to the transformed name. The <dd> for each list begins with a <div class="comment"> if the table or column is preceeded by comments For columns with a foreign key reference, this will be preceeded by <div class="foreign"> containing an anchor to the key having a text node of the endpoint.
The @ character within a comment is special: the following table name and optional column name will be transformed into an HTML link to the identifier. Thus, @foo.bar will point to the “bar” column in table “foo”. If this identifier is not followed by white-space, you may quote the identifier to prevent subsequent characters from being pulled into the identifier, e.g., @"foo.bar". If you wish to print a standalone @, you may escape it with a backslash (“\”).
The [ character is similar, as it encloses general-purpose links in a manner similar to Markdown. Links are formatted as follows:
  • [link text](http://link)
  • [http://link]
You can escape the [ character as well, to prevent this behaviour.
The following sequences are also special:
Print an formatted n-dash.
Print an formatted m-dash.
Print formatted left-double quotes.
Print formatted right-double quotes.
Any of these may be escaped with the backslash to have it print as-is. If you wish to print a backslash, you must escape it, for example, the \\-character---and an \@-sign.
Lastly, a blank (without any white-space but the newline!) one-line comment line is considered to be a paragraph break, for example:
-- Hello, world. 
-- And after the break...
In multi-line comment, this can be affected with a blank line in the comment stream:
 * Hello, world. 
 * That was another line break. 


sqlite2dot(1), sqlite3(1)


The schema language accepted by sqlite2html is currently limited to the table declaration with a subset of the column specification.
July 14, 2016 OpenBSD 5.8