Selected Work Examples
StoryCorps is an independently funded organization that collects, shares, and preserves people’s stories to remind people of our shared humanity, to strengthen and build the connections between us, to teach the value of listening, and to weave into the fabric of our culture the understanding that everyone’s story matters. All collected stories are stored in their online archive, accessible to the public upon submitting a request or listening to recordings at various public library listening rooms. StoryCorps reached out to LCM for ongoing support and assistance with migrating their site’s archive of roughly 27TB worth of interviews and information to a new AWS platform.
The main StoryCorps Archive access point was built on a robust Drupal platform consisting of over 60,000 interview records and approximately 27TB of associated metadata, WAVs, MP3s, JPGs and PDFs. The StoryCorps Archive platform connected with several critical business systems and performed around-the-clock ingests from their onsite storage arrays to the Drupal system, via rsync. StoryCorps was looking for a trusted and capable firm to migrate their entire Archive-- including the website, connected services, and media-- from their single-server host to a combination of Amazon Web Services (AWS), EC2, S3 and Glacier.
Last Call Media performed a thorough analysis and audit of all StoryCorps’ source data prior to and following the massive migration. We worked closely with StoryCorps' internal Digital Team and engineering consultants to design, test, implement, and ultimately maintain the new AWS server infrastructure.
The archive is now running smoothly on a robust AWS setup, configured to allow the platform to efficiently scale and grow as the archive does; to the next 27TB and beyond.
Yale University Press has a massive collection of over 15,000 unique publications they’ve published over the past 100 years. The Press desired the ability to allow their users to browse, check inventory and purchase items directly from their Yale University Press Drupal site, which required relaunching their site on Drupal 7, integrating their collection management system and an e-commerce and fulfillment solution. After working with another vendor for over three years to get the critical nightly sync from their Microsoft SQL Server Management Studio database to Drupal sync running, Yale University Press was seeking a second opinion.
How we did it
Working with Yale ITS and the Press, we successfully implemented a nightly sync that queries their SQL Server for changes made in the last 24-hrs and updates the records in Drupal in under 15 minutes every night at midnight.