RE: Python Postgresql complete guide

2018-08-23 Thread David Raymond
Looks good. Having used psycopg2 a fair amount, here are some suggestions I have on extra things to cover or emphasize. -Postgres specific things like remembering to "set search_path to blargh, public;" etc as needed before querying. -An example case of cur.fetchone() returning None, or more

Re: Python + PostgreSQL

2009-03-19 Thread Martin v. Löwis
> I saw in a different post that psycopg2 does work on Python 3.x as > long as a patch is applied (by Martin v. Löwis): > [...] > Do you know where can I find this patch It's linked in http://wiki.python.org/moin/Early2to3Migrations and lives in http://www.dcl.hpi.uni-potsdam.de/home/loewis/ps

Re: Python + PostgreSQL

2009-03-17 Thread Jeroen Ruigrok van der Werven
-On [20090318 04:01], Lobo (carlosgali...@gmail.com) wrote: >I am wondering whether I can jump directly to Python 3.x (instead of >using Python 2.6), depending of course on psycopg2 compatibility?. Might I suggest sticking to 2.6 for now? The 2.x series is what is now going around as 'stable' in

RE: Python + PostgreSQL

2009-03-17 Thread Jeff Peck
on.org] On Behalf Of Philip Semanchuk Sent: Tuesday, March 17, 2009 10:24 PM To: python-list (General) Subject: Re: Python + PostgreSQL On Mar 17, 2009, at 10:57 PM, Lobo wrote: > Many thanks to all for your valuable input. > > I've done some research and I believe I will use (at lea

Re: Python + PostgreSQL

2009-03-17 Thread Philip Semanchuk
On Mar 17, 2009, at 10:57 PM, Lobo wrote: Many thanks to all for your valuable input. I've done some research and I believe I will use (at least for now, to make it simple) psycopg2 module to connect Python to PostgreSQL. I am wondering whether I can jump directly to Python 3.x (instead of us

Re: Python + PostgreSQL

2009-03-17 Thread Lobo
Many thanks to all for your valuable input. I've done some research and I believe I will use (at least for now, to make it simple) psycopg2 module to connect Python to PostgreSQL. I am wondering whether I can jump directly to Python 3.x (instead of using Python 2.6), depending of course on psycop

Re: Python + PostgreSQL

2009-03-17 Thread Philip Semanchuk
On Mar 17, 2009, at 12:46 PM, Lobo wrote: Hi, I am new to this newsgroup (and new to Python and PostgreSQL). My experience (17+ years) has been with Smalltalk (e.g. VAST) and Object databases (e.g. Versant, OmniBase). I now have a new project to develop web applications using the latest/ best

Re: Python + PostgreSQL

2009-03-17 Thread Marco Mariani
Lobo wrote: I now have a new project to develop web applications using the latest/ best possible versions of Python (3.x?) with PostgreSQL (8.x?, with pgAdmin 1.10?). You want to use Python 2.5.x (or 2.6 if your framework of choice already supports it), Postgres 8.3 and have a look at SQLAlch

Re: Python + PostgreSQL

2009-03-17 Thread Krishnakant
hello, On Tue, 2009-03-17 at 09:46 -0700, Lobo wrote: > Hi, > > I am new to this newsgroup (and new to Python and PostgreSQL). My > experience (17+ years) has been with Smalltalk (e.g. VAST) and Object > databases (e.g. Versant, OmniBase). > Welcome to the world of monty pythons, /\/\/\: > I no

Re: Python, PostgreSQL, What next?

2006-12-02 Thread vbgunz
I need to thank you all for your suggestions and recommendations. I am ultimately aiming to work in Python, PostgreSQL and Django and this link http://www.sqlalchemy.org/news.myt#item_3 sort of made my day :) I really appreciate all of your feedback and will go through Fredrik's links as soon as I

Re: Python, PostgreSQL, What next?

2006-12-02 Thread jim-on-linux
Before commiting to a RDBMS take a look at Gadfly. Depending on what you need a RDB for, (light duty), or (heavy duty) take a look at gadfly. Gadfly is made from all python code. Use stardard SQL statements like Select, Create and Drop Tables, etc. Newest version GadflyB5 http://gadfly.so

Re: Python, PostgreSQL, What next?

2006-12-02 Thread Thomas Bartkus
On Fri, 01 Dec 2006 23:04:37 -0800, vbgunz wrote: > Hello all, > > I've studied Python and studied PostgreSQL. What is the absolute next > best step to take to merge these two finely together? I've heard of > SQLAlchemy and some others but before I dive in, I would really like > the opinion of th

Re: Python, PostgreSQL, What next?

2006-12-02 Thread Fredrik Lundh
vbgunz wrote: > I've studied Python and studied PostgreSQL. What is the absolute next > best step to take to merge these two finely together? the db-api interface: http://www.python.org/dev/peps/pep-0249/ db-api compliant postgresql adapters: http://www.pygresql.org/ http://www.initd.

Re: Python, PostgreSQL, What next?

2006-12-02 Thread patkinson
Hi, Look at DJANGO;-) http://www.djangoproject.com/ http://www.djangobook.com/ Regards Peter Atkinson vbgunz ha escrito: > Hello all, > > I've studied Python and studied PostgreSQL. What is the absolute next > best step to take to merge these two finely together? I've heard of > SQLAlchemy

Re: Python, PostgreSQL, What next?

2006-12-02 Thread Armin
> I've studied Python and studied PostgreSQL. Good. >What is the absolute next best step to take to merge these two finely >together? I've heard of Just download psycopg2. Python and PostgreSQL are a match made in heavan. Make your connection, do querys, get data, earn profits. Object-Rel

Re: Python, PostgreSQL, What next?

2006-12-01 Thread Godson
On 1 Dec 2006 23:04:37 -0800, vbgunz <[EMAIL PROTECTED]> wrote: Hello all, I've studied Python and studied PostgreSQL. What is the absolute next best step to take to merge these two finely together? I've heard of SQLAlchemy and some others but before I dive in, I would really like the opinion o