Python 2.4 binaries for accessing PostgreSQL from Windows?

F

Frank Millman

Hi all

The subject line says it all.

I have been using pypgsql to access PostgreSQL from Linux and from
Windows, and it works fine.

I am upgrading to Python 2.4. I can recompile pypgsql for Linux, but I
do not have a Windows compiler. SourceForge has a binary for Python
2.3, which is the one I have been using. It does not have one for 2.4.

I tried the psycopg site, but it does not seem to have binaries at all.

Does anyone know if either of these will be available in binary form
for Python 2.4 on Windows?

Thanks

Frank Millman
 
G

Gerhard Haering

Hi all

The subject line says it all.

I have been using pypgsql to access PostgreSQL from Linux and from
Windows, and it works fine.

I am upgrading to Python 2.4. I can recompile pypgsql for Linux, but I
do not have a Windows compiler. SourceForge has a binary for Python
2.3, which is the one I have been using. It does not have one for 2.4.

I tried the psycopg site, but it does not seem to have binaries at all.

Does anyone know if either of these will be available in binary form
for Python 2.4 on Windows?

http://ghaering.de/pypgsql/

These are SSL-enabled dynamically linked and need the PostgreSQL client
libraries installed. I recommend the ones from PgAdmin3, which have SSL
support. They were only tested with these.

-- Gerhard

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFCA07pdIO4ozGCH14RAp2xAJ4rgLSxqB6svY/pt0TNqPMr4sUOsACdGALr
0SlqgWkbjRzcHlLkc6ggB1o=
=bNvl
-----END PGP SIGNATURE-----
 
F

Frank Millman

Frank said:
Hi all

The subject line says it all.

I have been using pypgsql to access PostgreSQL from Linux and from
Windows, and it works fine.

I am upgrading to Python 2.4. I can recompile pypgsql for Linux, but I
do not have a Windows compiler. SourceForge has a binary for Python
2.3, which is the one I have been using. It does not have one for 2.4.

I tried the psycopg site, but it does not seem to have binaries at all.

Does anyone know if either of these will be available in binary form
for Python 2.4 on Windows?

Thanks for your replies, Gerhard and Josef. I have looked at both
solutions, but neither of them seem quite ideal. Hopefully you can show
me a simple way to overcome my problems.

In the case of pyPgSQL, it is overkill for me to load PgAdmin3 on each
Windows workstation running my accounting app. The binary for Python2.3
had a small libpq.pyd which was perfect for my needs. Don't you have
something similar for 2.4?

I have tried psycopg, and I must say I like it. It installs very
easily, and seems faster than pyPgSQL. My initial testing worked fine,
but as soon as I tried to use it from my app I ran into a problem. I
use wxPython as my front end, and it returns all strings as Python
unicode objects. If I pass these to a query, I get "TypeError: argument
1 must be str, not unicode". I could go through my app and convert all
strings back to type str, but it seems unnecessary. Is there a better
solution?

TIA for any advice.

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top