The Design of a Persistence Layer, a paper and a nice collection of links.

In general, see Scott's Agile Data web site.

Free persistence products for Python: PyPerSyst (GPL) and Webware, a web application toolkit (Python open source license). (Webware is far more than that, it's like Zope but quick and easy and not as featureful when you don't need it to be featureful.)