Hello,
I am currently using psycopg 2 as my db adapter for a mod_python &
PostgreSQL web app. It's works fine, and I haven't any complaints. I
would appreciate some input on what other pythonistas like in an
adapter. There were several different options available to me, but there
was no particular informed reason for me to choose psycopg. Am I missing
anything?
~ Anthony 3 1549
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Keen Anthony wrote: Hello,
I am currently using psycopg 2 as my db adapter for a mod_python & PostgreSQL web app. It's works fine, and I haven't any complaints. I would appreciate some input on what other pythonistas like in an adapter. There were several different options available to me, but there was no particular informed reason for me to choose psycopg. Am I missing anything?
Considering pyPgSQL, psycopg1, PyGreSQL and psycopg2 - psycopg2 is a good
choice.
There's also interesting development happening here: http://python.projects.postgresql.org/ - but it seems to be in the midst of
development.
- -- Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFEU17XdIO 4ozGCH14RAsQyAK CS5opydZzciB8bC DbKqDWTLWeRHgCg mLpQ
e40YgQmGCJfApvB NSVYX5kk=
=L1El
-----END PGP SIGNATURE-----
Gerhard Häring wrote: Keen Anthony wrote: Hello,
I am currently using psycopg 2 as my db adapter for a mod_python & PostgreSQL web app. It's works fine, and I haven't any complaints. I would appreciate some input on what other pythonistas like in an adapter. There were several different options available to me, but there was no particular informed reason for me to choose psycopg. Am I missing anything?
Considering pyPgSQL, psycopg1, PyGreSQL and psycopg2 - psycopg2 is a good choice.
Hmmm, Gerhard, you are listed as one of two developers for pyPgSQL on
SourceForge ( http://sourceforge.net/projects/pypgsql/ ). The fact that
you are recommending a different DB adaptor project suggests a degree of
disengagement with pyPgSQL. Is Billy G. Allie still interested in
pyPgSQL, or is it now completely unloved? If so, then perhaps some new
maintainers can be found for it - several projects rely on pyPgSQL,
including ours ( http://sourceforge.net/projects/netepi/ ) - for which
we currently need to provide our own pyPgSQL tarball rolled from CVS
plus some of our own minor but important patches - which were submitted
for consideration but have not (AFAIK) been checked into the pyPgSQL
CVS. The latest tarball for pyPgSQl available from the pyPgSQL
SourceForge pages is dated 2003.
No criticism is intended in any of the foregoing observations - it is
inevitable that people move on to new projects (such as pySQLite), but
it would be a shame if pyPgSQL just rotted, because it has several
things in its favour, such as some unit tests (which were conspicuously
absent from any of the alternatives when we evaluated them in 2003 -
perhaps they have been added by now). Overall we have found pyPgSQL to
be very reliable.
Tim C
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Tim Churches wrote: Gerhard Häring wrote:[...] Considering pyPgSQL, psycopg1, PyGreSQL and psycopg2 - psycopg2 is a good choice. Hmmm, Gerhard, you are listed as one of two developers for pyPgSQL on SourceForge ( http://sourceforge.net/projects/pypgsql/ ). The fact that you are recommending a different DB adaptor project suggests a degree of disengagement with pyPgSQL.
It's not that I'd now say that pyPgSQL is bad software, but as you say it
didn't see a lot of maintenance the last two years, and AFAIK this won't
change anytime soon.
With the last release, it was pretty much feature complete, and Billy G.
Allie and me were talking about a rewrite of many parts in C for increased
performance, and for taking advantage of the new PostgreSQL API. I told him
that I was unfortunately too busy with other things to contribute
significantly to pyPgSQL. I see myself more as a helper for pyPgSQL nowadays.
Is Billy G. Allie still interested in pyPgSQL, or is it now completely unloved?
AFAIK he is still interested and committing fixes to the current codebase
now and then and working on the rewrite.
I don't know, however, if there's a plan for the long overdue maintenance
release to the last release from 2003.
If so, then perhaps some new maintainers can be found for it [...]
I'll just cc Billy so he can comment :-)
- several projects rely on pyPgSQL, including ours ( http://sourceforge.net/projects/netepi/ ) - for which we currently need to provide our own pyPgSQL tarball rolled from CVS plus some of our own minor but important patches - which were submitted for consideration but have not (AFAIK) been checked into the pyPgSQL CVS. The latest tarball for pyPgSQl available from the pyPgSQL SourceForge pages is dated 2003.
No criticism is intended in any of the foregoing observations - it is inevitable that people move on to new projects (such as pySQLite), but it would be a shame if pyPgSQL just rotted, because it has several things in its favour, such as some unit tests (which were conspicuously absent from any of the alternatives when we evaluated them in 2003 - perhaps they have been added by now). Overall we have found pyPgSQL to be very reliable.
- -- Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFEU3l/dIO4ozGCH14RAm7 uAJ9AE5TnPvDL6I c0z6Cf+QSSlkWnR wCgirdy
TQnyqOyWMGX2KbG E+gFKIZU=
=cTbz
-----END PGP SIGNATURE----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Scott Holmes |
last post by:
I've yet to write anything worthwhile with Python, but I have been
working my way through the O'Reilly books and scanning this list. I am
considering porting a legal case management system to python and would
like some input as to the best configuration of modules and interfaces
for this. I wish to use PostgreSQL for a database engine and tie into
OpenOffice as well. I need to be able to develop a suite of GUI
programs with a fairly...
|
by: Ian S. Nelson |
last post by:
What's the current state of Python and PostgreSQL? There is PoPy,
PygreSQL and PsycoPG, maybe others? PygreSQL was part of the PostgreSQL
tree, now it's not. What's up with it?
Then a Zope wrapper for it. ZPygresql seems to be dead. Anyone in the
know have any ideas on what's the best right now and has the most
promise of being supported?
thanks,
Ian
|
by: Dennis Gearon |
last post by:
Anyone got links to good db server boxes, not rackmount though?
Include any for HP, Gateway, etc.
--
"You are behaving like a man",
is an insult from some women,
a compliment from a good woman.
|
by: phil campaigne |
last post by:
On Mon, 1 Mar 2004, phil campaigne wrote:
>> Nigel J. Andrews wrote:
>>
>
>
>>> >On Mon, 1 Mar 2004, Phil Campaigne wrote:
>>> >
>>> >
|
by: Francois Suter |
last post by:
Hi all,
I have received via the Advocacy questions about optimising a database
server using PostgreSQL. The people asking the questions are planning
to buy a new machine, solely dedicated to serving PostgreSQL. Being no
specialist of optimisation, could someone help?
They are interested in the 64-bit compatibility and are wondering which
is better: a machine equiped with Opteron or AMD Athlon 64 3800?
| |
by: Andy |
last post by:
Someone posted this official proposal to create
comp.databases.postgresql.general again. He wrote his own charter. As
far as I know, he did not consult any of the postgresql groups first.
There may be an upcoming vote on this, so please stay informed and read
news.newgroups.announce for updates.
Also see message <2uu44nF2eodc0U1@uni-berlin.de> for an example of the
proponent's temperament.
|
by: cindy |
last post by:
this is the call
private void Page_Load(object sender, System.EventArgs e)
{
OdbcConnection connection = new OdbcConnection ("DSN=PFW52");
CreateDataAdapter(connection);
}
this is the code, no errors, but NO UPDATE I have to use ODBC I just
need to update a field based on a key, EMBARASSED to say days going
|
by: kleinhans |
last post by:
Hi netters,
I am used in MYSQL + PHP. Sometimes POSTGRESQL + PYTHON/ZOPE was used.
Now I have to build a bibliography system that stores a lot of
XML-Files and I am not quite sure wether it is a good idea to stick to
the good old sql-databases and go ahead with the same old techniques I
am using all the time.
Well, let's see what's available:
|
by: Hussein B |
last post by:
Hey,
Which Adapter to use with PostgreSQL:
PyPgSQL, psycopg or PyGreSQL?
Thanks.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| | |