Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Changes between Version 5 and Version 6 of PostgreSql


Ignore:
Timestamp:
03/01/06 03:16:52 (9 years ago)
Author:
cliff@…
Comment:

Reviewing SQLObject source, section about adapters is wrong. psycopg is the default.

Legend:

Unmodified
Added
Removed
Modified
  • PostgreSql

    v5 v6  
    44 
    55 
    6 == Selecting the appropriate adapter == 
     6== The DSN == 
    77 
    8 The Turbogears docs suggest using a DSN like  
     8The basic form of a DSN for using PostgreSQL is as follows: 
    99 
    1010{{{ 
     
    1212}}} 
    1313 
    14 From looking at the SQLObject source however, this appears suboptimal.  SQLObject tries several PostgreSQL adapters in this order 
     145432 is the default port for PostgreSQL, but may vary depending on configuration. 
    1515 
    16 PyGreSQL (aka pgdb), psycopg2, psycopg 
    17  
    18 From my own experience, psycopg is far superior to pgdb.  Therefore I suggest instead to use the scheme 
    19  
    20 {{{ 
    21 psycopg://user:passwd@host:5432/dbname 
    22 }}} 
    23  
    24 This ensures that psycopg is the chosen adapter. 
    2516 
    2617== Using a Unix domain socket ==