[Archivesspace_Users_Group] Querying ArchivesSpace using MySQL Workbench

[Valerie Addonizio]

Margaret,

There is this classic resource that I’ve leaned on in the past: https://campuspress.yale.edu/yalearchivesspace/2015/09/08/mucking-around-in-archivesspace-locally/comment-page-1/

I was recently made aware of this resource on the tech-docs page; though it was written against 2.7.1, a lot of the basics are the same: https://github.com/archivesspace/tech-docs/blob/master/architecture/backend/database.md Though they are complex, you may find the sample queries (halfway down the page) helpful to get you started. You’ll also want to scan the relationship tables since you’re likely interested in locations and their relationships to top containers (or vice versa).

Neither of those is truly quickstart, but they are the two ASpace-specific resources I know of.

-V

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Margaret Kidd
Sent: Tuesday, June 20, 2023 3:13 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Querying ArchivesSpace using MySQL Workbench

Hello all,

I recently gained access to a read-only copy of our production database using MySQL Workbench. My hope is that I could use it to query our data to create the kinds of reports we need. For example, I would like a better shelf list report as the current option in ASpace doesn't suit our needs.

The problem is that my skills in this area are hopelessly out-of-date. The last time I worked with MySQL was 20 years ago in my pre-archives life (ugh, it hurts to write that sentence and realize how old I'm getting). Does anyone have any tips or could point me to a basic tutorial that may help? The stuff I've found so far isn't very helpful for me. I just need to learn some quick and dirty basics to get at this information quickly. Hopefully, I can spend some time later on tutorials to get more comfortable.

Any suggestions would be most appreciated.

Thanks,

Margaret

________________________________

Margaret Turman Kidd

Access and Electronic Records Archivist, Special Collections & Archives

VCU Libraries | Health Sciences Library

Virginia Commonwealth University

509 N. 12th Street / Box 980582, Richmond, VA 23298-0582

(804) 828-3152

kiddm at vcu.edu<mailto:kiddm at vcu.edu>

Pronouns: she/her
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230620/251b6c4f/attachment.html>