Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 28-07-2009
Member
 
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.
Reply With Quote
  #2  
Old 28-07-2009
Member
 
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.
Reply With Quote
  #3  
Old 28-07-2009
Member
 
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.
Reply With Quote
  #4  
Old 28-07-2009
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 02:22 AM.