One of the projects Brent and I are working on lately is a facelift to the AOC site - as the number of artworks in the system has grown, the page has become more and more difficult to navigate. Keep your eyes peeled for some fun AJAX paging, better layout, and (finally) a search function.
The biggest problem - and one of the most useful pieces, so we had to solve it - was how to get a single search to look for a keyword in the AOC data as well as the associated Walker exhibition data. Up until now I’ve been using very awkward separate connections to each database to integrate their data, and finally today I stumbled on dblink. Now I can keep the two databases separate but allow them to share queries and data. AOC and Walker, sitting in a tree…
Art on Call also has some upcoming enhancements for the phone-based side of things: a few “interactive” features we’ve been planning since the beginning but only now have time for. Should be really cool.