Command line tool to get a png diagram of SQLite DB
Project description
This is a command line interface for
sqlalchemy_schemadisplay
tool by Florian Schulze.
Usage
sqlite2png.py sqlite.db
Example
$ python sqlite2png.py /usr/share/ibus-libpinyin/db/english.db
sqlite:////usr/share/ibus-libpinyin/db/english.db
writing db.png
The script uses SQLAlchemy, pydot and graphviz under the hood. Graphviz-cairo is recommended upstream to improve image quality.
Roadmap
- install command line script with
pip
- de-vendorize
sqlalchemy_schemadisplay
after it is released
- de-vendorize
- output .png to stdout
- reproducuble
- option to show the image (needs PIL and image viewer)
- option to diff the image
- add example DB to the repo
- support full urls
{py} postgres://user:pwd@host/database
{py} sqlite:////usr/share/my.db
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-0.1.4.tar.gz
(7.9 kB
view hashes)
Built Distribution
Close
Hashes for sqlite2png-0.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ca271168d1e005a4de5cc9ba6ae740e5a691cf83bce35a7ab46c584a8ea5e000 |
|
MD5 | a3bd21be23dd448ceced264f29e5b771 |
|
BLAKE2b-256 | 39270241b6417414ee2f6387683661cb42a4d0d05f8f05db5d2759f44067bce1 |