GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
SQLITE2DOT(1) FreeBSD General Commands Manual SQLITE2DOT(1)

sqlite2dot
convert sqlite3 schema to GraphViz input

sqlite2dot [-v] [-c attrs] [-h attrs] [-p prefix] [-t attrs] [schema]

The sqlite2dot utility converts an sqlite3(1) schema file to a GraphViz file readable by dot(1). Its arguments are as follows:
Emits informational messages to standard error.
attrs
Table-cell attributes. See the GraphViz documentation for HTML labels for a list of cell attributes (except “href”). You should invoke this once per attribute (they will accumulate).
attrs
First table-cell (header) attributes. If unset, this will use -c. See the GraphViz documentation for HTML labels for a list of cell attributes (except “href”). You should invoke this once per attribute (they will accumulate).
prefix
Prefix to use for creating HTML ID tags.
attrs
Table attributes. See the GraphViz documentation for HTML labels for a list of cell attributes (except “href”). You should invoke this once per attribute (they will accumulate).
schema
An SQLite schema file.

The outputted GraphViz file serialises tables as HTML-label nodes, each of which has one row per table column. Table nodes are connected by foreign keys.

sqlite2dot is best when creating image maps by piping into dot(1) with -T cmapx then -T png or similar backing, then using the usemap attribute for the HTML <img> tag. You can then use sqlite2html(1) for linking to the documentation.

dot(1), sqlite2html(1), sqlite3(1)

The schema language accepted by sqlite2dot is currently limited to the table declaration with a subset of the column specification.
June 29, 2016 FreeBSD 13.1-RELEASE

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.