Re: [web2py] Re: auto-update/refresh content

2011-04-05 Thread David Warnock
> > Note, if you're using Comet/long-polling techniques, I think it keeps a > request open for a long time, so if you're using a server that blocks a > thread for each request, you could run out of threads if you have lots of > users connected at once. In that case, you may need to look into a > no

Re: [web2py] Re: a few comments on session handling

2011-04-05 Thread David Warnock
Jonathan, > This policy is okay, but not good for reasons argued above. It is > > better not acquiring a lock unless you need one than to keeping a lock > > unless you don't need it. > > My question is: in your locking policy above, what's the purpose of locking > at all? I wonder whether it wo

Re: [web2py] Re: get by date interval

2011-03-30 Thread David Warnock
Massimo, I agree. Please open a googlecode issue and I will try add this next > week. > Great, thanks. Issue 226: http://code.google.com/p/web2py/issues/detail?id=226 Dave PS It would be good to have a more obvious link to google code on the website. Maybe a page for Developers with details ab

Re: [web2py] Re: get by date interval

2011-03-30 Thread David Warnock
Massimo, They map into one sql query and they execute on each record on the db > side. I do not know how efficient they are. > It appears to me that it would be really helpful if we could set a flag so that Web2py would log all the SQL statements that it executes. If the log could include source

Re: [web2py] Re: question from stackoverflow - DB transactions

2011-03-28 Thread David Warnock
D, > I often use Firebird and it supports Global Temporary Tables. I wonder > whether that is something designed to resolve Adam's requirement. You > can keep the temporary data even when the connection is lost. > > http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-globaltemp > > I am

Re: [web2py] Re: question from stackoverflow - DB transactions

2011-03-28 Thread David Warnock
Hi, > Come on - Python gets a clean slate here! Anyhow, if Adam was the only > shooter and his guns fully locked, his foot should not be at risk. > Just 2 cents. :-) I know, that is why I like the joke. Dave -- Dave Warnock: http://42.blogs.warnock.me.uk Cycling Blog: http://42bikes.warnoc

Re: [web2py] Re: question from stackoverflow - DB transactions

2011-03-28 Thread David Warnock
Adam, Thanks for the answer and hints, I will analyze it deeper later, but to > answer you now - please make sure you know the person before you suggest him > buying a book ;) I am working currently on RDBMS with terrabytes of data, up > to 2-3 thousands concurrent users and I have to live with ma

[web2py] Stopping Dev server

2011-03-24 Thread David Warnock
Hi, Just wondering if the admin application could off the option to restart the development webserver. When running in development mode using "python2.5 web2py.py" there are a few times when the server needs to be stopped or restarted (install upgrade, adding routes.py). I wondered whether it wo

Re: [web2py] Re: web2py default application suggestion

2011-03-22 Thread David Warnock
> > All I do to handle sub-domains is check to see if the sub-domain matches a > user sub-domain. For example: > > user = > db(db.auth_user.sub_domain==request.env.http_host.split('.')[0]).select().first() > or '' > That is almost exactly what I want. It is not routing in the sense of going to a d

Re: [web2py] Re: web2py default application suggestion

2011-03-22 Thread David Warnock
Thanks that is great news. Dave -- Dave Warnock: http://42.blogs.warnock.me.uk Cycling Blog: http://42bikes.warnock.me.uk

Re: [web2py] Re: web2py default application suggestion

2011-03-22 Thread David Warnock
Hi, Just looking again at the book. Is there any support for subdomains in either routing system? I couldn't see any. I am thinking of what I think 37signals use http://clienta.myapp.com/users // list of all users for client A http://clientb.myapp.com/users/dave // form for user dav

Re: [web2py] Re: new URL router use cases

2011-03-21 Thread David Warnock
Tom, I am designing an app with a URL structure like this: > > myapp.com/yoursitename > > 'yoursitename' is effectively an argument as there could be many sites and > users are allowed to create their own sites. But I'd like it to be 'top > level'. > An alternative might be to use subdomains eg

Re: [web2py] Re: web2py applications and version control systems

2011-03-18 Thread David Warnock
Hi, I hg clone web2py and then set up a second repository for my app. So I can > update web2py and my app independently. I am using git, but no problem. Which directory do you have as the root for the app repository? web2py or web2py/applications/myapp Thanks Dave -- Dave Warnock: http://4

Re: [web2py] Re: web2py applications and version control systems

2011-03-18 Thread David Warnock
Christian, Thanks yes, as a GAE user you *need* to have app.yaml, index.yaml, and queue.yaml > in your source control (right now they get overwritten on upgrade so you > want them backed up). most people also need to have routes.py in their > source control. > Ok. It seems that I need to have t

Re: [web2py] Re: Best practice

2011-03-17 Thread David Warnock
David, Thanks for the advice. Makes sense to me am working through the book at present. Patience not my strongest point :-) Dave -- Dave Warnock: http://42.blogs.warnock.me.uk Cycling Blog: http://42bikes.warnock.me.uk

[web2py] Typo in trunk gae.py

2011-03-16 Thread David Warnock
Hi, In the trunk version of applications/admin/controllers/gae.py line 35 Field('appcfg',default=GAE_APPCFG,label='Path to appcgf.py', should be (notice appcgf.py instead of appcfg.py) Field('appcfg',default=GAE_APPCFG,label='Path to appcfg.py', I had noticed the problem with requiring the pass