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.
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.
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.
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 withunsupported_elements.
SQLITE and PNG.What each format is.
The formats
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
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.
$ cv convert report.sqlite report.png$ cv convert report.sqlite report.pngQuestions.What people ask about SQLITE to PNG.
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.