[web2py] Re: Database Access Layer (Not to be confused with database abstraction layer)

2014-10-03 Thread Massimo Di Pierro
If you use the latest web2py there is this code on welcome/controllers/default.py @auth.requires_login() def api(): """ this is example of API with access control

[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 so

[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 UTC

[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

[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 su

[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 a

[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

2011-06-09 Thread pbreit
We might more detail about what you are trying to do including some code samples.

[web2py] Re: database access

2011-02-17 Thread stargate
Is there a example on how to do this. Thanks for all the help On Feb 17, 11:50 am, stargate wrote: > So its better to start with a mySQl database and connect to that > database then using the mysql lite database.  What I like is out of > the box web2py has a user login now is it possible to exp

[web2py] Re: database access

2011-02-17 Thread stargate
So its better to start with a mySQl database and connect to that database then using the mysql lite database. What I like is out of the box web2py has a user login now is it possible to export that login structure to a mysql database and what file would i have to change in web2py so it will always

[web2py] Re: database access

2011-02-17 Thread villas
Well I try to only use DB admin tools to examine the data and occasionally edit it and perhaps create and optimise indexes etc, usually once my app is stable. Bear in mind that anything you do in a DB admin tool will make it more difficult to migrate your app to another database, so try to accomp

[web2py] Re: database access

2011-02-17 Thread stargate
So saying that how do I add a username and password to the database and give the user permissions to insert delete view records. I also what to be able to connect to the database using a db tool to examine and administrate my db. Which one would you recommend. On Feb 17, 7:15 am, villas wrot

[web2py] Re: database access

2011-02-17 Thread villas
You can use ANY suitable tool to examine/administrate your DB independently of web2py. On Feb 17, 4:04 am, stargate wrote: > It's just a database admin tool for mysql.  I just want to be able to > access the mysql lite database that comes with web2py using mysqlfront > > On Feb 16, 10:22 pm, Ric

[web2py] Re: database access

2011-02-16 Thread stargate
It's just a database admin tool for mysql. I just want to be able to access the mysql lite database that comes with web2py using mysqlfront On Feb 16, 10:22 pm, Richard Vézina wrote: > I think you should provide information about mysqlfront and how you think it > could work with Web2py. > > Pers

Re: [web2py] Re: database access

2011-02-16 Thread Richard Vézina
I think you should provide information about mysqlfront and how you think it could work with Web2py. Personnaly I am not aware of anything about mysqlfront... Richard On Wed, Feb 16, 2011 at 9:40 PM, stargate wrote: > Is it possible to do this > > > On Feb 16, 9:51 am, stargate wrote: > > Whe

[web2py] Re: database access

2011-02-16 Thread stargate
Is it possible to do this On Feb 16, 9:51 am, stargate wrote: > When running web2py how do i access the mysql database using a > applicaiton like > > http://www.mysqlfront.de/wp/download/ > > Also when creating a new application using the application wizard it > has no indication to specify a us