Re: [web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-17 Thread Vincent Borghi
On Tue, Mar 16, 2010 at 4:11 PM, mdipierro mdipie...@cs.depaul.edu wrote: I think what Vincent is asking is not so much importing capability but an interface that can read an excel file (or a csv file) asks you the names (guessing from the header) and types (guessing from data) of columns and

Re: [web2py] [Interview] Where do you use web2py?

2010-03-17 Thread Joe Barnhart
I'm using web2py to create applications for competitive swimming. I have an online meet entry website now for high school swim events and plan to add a website that will actually run the meet poolside during the event. It's a perfect application for web2py since it can be loaded and run from a

[web2py] Re: custom validation problem

2010-03-17 Thread mohammed al-moustady
could you please tell me how to do/find a print statement? or direct me to a chapter in the documentation or something? On Mar 16, 4:07 pm, mdipierro mdipie...@cs.depaul.edu wrote: can you add some print statements to determine which lines are executed and which not? I suspect a logic problem.

[web2py] Re: custom validation problem

2010-03-17 Thread hamdy.a.farag
Hi Mohammed, I faced a problem like this one b4 and simply as mdipierro said it was a logic problem try the validation function with the minimal code that works then add line by line and check whether it works or not then you'll detect when it fails Oh BTW if form.accepts(request.vars,session,

Re: [web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-17 Thread Thadeus Burgess
I had actually used appadmin in production for a particular database for several months. The users were the same as you are describing (end-user, used to excel). Now that it is time to give them the real app (as appadmin was just a quick get us up and running)... they are actually sad to see us

[web2py] Re: [Interview] Where do you use web2py?

2010-03-17 Thread ls1
- moulds and - machinery management in manufacturing plant On 17 Mar, 07:53, Joe Barnhart joe.barnh...@gmail.com wrote: I'm using web2py to create applications for competitive swimming.  I have an online meet entry website now for high school swim events and plan to add a website that will

Re: [web2py] jqGrid slice

2010-03-17 Thread Alex Fanjul
there is no screenshot of working examplestrange from you mr. freeze!! thanks for your slices alex El 17/03/2010 5:01, mr.freeze escribió: Here's a simple example of getting jqGrid working with web2py. I'll be improving it as I go along so feedback is welcome:

Re: [web2py] jqGrid slice

2010-03-17 Thread Alex Fanjul
there is no screenshot of working examplestrange from you mr. freeze!! :-P thanks for your slices alex El 17/03/2010 5:01, mr.freeze escribió: Here's a simple example of getting jqGrid working with web2py. I'll be improving it as I go along so feedback is welcome:

[web2py] Re: jqGrid slice

2010-03-17 Thread mr.freeze
There is now :) On Mar 17, 4:40 am, Alex Fanjul alex.fan...@gmail.com wrote: there is no screenshot of working examplestrange from you mr. freeze!! :-P thanks for your slices alex El 17/03/2010 5:01, mr.freeze escribi : Here's a simple example of getting jqGrid working with web2py.

Re: [web2py] Re: jqGrid slice

2010-03-17 Thread Alex Fanjul
hahaha, I knew that you couldn't resist...thanks again for your excelent work. alex El 17/03/2010 10:45, mr.freeze escribió: There is now :) On Mar 17, 4:40 am, Alex Fanjulalex.fan...@gmail.com wrote: there is no screenshot of working examplestrange from you mr. freeze!! :-P thanks

[web2py] Re: gae appadmin

2010-03-17 Thread Al
Matt, I have the exactly opposite problem, my appadmin (latest version) runs on GAE but it does not run locally, it has a yellow triangle with a ! sign in it. Have you modified the app.yaml - please see my other post:

[web2py] Re: How to call other web2py applications from within a web2py application

2010-03-17 Thread Rahul
These links are a good resource. But I'll need to figure out if I can get it working in my current application. Thanks for your wonderful support. I'll keep you all posted if I get success. Rahul. On Mar 15, 8:19 pm, mdipierro mdipie...@cs.depaul.edu wrote: For now look at the following links

[web2py] sqlite timeout setting?

2010-03-17 Thread vince
i understand sqlite is not for heavy usage. i just want to know is there any way to set the timeout for database file access before returning database is locked error? also is there any way to catch the error and return some busy error page? although i do not have problem with for eg. mysql,

[web2py] Re: custom validation problem

2010-03-17 Thread mohammed al-moustady
thank you hamdy but it is irrelevant to the code. BTW mdipierro do you mean print statement in the code itself? I thought it was s special function.. ok even If I do these print statements were would it print to? On Mar 17, 10:16 am, hamdy.a.farag hamdy.a.fa...@inbox.com wrote: Hi Mohammed,

[web2py] Re: custom validation problem

2010-03-17 Thread Mengu
to your console. On 17 Mart, 13:41, mohammed al-moustady mohd.moust...@gmail.com wrote: thank you hamdy but it is irrelevant to the code. BTW mdipierro do you mean print statement in the code itself? I thought it was s special function.. ok even If I do these print statements were would

Re: [web2py] Re: [Interview] Where do you use web2py?

2010-03-17 Thread Nicol van der Merwe
@ls1 : Nice! That sounds quite cool. Can you give any more info? On Wed, Mar 17, 2010 at 10:47 AM, ls1 ls1.luk...@gmail.com wrote: - moulds and - machinery management in manufacturing plant On 17 Mar, 07:53, Joe Barnhart joe.barnh...@gmail.com wrote: I'm using web2py to create applications

[web2py] Re: Migrating web2py to GAE

2010-03-17 Thread Al
The appadmin can be run on GAE, but it cannot run on local GAE SDK. (note: I have been thinking it might due to some basic settings, not just my code, which I have overlooked, as running T3 and C.R.M appliances have the same problem). I have customised myapp according to the web2py manual to suit

[web2py] Re: Planning to make a big project

2010-03-17 Thread mdipierro
web2py and other web frameworks all deal with concurrency in the same way. They can run multiple threads and multiple processes. It works well with multiple installation behind a load balancer such as pound or haproxy. The framework is built by avoiding use of modules that are not thread safe and

[web2py] Re: Do you know Redis?

2010-03-17 Thread mdipierro
I think this is more appropriate as a replacement for cache.ram than db. On Mar 16, 11:38 pm, Thadeus Burgess thade...@thadeusb.com wrote: Interesting, though for integration with the DAL this would require... some work! :) It seems that you will have to manually store lots of metadata that a

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread mdipierro
What error do you get? What triggers it? I do not think it related to timeout of database. On Mar 17, 6:01 am, vince lapcc...@gmail.com wrote: i understand sqlite is not for heavy usage. i just want to know is there any way to set the timeout for database file access before returning database

[web2py] Re: Migrating web2py to GAE

2010-03-17 Thread mdipierro
This is not a web2py issue. File string, line 1, in bind socket.error: (48, 'Address already in use') You have some other server running using the same port. I just tried appadmin and works file with me. On Mar 17, 8:57 am, Al albertsec...@gmail.com wrote: The appadmin can be run on GAE,

Re: [web2py] Re: Migrating web2py to GAE

2010-03-17 Thread mat --
Hi - can someone (re)explain how to get appadmin running on GAE? On non-GAE hosting I understand it requires SSH tunnel. But is there an equivalent on GAE? Currently, when accessing appadmin on both local GAE and GAE I get: Admin is disable because insecure channel. Does the app.yaml file need to

[web2py] Re: Migrating web2py to GAE

2010-03-17 Thread mdipierro
replace http://... with https:// GAE has its own certificate. It works for me at https://web2py-crm.appspot.com/init/appadmin On Mar 17, 10:23 am, mat -- mat...@gmail.com wrote: Hi - can someone (re)explain how to get appadmin running on GAE? On non-GAE hosting I understand it requires

Re: [web2py] Re: Migrating web2py to GAE

2010-03-17 Thread Thadeus Burgess
Does the GAE SSL certificate compatible with google checkout? The snag with using plugin google checkout level 2 integration is the need for a $80/year SSL certificate :( -Thadeus On Wed, Mar 17, 2010 at 11:10 AM, mdipierro mdipie...@cs.depaul.edu wrote: replace http://... with

Re: [web2py] Re: Migrating web2py to GAE

2010-03-17 Thread Jonathan Lundell
On Mar 17, 2010, at 9:10 AM, mdipierro wrote: replace http://... with https:// GAE has its own certificate. It works for me at https://web2py-crm.appspot.com/init/appadmin Where's the best approximation of a cookbook approach for running web2py on GAE? I looked at the deployment

Re: [web2py] Re: Do you know Redis?

2010-03-17 Thread Kuba Kucharski
I think this is more appropriate as a replacement for cache.ram than db. maybe. but there is more than caching there: While all the data lives in memory, changes are asynchronously saved on disk using flexible policies based on elapsed time and/or number of updates since last save. If you

Re: [web2py] Re: Do you know Redis?

2010-03-17 Thread Kuba Kucharski
Values in Redis can be Strings as in a conventional key-value store, but also Lists, Sets, and SortedSets (to be support in version 1.1). This data types allow pushing/poping elements, or adding/removing them, also perform server side union, intersection, difference between sets, and so forth

[web2py] is_image validation when editing a record

2010-03-17 Thread Chris
Hi, I have an upload field in my database that looks like this: db.define_table('page', Field('book_id', db.book, required=True), Field('number', 'integer', required=True), Field('body', 'text', required=True), Field('image', 'upload', autodelete=True), ) db.page.image.requires =

[web2py] Re: Do you know Redis?

2010-03-17 Thread mdipierro
You can do this also with cache.disk. You can cache any primitive python structure including lists and dicts. I am sure redis has richer apis and lots more features than cache.disk but still its apis are closer to cache than dbs. I think we can have a cache.redis (and I will make a patch for it

[web2py] Re: is_image validation when editing a record

2010-03-17 Thread mdipierro
Can you post the complete traceback? On Mar 17, 12:03 pm, Chris crflei...@gmail.com wrote: Hi, I have an upload field in my database that looks like this: db.define_table('page',     Field('book_id', db.book, required=True),     Field('number', 'integer', required=True),     Field('body',

[web2py] latest windows version

2010-03-17 Thread Wes James
Massimo, When I run web2py.exe -h I get nothing - it just goes back to the prompt. I tried web2py -M -a 'recycle' -p 443 I get an error: the system can't find the file specified. I have to just run web2py or web2py and get the gui to run it. -wes -- You received this message because you are

[web2py] Re: Where do you use web2py?

2010-03-17 Thread DJ
I use it to develop research applications in biotechnology - eg. discovering new bacteria, tracking scientific data, identifying potential drugs. Web2py integrates beautifully with third-party tools and scientific packages leading to efficient and agile product development. On Mar 12, 5:42 am,

[web2py] Re: is_image validation when editing a record

2010-03-17 Thread Chris
Traceback (most recent call last): File /Users/chris/Dropbox/workspace/chris/gluon/restricted.py, line 173, in restricted exec ccode in environment File /Users/chris/Dropbox/workspace/chris/applications/init/ controllers/appadmin.py, line 410, in module File

[web2py] service decorator vs. file extension

2010-03-17 Thread mr.freeze
It seems you can return json/xml/etc. data by either decorating an action with @service.json or by simply calling the action with a file extension index.json. Is there a difference? -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this

[web2py] Re: latest windows version

2010-03-17 Thread mdipierro
which one is the latest windows version 1.76.5 or 1.76.5.1.b? On Mar 17, 12:07 pm, Wes James compte...@gmail.com wrote: Massimo, When I run web2py.exe -h I get nothing - it just goes back to the prompt.  I tried web2py -M -a 'recycle' -p 443 I get an error: the system can't find the file

Re: [web2py] Re: latest windows version

2010-03-17 Thread Wes James
I was just looking back at your email it is this one: http://web2py.com/examples/static/1.76.5.1.b/web2py_win.zip -wes On Wed, Mar 17, 2010 at 12:28 PM, mdipierro mdipie...@cs.depaul.edu wrote: which one is the latest windows version 1.76.5 or 1.76.5.1.b? On Mar 17, 12:07 pm, Wes James

[web2py] Re: service decorator vs. file extension

2010-03-17 Thread Yarko Tymciurak
On Mar 17, 1:09 pm, mr.freeze nat...@freezable.com wrote: It seems you can return json/xml/etc. data by either decorating an action with @service.json or by simply calling the action with a file extension index.json.  Is there a difference? The extension uses the generic view templates - have

[web2py] Re: service decorator vs. file extension

2010-03-17 Thread mdipierro
The use of decorators predates the generic.json and it is still approrpriate for jsonrpc and xmlrpc, but for pure json output I'd use the new generic.json also because you can customize it by giving a .json to each action. On Mar 17, 1:09 pm, mr.freeze nat...@freezable.com wrote: It seems you

Re: [web2py] Re: Migrating web2py to GAE

2010-03-17 Thread mat --
I am now able to indeed access appadmin via https :-) Thank you! On Wed, Mar 17, 2010 at 6:10 PM, mdipierro mdipie...@cs.depaul.edu wrote: replace http://... with https:// GAE has its own certificate. It works for me at https://web2py-crm.appspot.com/init/appadmin On Mar 17, 10:23 am,

[web2py] Re: latest windows version

2010-03-17 Thread mdipierro
web2py.exe -h should work but will look into it web2py -M -a 'recycle' -p 443 you get the right error since you did not specify -S whichapp On Mar 17, 12:07 pm, Wes James compte...@gmail.com wrote: Massimo, When I run web2py.exe -h I get nothing - it just goes back to the prompt.  I tried

[web2py] Blogitizor Issues

2010-03-17 Thread Alex Fanjul
Hi thadeus, I'm trying to understand the blogitizor code, but I'm wasn't be able to install it yet at all. I'm using last version of web2py 1.76.1, and windows 7 with python 2.5. 1) I could install pygments with easy_install but couldn't install guppy beacuse it requires python 2.6 and I

[web2py] edit_area 0.8.1.1 ctl+s works

2010-03-17 Thread Wes James
Massimo, I just went and copied edit_area from an older web2py I had. It is 0.8.1.1 and the ctrl+s works there. I tried the sourceforge version of edit_area, which you are probably are using too, 0.8.2 and ctrl+s is does not work. Oddly my patch for making it work is not in the same location

[web2py] Re: Blogitizor Issues

2010-03-17 Thread Thadeus Burgess
1. You don't have to do anything as long as you don't go to the ccache function in admin. Otherwise, you can replace the ccache function in controllers/admin.py with the ccache function in controllers/appadmin.py (also found in web2py welcome trunk). It is the same code, but the appadmin version

[web2py] passing vars ....

2010-03-17 Thread JmiXIII
Here I am once again. I've tried to find the explanation of the following fact but did not manage. I Have the following code in my controller: def saisie(): ... CodeOF=request.vars.OF or request.vars.META_OF Selection=FORM('Code OF:', INPUT(_name='OF',_value=CodeOF,requires=IS_IN_DB(db,

[web2py] Re: edit_area 0.8.1.1 ctl+s works

2010-03-17 Thread Wes James
This is interesting. If I take 0.8.1.1 from sourceforge, ctrl-s does not work. If I take 0.8.1.1 from web2py 1.74.9 then ctrl-s works. Is there some parameter that was set for ctrl-s to work and then was not set for 0.8.2 in latest web2py? -wes On Wed, Mar 17, 2010 at 1:11 PM, Wes James

[web2py] Re: edit_area 0.8.1.1 ctl+s works

2010-03-17 Thread Wes James
Odd, I see: case s: use = true; eA.execCommand(save); break; in this older code - same as my patch. Why is it there and not in other versions? weeeiirrr On Wed, Mar 17, 2010 at 2:18 PM, Wes James compte...@gmail.com wrote:

[web2py] Re: passing vars ....

2010-03-17 Thread mdipierro
The problem is that doing a POST to a url with GET variables is problematic since it is not in the html specs and different browsers may behave in different ways. It should be avoided. The solution is to pass request.vars.OF as a hidden form variable FORM(,hidden=dict(OF=CodeOF)) On Mar 17,

[web2py] Re: edit_area 0.8.1.1 ctl+s works

2010-03-17 Thread mdipierro
LOL. One of you added this to editarea long ago. I forgot so a few versions ago I upgraded editarea without patching it. You told us. So I fixed this in trunk (adding a credit to you). Massimo On Mar 17, 3:25 pm, Wes James compte...@gmail.com wrote: Odd, I see:             case s:          

[web2py] Re: edit_area 0.8.1.1 ctl+s works

2010-03-17 Thread Wes James
I just found 1.68.1 and it is not in the 0.8.1.1 edit_area. Someone along the line must have added the save and it just didn't make it over with the 0.8.2 update. -wes On Wed, Mar 17, 2010 at 2:25 PM, Wes James compte...@gmail.com wrote: Odd, I see:            case s:                use =

[web2py] Re: edit_area 0.8.1.1 ctl+s works

2010-03-17 Thread mdipierro
I think user CJ did. But my memory may fail. I am sure it is in the bazaar logs, but not in the hg logs. On Mar 17, 3:40 pm, Wes James compte...@gmail.com wrote: I just found 1.68.1 and it is not in the 0.8.1.1 edit_area.  Someone along the line must have added the save and it just didn't make

Re: [web2py] Re: Migrating web2py to GAE

2010-03-17 Thread Jonathan Lundell
On Mar 17, 2010, at 9:59 AM, mdipierro wrote: There is no cookbook because there is nothing to be done other than: 0) register with gae and get an app_id 1) change the name in app.yaml (first line: replace web2py with your app_id) 2) run it locally dev_appserver.py web2py 3) make

RE: [web2py] Re: no more cherrypy wsgiserver

2010-03-17 Thread Timothy Farrell
ab -n 1 -c 1000 -k http://localhost/ If your website is slow, Rocket will only speed it up if you have lots concurrent connections. -tim -Original Message- From: Michael Toomim too...@gmail.com Sent: Tuesday, March 16, 2010 5:32pm To: web2py-users web2py@googlegroups.com Subject:

[web2py] virtualfields

2010-03-17 Thread Jose
In what was virtualfields development. Reviewing these threads was not yet defined the syntax. http://www.google.com/url?sa=Dq=http://groups.google.com/group/web2py/browse_thread/thread/c684346f13773f93usg=AFQjCNH_O8OPkwXqLw9TOndBiAJhLNxVWw

Re: [web2py] virtualfields

2010-03-17 Thread Thadeus Burgess
http://thadeusb.com/weblog/view/web2py_virtualfields_as_an_orm_an_sqlalchemy_approach -Thadeus On Wed, Mar 17, 2010 at 5:41 PM, Jose jjac...@gmail.com wrote: In what was virtualfields development. Reviewing these threads was not yet defined the syntax.

[web2py] Re: virtualfields

2010-03-17 Thread Jose
On 17 mar, 23:25, Thadeus Burgess thade...@thadeusb.com wrote: http://thadeusb.com/weblog/view/web2py_virtualfields_as_an_orm_an_sql... -Thadeus Thank Thadeus, excellent. Jose -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this

[web2py] Re: virtualfields

2010-03-17 Thread Jose
Fails, in model/db.py db.define_table('sales', Field('item'), Field('item_total', 'double'), Field('tax_percentage', 'double'), Field('trans_date', 'datetime'), ) class Sales(): def total(self): return self.item_total * self.tax_percentage def tax(self):

[web2py] Set Set?

2010-03-17 Thread Jonathan Lundell
mrows = ((db(m.group_id == g.id)) (db(~(g.role.like('user_%').select(m.user_id, g.role) TypeError: unsupported operand type(s) for : 'Set' and 'Set' This doesn't seem right -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to

[web2py] Re: virtualfields

2010-03-17 Thread Jose
On 17 mar, 23:54, Jose jjac...@gmail.com wrote: Fails, in model/db.py db.define_table('sales',     Field('item'),     Field('item_total', 'double'),     Field('tax_percentage', 'double'),     Field('trans_date', 'datetime'), ) class Sales():     def total(self):         return

[web2py] Re: Where do you use web2py?

2010-03-17 Thread Richard
I use it to display results from my web scraping jobs. Am also working on a legal document editor for a client and a language learning app for myself. Richard On Mar 12, 8:42 pm, Giovanni Giorgi j...@objectsroot.com wrote: Hi all,  in the attempt to better knowing web2py and its community,

[web2py] Re: gae appadmin

2010-03-17 Thread Richard
to use appadmin on GAE I had to either use https or comment out the security checks On Mar 17, 12:16 pm, mattynoce mattyn...@gmail.com wrote: hi, i've looked at some posts but can't seem to make this work. i can get appadmin to work on my local version of gae launcher (on a mac), but when i

[web2py] Re: Planning to make a big project

2010-03-17 Thread Śląski
Thanks Massimo, So can you advice me - if i already make some projects on web2py (i didn't test them on some productive tasks) it would be sufficient for my job? Can I use web2py DAL on some relational aspects with object- relational dbms (postgresql) - with object and nested tables? The best

[web2py] Re: virtualfields

2010-03-17 Thread mr.freeze
I think you need to do: def sales(): rows = db(db.sales.id0).select() rows = rows.setvirtualfields(sales=Sales()) return dict(rows=rows) And remove this: db.sales.virtualfields.append(Sales()) On Mar 17, 7:01 pm, Jose jjac...@gmail.com wrote: On 17 mar, 23:54, Jose

[web2py] Re: virtualfields

2010-03-17 Thread mr.freeze
Scratch that, I didn't realize that virtualfields had been added to Table. On Mar 17, 7:11 pm, mr.freeze nat...@freezable.com wrote: I think you need to do: def sales():     rows = db(db.sales.id0).select()     rows = rows.setvirtualfields(sales=Sales())     return dict(rows=rows) And

[web2py] Re: virtualfields

2010-03-17 Thread Jose
On 18 mar, 00:11, mr.freeze nat...@freezable.com wrote: I think you need to do: def sales():     rows = db(db.sales.id0).select()     rows = rows.setvirtualfields(sales=Sales())     return dict(rows=rows) And remove this: db.sales.virtualfields.append(Sales()) works well, but what I

Re: [web2py] Set Set?

2010-03-17 Thread Jonathan Lundell
On Mar 17, 2010, at 4:58 PM, Jonathan Lundell wrote: mrows = ((db(m.group_id == g.id)) (db(~(g.role.like('user_%').select(m.user_id, g.role) TypeError: unsupported operand type(s) for : 'Set' and 'Set' This doesn't seem right Never mind; it's not that kind of Set. -- You

Re: [web2py] Re: virtualfields

2010-03-17 Thread Thadeus Burgess
Dope ! Thanks Jose. -Thadeus On Wed, Mar 17, 2010 at 7:23 PM, Jose jjac...@gmail.com wrote: On 18 mar, 00:11, mr.freeze nat...@freezable.com wrote: I think you need to do: def sales():     rows = db(db.sales.id0).select()     rows = rows.setvirtualfields(sales=Sales())     return

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread vince
Traceback (most recent call last): File /home/web2py/gluon/main.py, line 518, in wsgibase session._try_store_in_db(request, response) File /home/web2py/gluon/globals.py, line 356, in _try_store_in_db table._db(table.id == record_id).update(**dd) File /home/web2py/gluon/sql.py, line

[web2py] Re: Migrating web2py to GAE

2010-03-17 Thread mdipierro
You are right. I will find a place. On Mar 17, 4:36 pm, Jonathan Lundell jlund...@pobox.com wrote: On Mar 17, 2010, at 9:59 AM, mdipierro wrote: There is no cookbook because there is nothing to be done other than: 0) register with gae and get an app_id 1) change the name in app.yaml

[web2py] Re: gae appadmin

2010-03-17 Thread mdipierro
I advice you use https and you do not remove the security checks. https works out of the box on GAE anyway. On Mar 17, 7:03 pm, Richard richar...@gmail.com wrote: to use appadmin on GAE I had to either use https or comment out the security checks On Mar 17, 12:16 pm, mattynoce

[web2py] benchmarking: rocket vs pound with four rockets

2010-03-17 Thread Kuba Kucharski
This is probably obvious but I decided to try this myself: Should one run web2py with Pound on multi-core server? probably yes if you deal with concurrent connections.. This is my config: 2.6.31-19-generic-pae Intel(R) Xeon(R) CPU E5410 @ 2.33GHz Ubuntu 64bit one processor with 4 cores disk

[web2py] Re: Planning to make a big project

2010-03-17 Thread mdipierro
I am not sure I understand the question. I can tell you how I proceed: 1) make a prototype that does what I want. 2) deploy and see what happens 3) when I start having lots of hits try to reduce the number of queries using cache/memcache 4) eventually move some date or all data to a

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread mdipierro
I am pretty sure this is not a problem with sqlite timeout. It may be a concurrency issue. Do you use the thread module explicitly or multiprocessing or background processes? Can you post a minimalist app that allows to reproduce the problem? If not can you tells us a little more about the

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread mdipierro
Are you using multiple connections to the same database? db=DAL(...) On Mar 17, 7:51 pm, vince lapcc...@gmail.com wrote: Traceback (most recent call last):   File /home/web2py/gluon/main.py, line 518, in wsgibase     session._try_store_in_db(request, response)   File

[web2py] Re: benchmarking: rocket vs pound with four rockets

2010-03-17 Thread mdipierro
Did you compile the app before running the benchmarks? Can you say more about The most important thing: effects depend much on what you import. imports should be cached and should not make a difference. Massimo On Mar 17, 8:20 pm, Kuba Kucharski kuba.kuchar...@gmail.com wrote: This is

Re: [web2py] Re: benchmarking: rocket vs pound with four rockets

2010-03-17 Thread Kuba Kucharski
Did you compile the app before running the benchmarks? yes Can you say more about The most important thing: effects depend much on what you import. imports should be cached and should not make a difference. actually they don't, it is late, I was going to say extend/include not import --

Re: [web2py] Re: benchmarking: rocket vs pound with four rockets

2010-03-17 Thread Kuba Kucharski
I was going to say extend/include not import and even this is not true as I see now for small layout -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group,

Re: [web2py] benchmarking: rocket vs pound with four rockets

2010-03-17 Thread Alex Fanjul
maybe Im a bit ignorant, but what is pound? alex El 18/03/2010 2:20, Kuba Kucharski escribió: This is probably obvious but I decided to try this myself: Should one run web2py with Pound on multi-core server? probably yes if you deal with concurrent connections.. This is my config:

Re: [web2py] benchmarking: rocket vs pound with four rockets

2010-03-17 Thread Kuba Kucharski
http://web2py.com/book/default/section/11/12?search=pound http://www.apsis.ch/pound/ kernel is 2.6.31-14-server not PAE of course.. sorry for mistakes. I didn't mentioned but I had also executed some sysctl and ulimit tweaking before benchmarking. I ran tests again with the same configuration

Re: [web2py] Re: Where do you use web2py?

2010-03-17 Thread Kuba Kucharski
voice over ip data engine ( routing, billing, gui-backend, etc ) -- Kuba -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to

[web2py] Re: benchmarking: rocket vs pound with four rockets

2010-03-17 Thread mdipierro
I noticed that many vps hosting provide HAProxy these days. On Mar 17, 9:26 pm, Kuba Kucharski kuba.kuchar...@gmail.com wrote: http://web2py.com/book/default/section/11/12?search=poundhttp://www.apsis.ch/pound/ kernel is 2.6.31-14-server not PAE of course.. sorry for mistakes. I didn't

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread vince
mutliprocess yes. i am running under mod_wsgi with single thread but multi process. i do assume the sqlite driver should try to acquire the database file lock for a specific time instead of return error right away? or is there any way to catch the error and return some busy page? it should be

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread mdipierro
That should not be a problem. Do you get this regularly or occasionally? Is this a long running thread? On Mar 17, 10:15 pm, vince lapcc...@gmail.com wrote: mutliprocess yes. i am running under mod_wsgi with single thread but multi process. i do assume the sqlite driver should try to acquire

[web2py] Re: page layout question...

2010-03-17 Thread Heo
Thanks Massimo.. very clear explaination -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more

[web2py] Re: auth_group

2010-03-17 Thread weheh
Sorry, hamdy, but I don't think you answered the question. I have read the doc many times and understand how to operate groups, memberships, and permissions. The question is about structure. Consider the following situation. Users can register with the site. Users can create common interest