Graphical database schema for petascope

[mrusu]

Currently there is no graphical representation of the petascope database schema, so it would help to have one. A command line tool is preferred, as it can be integrated with the update script. The image should be added to the petascope documentation page ​http://rasdaman.eecs.jacobs-university.de/trac/rasdaman/wiki/PetascopeDevGuide

Suggestion: SchemaSpy ​http://schemaspy.sourceforge.net/

[Dimitar Misev]

Mihaela, don't forget to close when you submit the script to the repo.

[mrusu]

Both the script and the generated schema have been added to ​http://rasdaman.eecs.jacobs-university.de/trac/rasdaman/wiki/PetascopeDevGuide, since the script does not belong to petascope deployment, but is rather part of the development process.

[Dimitar Misev]

Shouldn't the Makefile be modified to substitute the @sysconfdir@ in the script?

[mrusu]

Replying to dmisev:

Shouldn't the Makefile be modified to substitute the @sysconfdir@ in the script?

Yes. but this can be easily done when generating a new schema when the db is updated, which doesn't happen very often.

[Dimitar Misev]

Ok please document how it should be modified, or even better, just make the path to the settings file another argument to the script and remove the .in from the name?

[mrusu]

Tested and updated the wiki page. Now it is a simple .sh file.

[Dimitar Misev]

Great! Do you think it's possible to add some description of the tables to the generated schema documentation? The -desc or -meta options in SchemaSpy could be potentially useful for this.

[Dimitar Misev]

Should be closed?

[mrusu]

Replying to dmisev:

Should be closed?

Not yet, the patch is still pending

[Dimitar Misev]

Would be nice to document the new petascope schema in this way, what do you think Piero?

​http://www.craigkerstiens.com/2013/07/29/documenting-your-postgres-database/
​http://www.craigkerstiens.com/2013/08/02/use-dollar-quoting-anywhere/

[Piero Campalani]

Using COMMENT ON statements is indeed very cool, Dimitar.

A new updateX.sql file could be created for this: this can simply be a copy-pasting activitiy from files in browser:applications/petascope/src/main/db/petascope/update8, especially schema.sql.

[Piero Campalani]

PS Meanwhile also PetascopeDevGuide has been heavily updated (+ UML diagram).

[Dimitar Misev]

I think this will be a good ticket for Xinghua, to familiarize with the petascope database.

[gxinghua]

Add update15.sql in changeset:7413988. Should this ticket be closed?

[Peter Baumann]

indeed, it's completed.