This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Niall McPhillips

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.

Speaker Biography

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.