Command line tool to get a png diagram of SQLite DB
Project description
sqlite2png
tool generates .png image of database schema.
Usage
From checkout without installing (needs sqlalchemy
and pydot
).
./sqlite2png.py sqlite.db
The diagram is written into db.png
.
Install with pip and run as module.
pip install sqlite2png
sqlite2png /usr/share/ibus-libpinyin/db/english.db
sqlite:////usr/share/ibus-libpinyin/db/english.db
writing db.png
About and examples
sqlite2png
is a CLI wrapper over
sqlalchemy_schemadisplay
lib by Florian Schulze, which uses SQLAlchemy
, pydot
and graphviz
under the hood. Graphviz-cairo
is also recommended to improve image quality.
See ./examples.
Roadmap / Changelog
- de-vendorize
sqlalchemy_schemadisplay
after it is released - output .png to stdout
- option to show the image (needs PIL and image viewer)
- option to diff the image
- support full urls
{py} postgres://user:pwd@host/database
{py} sqlite:////usr/share/my.db
- (1.1.4) install command line script with
pip
- (1.1.4) add example DB to the repo (uses some public DBs)
- reproducuble .png (seems like it already is)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlite2png-1.1.4.tar.gz
(8.2 kB
view hashes)
Built Distribution
Close
Hashes for sqlite2png-1.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e793e01b51f810d21e20c000dceccafa2be76c89083424aaefb513e7c4b58380 |
|
MD5 | 815d0657728f7173a4b3618d3b008552 |
|
BLAKE2b-256 | 9d6645f77ed8da8282f335170fad88751de1f40b19bec5d40db9b38e4d4aa998 |