GraphViz2 and the dread MusicBrainz db
Hi All
OK. After a bit of pain I've set up an empty database for the
MusicBrainz database.
In particular, where they say 'sudo cpan Carton' you probably want 'cpanm Carton'.
This exercise was because, astonishingly, one of the users of my module GraphViz2 had doubts about it handling 149 tables spread over 4 schema.
The version of dbi.schema.pl shipped with GraphViz2 V 2.07 needed a patch to handle multiple schema, but after fixing that, you can view the SVG in all its ghastly glory.
Firstly, set up you env vars thusly:
env | grep DBI
DBI_PASS=musicbrainz
DBI_DSN=dbi:Pg:dbname=musicbrainz_db
DBI_SCHEMA=musicbrainz,cover_art_archive,report,statistics
DBI_USER=musicbrainz
Then the command is:
dbi.schema.pl svg musicbrainz.svg > musicbrainz.log
Further, you can download this set of files:
o musicbrainz.svg (size: 257,156 bytes)
o musicbrainz.log (output of dbi.schema.pl, containing the DOT file)
o dbi.schema.pl (patched)
o tables.log (the list of 149 tables as output by Pg's psql)
here.
I'll release a new GraphViz2 shortly.
I try to write all code in Perl, but find I end up writing in bash, CSS, HTML, JS, and SQL, and doing database design, just to get anything done...
Hi All
Damn. Forgot to mention.
The script examples/table.info.pl shipped with DBIx::Admin::TableInfo needs to be updated liekwise, but differently from dbi.schema.pl.
So, I'll release a new version of the module too.