April 11th, 2007
Web Serendipity
Sometimes you can find gold nuggets in the rough. The nice thing about the web is that you can share these nuggets and everybody can benefit. Let me tell you about two that I have found recently. I enjoy travel and photography, and the web is an ideal way to make armchair visits around the globe. Unfortunately most web sites describing places are worse than useless: pictures scarcely larger than postage stamps, often lots of adds, and little useful information.
Enter Flickr and Wikipedia.
While reading an article on the BBC website about Rosslyn Chapel in Scotland, I was fascinated by the stone carvings. Unfortunately the pictures on the BBC web site were too small. Now, one thing I have noticed is how useful Flickr and Wikipedia are when you want to see travel pictures of a place. Look up Rosslyn Chapel on Flickr and you will see lots of pictures taken by several people. Many of these are full resolution 2000 pixels across or larger. So if you want to look around at almost any place on the globe, just enter that name in Flickr. Most of the time you will find somebody has posted some pictures about that place, and those pictures will often give you a far better idea about the place that any tourist or commercial web site can do.
Recently an opportunity to visit the east shore in Maryland came up, and a friend suggested St Michael's as a destination. Googled web sites on St Michael's had little of interest. Then I tried St Michaels in Wikipedia - what a difference. One of the really great things about Wikipedia is that most of the pictures include links to full size images.
I don't think that using Flickr and Wikipedia as travel resources was something that could have been foreseen. But these are good examples of quite unexpected serendipitous benefits that sometimes surface.
April 10th, 2007
Revision History
A number of people have asked for a copy of the Revision History template, so here it is. You can use it in the following manner: Either manually copy the appropriate design elements into the target application, or set up Teamstudio Design Manager to do it.. Typically this takes 2 or 3 minutes, and about 200 hours of development have been added to the application - that makes developers look really good!
Revision History was created in about 1997 or so, and has been continuously updated and improved since then. This database is both a fully working design, and can be used as a template. You can play with it to get an idea of how it works. Probably the most important feature is that is can provide a watertight audit trail to changes in a database. Old versions of documents can be in the current or an archive database. And users can view these old versions, or roll back to them if required.
While there is some reasonable documentation, I make no apology for the fact that this is a development application - it is not a finished product. However you may find it useful as a source of ideas, or you can even use it as is, by incorporating it into your design.
LibraryRevHistory_R5_DEV.zip