[Evergreen-documentation] Database schema page

Wed Apr 24 17:43:41 EDT 2024

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 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: 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
>>>>
>>>>
>>>>
>>>> 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 <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 listEvergreen-documentation at list.evergreen-ils.orghttp://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/ba6fbf0f/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/ba6fbf0f/attachment-0001.png>