ER Diagrammer for the Koha Database
Hi all, I am doing a bit of development work on a local install of Koha and am constantly using MySQL to refer to the schema for the database. Enquiries with Katipo and elsewhere show that there is no overall ER diagram for the database. I am prepared to construct one from what I find, but wonder this: Are there any tools the list might know of that can connect to MySQL and produce an ER diagram of the schema? cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Blessed are the cracked for they let in the light. -- Spike Milligan
2007/2/28, Rick Welykochy <rick@praxis.com.au>:
Are there any tools the list might know of that can connect to MySQL and produce an ER diagram of the schema?
Even if it isn't exactly what you want, maybe SQLFairy ( http://sqlfairy.sourceforge.net/) can help you. By example, you'll be able to produce a diagram of your schema (with sqlt-diagram). Hope this help, Manu
Hey Rick, First off, welcome to the community. ----- "Rick Welykochy" <rick@praxis.com.au> wrote:
I am doing a bit of development work on a local install of Koha and am constantly using MySQL to refer to the schema for the database. Enquiries with Katipo and elsewhere show that there is no overall ER diagram for the database. Right
I am prepared to construct one from what I find, but wonder this:
Are there any tools the list might know of that can connect to MySQL and produce an ER diagram of the schema? Very cool idea. I don't personally know of any tools, but let us know what you find out and we'll incorporate it into the documentation.
Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
Rick Welykochy a écrit :
Hi all,
I am doing a bit of development work on a local install of Koha and am constantly using MySQL to refer to the schema for the database.
Enquiries with Katipo and elsewhere show that there is no overall ER diagram for the database.
http://wiki.koha.org/doku.php?id=en:development:dbschema is this not what you're looking for ? It's uptodate for 2.2 and i'll take care of it for 3.0 when I get some minuts... -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19
Paul POULAIN wrote:
http://wiki.koha.org/doku.php?id=en:development:dbschema is this not what you're looking for ? It's uptodate for 2.2 and i'll take care of it for 3.0 when I get some minuts...
C'est fantastique! Merci bien, Paul. The 2.2 diagram is certainly enough for my needs. Thanks to the other developers who contributed the links for SQLfairy and other tools. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services All truth passes through three stages. First, it is ridiculed. Second, it is violently opposed. Third, it is accepted as being self-evident. -- Arthur Schopenhauer
participants (4)
-
Emmanuel Di Pretoro -
Joshua M. Ferraro -
Paul POULAIN -
Rick Welykochy