Convert SQLITE to PDF

Turn SQLITE files into PDF. A picture on one page cut to its size, as vectors with selectable text.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQLITE files on the dialor turn it to pick what to do

A diagram of your database schema.One PDF page shows each table as a box, with lines for foreign keys.

  1. What you get

    A single PDF with one page, cut to the size of the picture. The picture is drawn as vectors, and the text in it can be selected.

    It is an entity relationship diagram laid out left to right. Each table is a box headed by its name. The box lists the columns in order with their declared types, and shows NOT NULL and generated columns. Primary keys are marked PK and foreign keys are marked FK.

  2. How relations are drawn

    Each foreign key is a line from its column to the column it references. A crow's foot sits on the side that can repeat. A bar or a circle tells whether the key is required.

    If a foreign key names a table that the file does not have, that table is drawn with a dashed border. Tables with no keys between them are set out in a grid.

  3. What is left out

    Every table is drawn, including empty ones and tables without a rowid. Rows of data are not part of the diagram.

    Views, indexes, triggers and SQLite's own tables are left out. If you need those, they are not in the PDF.

  4. When it stops

    A file with no tables stops with unsupported_elements. A schema of more than 250 tables or 5,000 columns stops with resource_limit.

    For other things to do with the result, see every PDF conversion.

SQLITE and PDF.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data
To · PDF

PDF

Fixed-layout pages that look the same everywhere. The exchange format for anything that will be printed or signed.

Extensions
.pdf
MIME type
application/pdf
Kind
Documents

In your code.The same SQLITE to PDF conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report.pdf
$ cv convert report.sqlite report.pdf

Questions.What people ask about SQLITE to PDF.

01OF 04

No. It shows the structure of each table, with its columns and types, not the rows stored in it.

No. Views, indexes, triggers and SQLite's own tables are left out. Every real table is drawn, even an empty one.

Yes. The diagram is drawn as vectors with selectable text.

The schema has more than 250 tables or more than 5,000 columns. A file with no tables fails with unsupported_elements instead.

More conversions.Other ways in and out of SQLITE and PDF.