Smithsonian’s National Postal Museum
Role: MySQL relational database design, custom API creation (JSON), PHP programming
About the Project:
In September 2013, the Smithsonian’s National Postal Museum unveiled its 12,000 square foot William H. Gross Gallery, the world’s largest gallery dedicated to philately.
In collaboration with the Richard Lewis Media Group, BBM Designs created an efficient relational database design and implemented corresponding API that was used throughout the Gallery's exhibits to sort and display thousands of stamp collection results. Since the Postal Museum's stamp database is quite large and always growing/changing, the Museum needed an easy way to manage and import their existing database into the gallery's database, seamlessly merging new/updated records across many thousands of entries. BBM Designs created a custom application and web-based interface that allowed the museum to do just that, requiring only a few clicks from museum staff to update their entire database of stamps across the gallery.