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 would be

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

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: 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

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

2011-03-29 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 of

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 many

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:

[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

Re: [web2py] Re: web2py default application suggestion

2011-03-23 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

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

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: 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
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 the

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:

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