Full database schema or conceptual design available for the Review Board database?

[Christian Kolb]

Hello!

I finally managed to query from the MySQL database of my reviewboard installation (yeah! :-D ).
However for an easier orientation through this table jungle, is there any database schema or
a conceptual ddatabase design available online for the MySQL database of a Review Boar installation?

To give you an example that illustrates what I mean, here is the full database schema of the Polarion ALM software:
https://almdemo.polarion.com/polarion/sdk/doc/database/FullDBSchema.pdf

Thanks in advance!

Best regards, Christian

[Christian Hammond]

Hi Christian,

There's not, I'm afraid. It's not something we've ever needed, and directly working with the database is not a common thing (and not something we generally recommend). I'm curious what you're looking to do with the database?

For most situations, our recommendation is to either work with the REST API or the Review Board database models (which are in Python) to perform the queries you need. We don't guarantee that the database schema will remain the same each release (we try to keep the Python models compatible, but the schema is considered an implementation detail) or that it's in a form that's easy to get to (diff data, for instance, is compressed and de-duplicated).

Christian

--
Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups "Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Christian Hammond

President/CEO of Beanbag

Makers of Review Board

[Christian Kolb]

Sorry for the late response I often planned to write a reply but then forgot in my hurry. :-D

I use the database for queries which combine data from Reviewboard and from my other applications I use. I mentioned Polarion already, I use the Review Board tool to review work items which are stored in my Polarion. In the Summary of a review, the work item ID is visible and therefore I can apply a SQL Join on the the review_reviewsrequest table with the work items table and see at a glance, for which work items I have reviews and for which I have not.

You may wonder how it can work to make combined queries with an MySQL source (Reviewboard) and a PostgreSQL source (Polarion), for this I use the Microsoft SQL Server Management Studio.
There I can indclude the database of the applications I use as Linked Servers and mix SQL Server queries with MySQL and PostgreSQL queries with the OPNEQUERY function.

You see, in this case the API is not an option. ;-)

Best regards

To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.