Where is the Database Schema Table?

[Sherry Lake]

I had been using this to see the table relationships:

http://phoenix.dataverse.org/schemaspy/latest/index.html

as advertised here:

https://guides.dataverse.org/en/4.9.4/developers/tips.html#schemaspy

But the phoenix doesn't seem to exist any more. Where can I get a diagram of how the tables are related now? 

--

Sherry

[Julian Gautier]

I think it was moved to https://guides.dataverse.org/en/5.4/schemaspy, though I'm not sure how the database might have changed since version 4.9.4.

[Sherry Lake]

Thanks Julian.

Just want I needed!!! The version V4.9.4 (the link I had in my email) was just in the documents. The URL I had been using was this: http://phoenix.dataverse.org/schemaspy/latest/index.html, which doesn't work any more, either.

This is exactly what I wanted!

Thanks again.

[Philip Durbin]

Yes, the phoenix server was shut down a few months ago but unfortunately, we haven't gotten around to fixing the guides yet to remove or update that SchemaSpy URL. We plan to do this as part of this issue:

- Hosting for SchemaSpy (currently hosted on phoenix.dataverse.org) - https://github.com/IQSS/dataverse/issues/7031

I should note that https://guides.dataverse.org/en/5.4/schemaspy/ was a one off manual build of SchemaSpy for Dataverse 5.4. So it represents the database for that version of Dataverse. I look at that 5.4 SchemaSpy output all the time but I'm conscious of the fact that it doesn't reflect the latest database schema, since it's always changing in small ways.

I don't know if this is in scope for the issue above but ideally we'd have automatic builds of SchemaSpy for each future release as well as a build for what's in the "develop" branch (the latest, unreleased code).

Hope this helps,

Phil

--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-commu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/c1bc5433-e372-4632-a773-59a703d84b46n%40googlegroups.com.

--

Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin

[Philip Durbin]

Good news! The latest Dataverse database schema (for 5.14) can now be found at https://guides.dataverse.org/en/5.14/schemaspy/

This is thanks to core development team member Don Sizemore.

In short, SchemaSpy allows you to explore the database schema used by Dataverse. To see lots of arrows pointing this way and that, check out https://guides.dataverse.org/en/5.14/schemaspy/relationships.html :)

Thanks, Don!

Phil

[Philip Durbin]

Don just published SchemaSpy for Dataverse 6.2 (thanks!): https://guides.dataverse.org/en/6.2/schemaspy/index.html

[Philip Durbin]

Just updated for 6.4! Thanks, Don! https://guides.dataverse.org/en/6.4/schemaspy/

[Sherry Lake]

I am glad the previous version links (like 6.2) still work.

Use them all the time!!!!

Thanks Don!

To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/CABbxx8GtQd%2B4w%3DTh6n1U8ps8oPSXZTqNXZ9LRPR8fWaEOvwxeQ%40mail.gmail.com.