[web2py] Per-user persistent database connections

2010-09-27 Thread Josh J
Most applications connect to the database with one set of credentials, regardless of the user accessing the pages. The current pooling model works very well in this situation. My application must implement per-user connections to the database, where each user will have their own credentials for th

[web2py] Re: Per-user persistent database connections

2010-09-28 Thread Josh J
: > > I would not know how to do this. If you have a lot of users (say 1000) > > how do you know when to close a connection? Do you keep all of them > > open? > > > On Sep 27, 3:25 pm, Josh J wrote: > >> Most applications connect to the database with one set of

[web2py] special characters in database credentials

2010-09-29 Thread Josh J
Hey all, I've found an issue with SQLDB when developing my application. The URI handling does not allow special characters in database passwords. Unfortunately, I must connect to the database from my application using a password with special characters. eg. Consider the URI for a database

[web2py] Re: special characters in database credentials

2010-09-30 Thread Josh J
On Sep 29, 11:35 am, mdipierro wrote: > Ignore my previous email... there is no need with a patch for what you > are suggestion...let me think about this some more. > > On Sep 29, 11:01 am, Josh J wrote: > > > Hey all, > > >         I've found an issue wit

[web2py] Re: special characters in database credentials

2010-10-18 Thread Josh J
if not passwd: passwd = '' host = m.group('host') @@ -1205,10 +1211,10 @@ ).match(self._uri[11:]) if not m: raise SyntaxError, "Invalid URI string in SQLDB" -user = m

[web2py] Re: special characters in database credentials

2010-10-20 Thread Josh J
I sent it on monday to your @cs.depaul.edu account On Oct 18, 10:33 am, mdipierro wrote: > can you please email it to me? > > On Oct 18, 10:30 am, Josh J wrote: > > > Hey Massimo, > > > I've taken the initiative and built a patch to allow encoded > > c