[web2py] Re: Database access without DAL but with connection pool

2014-03-20 Thread Cliff Kachinske
Derek, the conventional wisdom is connecting to a db is expensive. I'm willing to be convinced, but I need some data. Can you point me to some? Because if your statement is true, we could eliminate some pretty hairy code in the DAL to support pooling. On Wednesday, March 19, 2014 7:44:10 PM

[web2py] Re: Database access without DAL but with connection pool

2014-03-20 Thread Derek
I can't point you to any, you are welcome to do tests yourself. (note: this is why i said believe it or not) On Thursday, March 20, 2014 6:22:20 AM UTC-7, Cliff Kachinske wrote: Derek, the conventional wisdom is connecting to a db is expensive. I'm willing to be convinced, but I need some

[web2py] Re: Database access without DAL but with connection pool

2014-03-19 Thread Massimo Di Pierro
I am not sure about pymongo but if you use DAL('mongodb:') the dal will do pooling for you. On Wednesday, 19 March 2014 01:33:04 UTC-5, tec...@gmail.com wrote: Dear Sirs, I understand it's possible to use databases without DAL. For example function in controller: def values():

[web2py] Re: Database access without DAL but with connection pool

2014-03-19 Thread tech . uz
Hello Massimo, Thank you for reply. On Wednesday, March 19, 2014 7:20:27 PM UTC+5, Massimo Di Pierro wrote: I am not sure about pymongo but if you use DAL('mongodb:') the dal will do pooling for you. Ok, I will check this. Actually I don't want to use pymongo only, it could any

[web2py] Re: Database access without DAL but with connection pool

2014-03-19 Thread LightDot
Well, if you want to do it without the DAL, there are several options that might just work without any additional code: - check if specific python libs that you'll use for the db connection already provide a similar pooling function, they might - check if the database backend natively provides

[web2py] Re: Database access without DAL but with connection pool

2014-03-19 Thread Derek
I'd say the answer to 2 is 'not really'. Believe it or not, opening and dropping database connections is a fast operation. On Tuesday, March 18, 2014 11:33:04 PM UTC-7, tec...@gmail.com wrote: Dear Sirs, I understand it's possible to use databases without DAL. For example function in