The Archetypes Documentation says:

"SQLStorage uses the fact that Archetypes provides an extra layer on top of normal objects to allow for special persistence mechanisms. Zope provides many different relational database adapters, and SQLStorage plugs into those. Currently there are two adapters, Postgres and MySQL. However, if the database supports standard SQL, then there's no reason one of these existing SQLStorage formats can't be used. If you find that your database adapter needs to do something different, then it wouldn't be difficult to alter the SQL statements inside SQLStorage so it worked with another database."

So we need to find the adapters that work. See Andy's comments on ticket:19.

http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx

http://plone.org/documentation/archetypes/ArchetypesDeveloperGuide/index_html#sqlstorage

A RECENT THREAD ON THIS VERY ISSUE (i'm checking at the moment)

http://www.gossamer-threads.com/lists/engine?do=post_view_printable;post=184266;list=zope

Notes:

I have postgres installed, i have the python-postgres link working but it looks like i need to find an extra bit to now link to zope. Or i have to use a non-binary distribution of the python-postrges link, do a load of tweaking etc.... so still looking for simpler solution (oh and typically there is one on the zope site but its for psycopg 1 not 2). This is getting rediculous, i can get a precompiled windows binary of pscopg 1.1.18 but it doesn't have the zope adapter compiled; I've just emailed the guy (see stickpeople url) who maintains the win32 binaries to see if he can compile it a version for me.

http://initd.org/tracker/psycopg/wiki/PsycopgOne

http://initd.org/tracker/psycopg/wiki/PsycopgTwo

http://stickpeople.com/projects/python/win-psycopg/

Agggh!!! i'm so stupid - wasted ages on this, i didn't need to compile the zope bits, just copy the folder to the plone product area, restart the service and zope compiles the files... Its now listed in the zope area - i'll create a connection for you to play with.

database = oats; username = oats; password = oats;

Basically its a lot simpler than i thought, there are just so many things to suss... for windows at least use the binary by stickypeople(i've used 1.1.18) - this will give you all essential parts bar the zope build - get this from the original and version matched source (ie. psycopgone 1.1.18) extract the ZPsycopgDA folder to the products folder under zope instance (the plone) and restart the zope service as usual for product install. Then goto the zope managment front end and add a dbase connection (Z Psycopg Database Connection)..... Andy is now smug and patting himself on the back. :-)