Convert SQLITE to PNG

Turn SQLITE files into PNG. A picture at 96 dpi.

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.Each table becomes a box, and foreign keys become lines between them.

  1. What you get

    One PNG picture at 96 dpi, laid out left to right as an entity relationship diagram. Each table is a box headed by its name. The box lists the columns in order with their declared types, and it shows NOT NULL and generated columns.

    Primary keys are marked PK and foreign keys are marked FK. Tables with no keys between them are set out in a grid.

  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.

  3. What is left out

    Every table is drawn, including empty ones and those without a rowid. Views, indexes, triggers and SQLite's own tables are not drawn. The picture shows the structure of the schema, not the rows in it.

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

SQLITE and PNG.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 · PNG

PNG

Lossless raster images with an alpha channel. Screenshots, icons and graphics with sharp edges.

Extensions
.png
MIME type
image/png
Kind
Images

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

terminal
$ cv convert report.sqlite report.png
$ cv convert report.sqlite report.png

Questions.What people ask about SQLITE to PNG.

01OF 04

No. It shows tables and their columns, not the rows stored in them.

Yes. Every table is drawn, including empty ones and those without a rowid.

No. Views, indexes, triggers and SQLite's own tables are left out.

The file has no tables, so there is nothing to draw. A schema that is too large stops with resource_limit instead.

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