Results 1 to 4 of 4

Thread: How to read from a PostgreSQL Python

  1. #1
    Join Date
    Apr 2009
    Posts
    61

    How to read from a PostgreSQL Python

    I am using python but i don't know how to Read a PostgreSQL Database adapter for the Python programming language. It was written from scratch with the aim of being very small and fast, and stable as a rock. I have set myself as database administrator and operating system consultant by trade. But unable to go forward.

  2. #2
    Join Date
    Dec 2008
    Posts
    161

    Re: How to read from a PostgreSQL Python

    psycopg is a PostgreSQL database adapter for the Python programming language. Its main advantages are that it supports the full Python DBAPI 2.0 and it is thread safe at level 2. Execution within a transaction is a very good thing; it ensures data integrity and allows for appropriate error handling. However there are queries that can not be run from within a transaction.

  3. #3
    Join Date
    Jan 2006
    Posts
    211

    Re: How to read from a PostgreSQL Python

    psycopg is a PostgreSQL database adapter for the Python programming language (just like pygresql and popy.). If you would like your program to take input from the keyboard, you will also want to import the sys module. Its main advantages are that it supports the full Python DBAPI 2.0 and it is thread safe at level 2. The psycopg distribution includes ZPsycopgDA, a Zope Database Adapter. It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a conspicuous number of concurrent INSERTs or UPDATEs.

  4. #4
    Join Date
    Jan 2009
    Posts
    150

    Re: How to read from a PostgreSQL Python

    psycopg 2 is an almost complete rewrite of psycopg. psycopg is different from the other database adapter because it was designed for heavily multi-threaded applications that create and destroy. It supports all the features of psycopg which is different from the other database adapter because and was designed for heavily multi-threaded applications, but add real adaptation for Python to PostgreSQL type conversions, asynchronous queries, support for the Python built-in datetime module and the new (Python 2.4) Decimal type.

Similar Threads

  1. How to connect to Postgresql database
    By Xziibit in forum Software Development
    Replies: 5
    Last Post: 05-08-2011, 02:01 PM
  2. Improvements in PostgreSQL 8.3
    By Calan in forum Software Development
    Replies: 5
    Last Post: 18-11-2010, 04:07 AM
  3. How to read a file in reverse order in python?
    By MKAIF in forum Software Development
    Replies: 5
    Last Post: 20-02-2010, 06:56 PM
  4. ClassNotFoundException Error in PostgreSQL
    By Nurhan in forum Software Development
    Replies: 3
    Last Post: 06-03-2009, 12:51 PM
  5. Download Python 3.0 / Python 3000
    By Amaresh in forum Software Development
    Replies: 6
    Last Post: 24-02-2009, 09:28 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,481,809.62866 seconds with 16 queries