Hi,
i recently migrated from mysql to postgresql and did use severel python
postgres-modules. All do what they are designed for, so which one would
you use? psycopg, pygresql, pypgsql? psycopg seems to be the best
solution for heavy traffic/multiple connections .... i have no real
testing environment, so any advice which one to use for different
usecases would be nice.
Thanks, Roland 1 2073
Roland Heiber wrote: i recently migrated from mysql to postgresql and did use severel python postgres-modules. All do what they are designed for, so which one would you use? psycopg, pygresql, pypgsql? psycopg seems to be the best solution for heavy traffic/multiple connections .... i have no real testing environment, so any advice which one to use for different usecases would be nice.
Hi Roland,
We've been using psycopg (via Zope and straight Python programs) for about a
year and haven't had any problems at all. We don't store much binary data so I
don't know how well psycopg handles blobs and what-not, but performance and
reliability has been fine.
I have no idea how psycopg stacks up against the others; in the end we chose it
because the project appeared to be active, it was easy enough to set up, and a
few test scripts we made all worked (how's that for rigorous evaluation? ;-) ).
HTH,
Dave This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Irmen de Jong |
last post by:
QOTW: "Confronting the Martellibot is like flirting with an encyclopedia,
I'd rather not do it myself, but I respect those who do, because it
produces knowledge." -- Anton Vredegoor
"Python and Java are not diametrically opposed religions that must fight
to the death in jihad, despite the existence of loonies favoring exactly
that. They solve different problems; sometimes in similar ways, sometimes
not." ...
|
by: Ravi |
last post by:
Hi,
I'm looking for a Postgres connection Python module that has good
support for the BYTEA type.
By good support I mean that
-it should have a function to escape the raw binary data as appropriate.
-it must not choke on some rather large 20-30MB files.
-Retrieval using Select statements should be transparent (or pretty simple)
|
by: Steve |
last post by:
Hi,
I have postgres 7.4.1 running on my server and I've been trying to find
a good python-postgres interface module. I installed Pygres on another
machine running Linux using a RPM release and it works. However, I need
to do the same for an alpha server and I can't find source files for
PyGres that would compile with 7.4.1 anywhere. Can someone please help
me out? I need a good postgres python interface to work with.
Cheers,
|
by: Michael Lang |
last post by:
Hi to all,
can some one point me to the correct way, how to use PostgreSQLs "COPY" feature
from within python ?
What i want to do is:
connect
start transaction
drop current tablecontens
|
by: Adrian Immler |
last post by:
hello,
i have compiled and installed postgres8 --with-prefix=/usr/local/postgres8
(& several other options) and have no other version of postgres on my
system. python is compiled and make'd --with-prefix=/usr.
i have added the libpath of postgres to /etc/ld.so.conf and a ldconfig -v
also told me that the libraries are found. i tried to install PyGreSQL,
pyPgSQL and psycoPG. after i found out how to tell all those make systems
where my...
| |
by: Christoph Zwerschke |
last post by:
The latest Windows distribution of Python 2.4.2 is using the
msvcrt71.dll, while PostgreSQL is using msvcrt.dll.
This lead to the following problem:
I was using PyGreSQL to connect to the PostgreSQL database. There is a
function that prints a query object q simply by writing: "print q". What
happens on the lower levels is that PyObject_Print(q, stdout) is called,
where stdout is the stdout file descriptor of msvcrt71.dll. Then,...
|
by: H J van Rooyen |
last post by:
Hi,
I want to write a small system that is transaction based.
I want to split the GUI front end data entry away from the file handling and
record keeping.
Now it seems almost trivially easy using the sockets module to communicate
between machines on the same LAN, so that I want to do the record keeping on one
machine.
|
by: damacy |
last post by:
hi, there. i have this question which might sound quite stupid to some
people, but here we go anyway.
i have written a python program which interacts with a postgresql
database. what it does is simply drops an existing database called
'mytempdb'.
the code looks like below;
link = subprocess.Popen(command, stdin = subprocess.PIPE, stdout =
|
by: Pradip |
last post by:
Hello every body. I am new to this forum and also in Python.
Read many things about multi threading in python. But still having
problem.
I am using Django Framework with Python having PostgreSQL as backend
database with Linux OS. My applications are long running. I am using
threading.
The problem I am facing is that the connections that are being created
for database(postgres) update are not getting closed even though my
threads had...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |