Databases
StackOverflow2013
Postsdbo
POPython Implementation of the Object Pool Design Pattern
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPython Implementation of the Object Pool Design Pattern
    primarykey
    data
    text
    <p>I need an <a href="http://en.wikipedia.org/wiki/Object_pool" rel="noreferrer">Object Pool</a>, and rather than implement it myself, I thought I would look around for a ready-made and tested Python library.</p> <p>What I found was plenty of other people <a href="http://mail.python.org/pipermail/python-list/2009-July/719988.html" rel="noreferrer">looking</a>, but not getting many straight answers, so I have brought it over here to Stack Overflow.</p> <p>In my case, I have a large number of threads (using the <code>threading</code> module), which need to occasionally call a remote SOAP-based server. They could each establish their own connection to the server, but setting up a socket and completing the authentication process is expensive (it is throttled by the server), so I want to share a pool of connections, creating more only as needed.</p> <p>If the items to pool were worker subprocesses, I might have chosen <code>multiprocessing.pool</code>, but they are not. If they were worker threads, I might have chosen <a href="http://code.activestate.com/recipes/203871/" rel="noreferrer">this implementation</a>, but they are not.</p> <p>If they were MySQL connections, I might have chosen <a href="http://code.google.com/p/pysqlpool/" rel="noreferrer">pysqlpool</a>, but they are not. Similarly the <a href="http://www.sqlalchemy.org/docs/04/pooling.html" rel="noreferrer">SQLAlchemy Pool</a> is out.</p> <p>If there was one thread, using a variable number of connections/objects, I would consider <a href="http://www.devpicayune.com/entry/object-pooling-in-python" rel="noreferrer">this implementation</a>, but I need it to be thread-safe.</p> <p>I know I could implement this again fairly quickly, but given there are many people looking for it, I thought a canonical answer on Stack Overflow would be nice.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USgerry3
    1. USOddthinking
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPython Implementation of the Object Pool Design Pattern
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPython Implementation of the Object Pool Design Pattern
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POPython Implementation of the Object Pool Design Pattern
      1. USeveliotc
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload