[Z3-sqlos] zope 2.x, Five and sqlos

[Peter Simmons]

Hi Brian,

Brian Sutherland wrote:
> On Thu, Apr 06, 2006 at 06:23:49PM +1200, Peter Simmons wrote:
>   
>> Hi,
>>
>> Thanks that helps a lot. Is anyone out there using Sqlos with Zope2.x 
>> and Five?
>>     
>
> Yes, I have one site in production and I know of at least one other. In
> the sqlos source there is a Zope2 directory containing a FiveSQLOS Z2
> product. That provides the necessary magic glue between sqlos and Zope2.
>
>   
Excellent sounds like we have a starting place ;-)
> But beware, thare be dragons here, FiveSQLOS contains some _really_
> black magic and I strongly urge you to stick to Zope3 unless you have a
> very good reason not to do so.
>   
Well we have an existing site about 3.5 years old based on plone 0.4 
(although we have upgraded/back ported a number of new nicer things over 
the years), the client and therefore us can't afford a complete rebuild 
and also can't afford to wait for a framework upgrade any longer. So we 
pretty much have to stick with using a version of plone. The latest is 
plone2.5 currently beta. So we are going to migrate to that version (not 
a simple thing in this case, current site is python 2.1, zope 2.6.4 and 
we hit a wall trying to upgrade seamlessly from that about 18 months ago 
due to syntax changes) which looks like using zope 2.8 and the version 
of Five that ships with plone 2.5 (1.2 I think).

We really want to move all out data out of ZODB (around 20,000 users, 
about 5 different types of users, over 130,000 transactions already in 
SQL db) and into a SQL DB which will make site maintenance much simpler 
and faster as one of the major things now is if we add a field to 20,000 
users doing the data initialisation causes major headaches as we have to 
run it in batches of about 5,000 to not kill the server/site (it is 
running about 18 hours of the day pretty solid).

We looked around and liked the approach of SQLObject, I had heard you 
guys had done some z3 stuff with it and we have been wanting to move dev 
to z3 technologies for a while (we mostly do ArchGenXML based AT stuff 
for more current projects at the mo' but have seen the issues with it 
scaling first hand) so it seemed like a nice fit in principal. As you 
can guess I am now just working out the details of the best fit for things.

You guys haven't done a PAS plug-in that also uses SQLObject in the back 
have you? I installed the SQLPASPlugin which looks like it will do the 
trick for us but works differently to the rest so another way of doing 
things to document/test/remember. Would be nice to get past that if 
possible. Maybe if we have time at a later stage if there isn't 
something already.
> But could you test something for me? With a fresh checkout of sqlos,
> read the section in the readme "A Sample Application" and try it out?
>
>   
We will certainly test this with the versions mentioned above and sing 
out if we need some help/find issues. It will be a good primer for us 
anyway.
>> Cheers,
>> Pete
>>
>> Brian Sutherland wrote:
>>     
>>> On Thu, Mar 30, 2006 at 11:40:30PM +1200, Peter Simmons wrote:
>>>   
>>>       
>>>> Hi,
>>>>
>>>> Just wondering if there are any tutorial's or examples of using sqlos to 
>>>> use SQLObject with Zope3?
>>>>     
>>>>         
>>> Yes there is a tutorial included with the source, but I think it's a bit
>>> out of date.
>>>
>>> Probably the best way is to look at the functional testing harness, that
>>> is a mini application in it's own right. It is also guaranteed to be
>>> correct.
>>>
>>> Probably the best place to ask questions is this list, or #z3-base on
>>> freenode.
>>>
>>>   
>>>       
>>>> Cheers,
>>>> Pete
>>>> _______________________________________________
>>>> z3-sqlos mailing list
>>>> z3-sqlos at codespeak.net
>>>> http://codespeak.net/mailman/listinfo/z3-sqlos
>>>>
>>>>     
>>>>         
>>>   
>>>       
>> -- 
>> BCMPweb Support
>> Phone: +64 9 267 4676
>> Fax: +64 21 219 0650
>> Email: support at bcmpweb.com
>> Web: http://www.bcmpweb.com/
>>
>>
>>     
>
>