Webware for Python

> Reading the webware doc and website, I found nothing to take care about 
> external connections handling.
> Do I have to manage my own opened connections pool which is accessed by 
> all threads concurrently?
> Should there be a connection per thread?
> Is there a Thread instance, so I can store a connection handler?

There are two possibilities. Either as you suggested, you create one 
connection per thread, or you use a connection pool. The former makes 
sense when you configure Webware in AppServer.config with a fixed number 
of threads. If it is configured dynamic, so that threads are constantly 
created and destroyed, it is better to use the connection pool approach.

MiscUtils.DBPool provides a simple connection pool. DBUtils 
(www.w4py.org/DBUtils) provides a more sophisticated solution and 
support for both, connection pool and thread affine connections.

-- Christoph

It may also depend on what database you are using. With MySQL, I have not seen
any speed-up when using a pool, so I've done away with it and just create a new
connection each time.

Quoting Christoph Zwerschke <cito@...>:

> > Reading the webware doc and website, I found nothing to take care about 
> > external connections handling.
> > Do I have to manage my own opened connections pool which is accessed by 
> > all threads concurrently?
> > Should there be a connection per thread?
> > Is there a Thread instance, so I can store a connection handler?
> 
> There are two possibilities. Either as you suggested, you create one 
> connection per thread, or you use a connection pool. The former makes 
> sense when you configure Webware in AppServer.config with a fixed number 
> of threads. If it is configured dynamic, so that threads are constantly 
> created and destroyed, it is better to use the connection pool approach.
> 
> MiscUtils.DBPool provides a simple connection pool. DBUtils 
> (www.w4py.org/DBUtils) provides a more sophisticated solution and 
> support for both, connection pool and thread affine connections.
> 
> -- Christoph
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Webware-discuss mailing list
> Webware-discuss@...
> https://lists.sourceforge.net/lists/listinfo/webware-discuss
> 




----------------------------------------
This mail sent through http://www.mywaterloo.ca

> It may also depend on what database you are using. With MySQL, I have not seen
> any speed-up when using a pool, so I've done away with it and just create a new
> connection each time.

Even more, it depends on which type of queries you are using. Read-only, 
read-write, transactions composed of several sql commands, long-running 
queries etc.

-- Christoph

Sophana Kok wrote:
> I'm a webware beginner.
> I would like to use sqlobject with webware and kid.

If you are using SQLObject, it handles the connections for you.


-- 
Ian Bicking  /  ianb@...  /  http://blog.ianbicking.org

> If you are using SQLObject, it handles the connections for you.

I haven't tried out SQLObject so far, but that sounds like I should give 
it a try. How does this work? Does it use a connection pool?

-- Chris

Christoph Zwerschke wrote:
>> If you are using SQLObject, it handles the connections for you.
> 
> 
> I haven't tried out SQLObject so far, but that sounds like I should give 
> it a try. How does this work? Does it use a connection pool?

Yep.  BTW, in SQLObject 2 / sqlapi I actually am borrowing some code 
from DBUtils to split the pooling out into a separate layer: 
http://svn.sqlobject.org/sqlapi/trunk/sqlapi/connect

Though I haven't figured out quite how it should work.  For instance, 
SQLite connections can't be pooled, they need to be allocated 
per-thread.  And I'm not sure if pooling is generally good or not -- 
per-thread connections seem a bit safer and otherwise just as good.

-- 
Ian Bicking  /  ianb@...  /  http://blog.ianbicking.org

Ian Bicking wrote:

> Sophana Kok wrote:
>
>> I'm a webware beginner.
>> I would like to use sqlobject with webware and kid.
>
>
> If you are using SQLObject, it handles the connections for you.
>
>
Ok thanks, I just had a look in the source, seems that I just need to 
set the sqlhub.processConnection global in one of my modules (not in a 
method), then a connection will be created per thread. Nothing to do. 
(very nice indeed)
But what if the connections get broken, will they restart automaticaly?

About speed, what (free) database is the fastest? I need to sort with 
the distances from one point. I don't know yet the tables sizes, but 
they could be big (I may need scalability). I've heard that postgreSQL 
can be better than mysql. What do you think?