[Evergreen-documentation] Database schema page
Blake Graham-Henderson
blake at mobiusconsortium.org
Wed Apr 24 18:00:34 EDT 2024
Josh,
I'm glad you saw this thread and brought it back up! I do see a way
forward using schemaspy. If you want to pick this up, I think we'd
appreciate some code that can automate the generation of the HTML. Using
a postgres server paired with the Evergreen git repo. The missing link
is the code to bring the git branch to a specific version, install the
Evergreen database onto the postgres server, then execute the signalspy
code. And the output of that would then need to be injected into a page
somewhere. The last piece of getting a pointer to the entry html page
will require permissions on the docs server. We can put our heads
together and I'm sure we can get it worked out!
Maybe at the hackfest tomorrow!?
-Blake-
Conducting Magic
Will consume any data format
MOBIUS
On 4/24/2024 4:43 PM, Josh Stompro wrote:
> Hello Blake, I'm curious if you want help with this? I've been
> missing the old autodoc based database schema and was just going to
> volunteer to try and help get that going again, but saw this email
> about a new version.
>
> I was also looking at https://dbdocs.io/ which has nice output, but I
> think that is a cloud provider that hosts the output which may not be
> what we are looking for.
>
> It would also be nice to have links in the Database Schema Map section
> of olddocs.evergreen-ils.org <http://olddocs.evergreen-ils.org>
> updated with a 3.10 link to Michele's work at
> https://wiki.evergreen-ils.org/doku.php?id=newdevs:db:schemas:3.10_schma
> , but I think I'm just used to going there to find it... I need to
> retrain to go to the old docs section...
> https://docs.evergreen-ils.org/docs/latest/appendix/previous_docs.html
>
> I tried out schemaspy and it seems pretty nice. It displays comments,
> and the relationship diagrams are fun.
> image.png
>
>
> On Mon, Jan 1, 2024 at 2:12 PM Blake Henderson via
> Evergreen-documentation
> <evergreen-documentation at list.evergreen-ils.org> wrote:
>
> All,
>
> I was thinking about baking in an autogenerated PG browsable
> schema using Schemaspy. https://schemaspy.org/samples/epivirusurf/
>
> I saw it a few years ago and I tucked that in the back of my mind
> to setup a way to have our documentation server contain a section
> for all versions of Evergreen's Database schema. With a bit of
> elbow grease, we could loop through each git branch and generate
> Evergreen schema pages going back to 2.0. Plus have a nightly
> build of current main, like we do for our Antora docs.
>
> Which occurred to me after we adopted Antora - seeing that we lost
> a couple of our features: database details, downloadable PDF
> version of the docs.
>
> Of course, I haven't done anything! But I did create that Perl
> script
> <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/support-scripts/make_concerto_from_evergreen_db.pl;h=e7d6159fcddc8541fa6676e0e87ef9e715bfff27;hb=refs/heads/main>
> to make it easier to create blank installations of the Evergreen
> database on a PG server, which would be useful for this automation.
>
> -Blake-
> Conducting Magic
> Can consume data in any format
> MOBIUS
>
> On 12/28/2023 2:06 PM, Terran McCanna via Evergreen-documentation
> wrote:
>> Thanik you!!
>>
>>
>>
>> Terran McCanna, PINES Program Manager
>>
>> ------------------------------------------------------------------------
>>
>> Georgia Public Library Service | University System of Georgia
>>
>> 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341
>>
>> (404) 235-7138| tmccanna at georgialibraries.org
>>
>> http://help.georgialibraries.org | help at georgialibraries.org
>>
>>
>> <https://www.facebook.com/georgialibraries><https://www.twitter.com/georgialibs><https://www.instagram.com/georgialibraries/><https://www.twitter.com/georgialibs>
>>
>> Join our email list <http://georgialibraries.org>for stories of
>> Georgia libraries making an impact in our communities.
>>
>>
>>
>>
>> On Thu, Dec 28, 2023 at 2:54 PM Andrea Buntz Neiman via
>> Evergreen-documentation
>> <evergreen-documentation at list.evergreen-ils.org> wrote:
>>
>> I updated the 3.2 link on the newdevs page, and I'll put
>> links in for the 3.2 and 3.10 schemas on the previous docs
>> <https://docs.evergreen-ils.org/docs/latest/appendix/previous_docs.html>
>> page.
>>
>> (and thank you, Michele, for the updated schema!)
>>
>> On Thu, Dec 14, 2023 at 9:25 AM Tiffany Little via
>> Evergreen-documentation
>> <evergreen-documentation at list.evergreen-ils.org> wrote:
>>
>> That's perfect, thank you Michele!!
>>
>>
>>
>> Tiffany Little, PINES Bibliographic Projects Manager
>>
>> ------------------------------------------------------------------------
>>
>> Georgia Public Library Service
>>
>> 2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341
>>
>> (404) 235-7161 | tlittle at georgialibraries.org
>>
>>
>> Join our email list <http://georgialibraries.org/>for
>> stories of Georgia libraries making an impact in our
>> communities.
>>
>>
>>
>> On Wed, Dec 13, 2023 at 8:59 AM Morgan, Michele
>> <mmorgan at noblenet.org> wrote:
>>
>> Hi Tiffany,
>>
>> There's a database schema section on the New Devs
>> page with a link to those schemas:
>>
>> https://wiki.evergreen-ils.org/doku.php?id=newdevs:db:schemas
>>
>> There's also a 3.10 schema there which was part of my
>> tuit challenge from the conference. 🍪🙂
>>
>> Hope this helps!
>> Michele
>>
>> --
>> Michele M. Morgan, Systems Support Specialist
>> North of Boston Library Exchange, Danvers Massachusetts
>> mmorgan at noblenet.org <mailto:mmorgan at noblenet.org>
>>
>>
>>
>> On Wed, Dec 13, 2023 at 8:48 AM Tiffany Little via
>> Evergreen-documentation
>> <evergreen-documentation at list.evergreen-ils.org> wrote:
>>
>> Good morning,
>>
>> Since the docs got moved last month(?), I'm not
>> able to find the old database schema pages that
>> we had. (Although they were admittedly outdated,
>> like 3.2 or something.) I actually did use
>> those--can someone point me to where they're at now?
>>
>> Thanks!
>> Tiffany
>>
>>
>>
>> Tiffany Little, PINES Bibliographic Projects Manager
>>
>> ------------------------------------------------------------------------
>>
>> Georgia Public Library Service
>>
>> 2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341
>>
>> (404) 235-7161 | tlittle at georgialibraries.org
>>
>>
>> Join our email list
>> <http://georgialibraries.org/>for stories of
>> Georgia libraries making an impact in our
>> communities.
>>
>> _______________________________________________
>> Evergreen-documentation mailing list
>> Evergreen-documentation at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation
>>
>> _______________________________________________
>> Evergreen-documentation mailing list
>> Evergreen-documentation at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation
>>
>>
>>
>> --
>> Andrea Buntz Neiman, MLS
>> Project Manager for Software Development | Product Specialist
>> Equinox Open Library Initiative
>> abneiman at equinoxOLI.org <mailto:abneiman at equinoxoli.org>
>> 1-877-OPEN-ILS (673-6457)
>> Direct: 770-709-5583
>> _https://www.equinoxOLI.org/ <https://www.equinoxOLI.org/>_
>> _______________________________________________
>> Evergreen-documentation mailing list
>> Evergreen-documentation at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation
>>
>>
>> _______________________________________________
>> Evergreen-documentation mailing list
>> Evergreen-documentation at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation
> _______________________________________________
> Evergreen-documentation mailing list
> Evergreen-documentation at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-documentation
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-documentation/attachments/20240424/545c80eb/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 255140 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-documentation/attachments/20240424/545c80eb/attachment-0001.png>
More information about the Evergreen-documentation
mailing list