Building an Image Library for an International Organisation Using Oracle APEX
Niall McPhillips, Long Acre Sarl
This case study will describe the approach and challenges faced when overhauling a 14-year old image library of over 40’000 photos. The new version was developed using Oracle APEX, Oracle Multimedia, Oracle Text and PL/SQL. Topics addressed include: automatic extraction of image metadata to facilitate searches and image description; automatic resizing of images using Oracle Multimedia; customization of APEX reports to produce a modern presentation format for the photo library.
Niall Mc Phillips has been developing using Oracle since Oracle V5, has been using Oracle PL/SQL Web technologies since 1995 and Oracle APEX since 2005. Niall has developed a number of large, multi-lingual applications for multinational companies and organizations all over the world. Several of these receive tens of millions of views per year. Niall is a strong believer in APEX solutions because of their stability, scalability, and rapid development speed. Niall is the organiser of the Swiss APEX Meetup group.