pg_simple

The pg_simple module provides a simple yet efficient layer over psycopg2 providing Python API for common SQL functions, explicit and implicit transactions management and database connection pooling for single and multi-threaded applications.

pg_simple is not intended to provide ORM-like functionality, rather to make it easier to interact with the PostgreSQL database from python code for direct SQL access using convenient wrapper methods. The module wraps the excellent psycopg2 library and most of the functionality is provided by this behind the scenes.

The pg_simple module provides:

• Simplified handling of database connections/cursor
• Connection pool for single or multithreaded access
• Python API to wrap basic SQL functionality: select, update, delete, join et al
• Query results as python namedtuple and dict objects (using psycopg2.extras.NamedTupleCursor and psycopg2.extras.DictCursor respectively)
• Debug logging support

• Installation
• 30 Seconds Quick-start Guide
• Connection pool management
  • Initialize the connection pool
  • Configure connection pool for thread-safe access
  • Disable connection pooling
  • Obtaining the current connection pool manager
  • Garbage collect stale connections
• Basic Usage
  • Connecting to the posgtresql server
  • Raw SQL execution
  • Dropping and creating tables
  • Emptying a table or set of tables
  • Inserting rows
  • Updating rows
  • Deleting rows
  • Inserting/updating/deleting rows with return value
  • Fetching a single record
  • Fetching multiple records
  • Explicit database transaction management
  • Implicit database transaction management