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

[Peter Simmons]

Hi Brian,

Thinking about your comments "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. " a bit more.

Probably this hasn't been tested in a real world situation but in your 
opinion would this black magic be a big risk in terms of scalability and 
performance?

One of the things that will happen with this site is it is likely to 
grow to a few hundred thousand users (and milliions of transactions) in 
the next 12 - 18 months. We are trying to future proof against that as 
much as possible. Our main thrust is in getting the data into a SQL db 
(likely mysql) which handles these numbers of objects/rows much better 
and fits because largely the data is relational in nature. Our general 
concept is let's go with some kind of object relational mapping to make 
the transition easier and more reuse of the exisitng code and then 
if/when/where required we can always do direct SQL to make things more 
efficient.

Am more than happy for you to poke holes in our theories/plans 
(especially at this early stage ;-) so any thoughts/feedback based on 
your experience would be very much appreciated (same goes for anyone 
else on the list also ;-)

Cheers,
Pete

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.
>
> 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.
>
> 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?
>
>   
>> 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/
>>
>>
>>     
>
>