Re: [Zope] ZSQLMethod conditional insert

2005-07-27 Thread Thomas Olsen
Hi David On Wednesday den 27. July 2005 23:50, David Pratt wrote: > Hi Thomas. I would say postgres is better for this sort of thing. In > postgres, you can write a function in plpgsql or other function > language (there is also a python function language) that you install in > postgres. In any c

Re: [Zope] ZSQLMethod conditional insert

2005-07-27 Thread David Pratt
Hi Thomas. I would say postgres is better for this sort of thing. In postgres, you can write a function in plpgsql or other function language (there is also a python function language) that you install in postgres. In any case once you write it and then call it - it is executed in a single tra

[Zope] ZSQLMethod conditional insert

2005-07-27 Thread Thomas Olsen
Hi This is probably an FAQ but I haven't been able to find and answer. I need a counter for a certain CMFType and want to store the hits in a MySQL database not to fill up the ZODB. I've checked to two suggestions below but they both use two ZSQLMethods first to check if the URL is already in t