[Evergreen-documentation] Database schema page

Blake Henderson blake at mobiusconsortium.org
Mon Jan 1 15:12:34 EST 2024


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-documentation/attachments/20240101/027933ed/attachment-0001.htm>


More information about the Evergreen-documentation mailing list