Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread John R Pierce
On 5/10/2017 2:43 PM, Adrian Klaver wrote: 1) Uber 2)Yahoo 3) Instagram and, each of those giant businesses has their own entirely custom 'platforms', so its not really fair to call them 'largest web platforms' as each of those custom platforms is in use at only one business. Sure, larges

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread Adrian Klaver
On 05/10/2017 12:46 PM, Paul Hughes wrote: Adrian Klaver Wrote: Many on this list(myself included) will want to know how you came to that conclusion and I am speaking as someone who uses Python, Django and Postgres. I came to that conclusion when I saw a list of the top 15 websites (based on

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread Gavin Flower
Hi Paul, See comments at the end... On 10/05/17 08:00, Paul Hughes wrote: Thank you all for taking the time to answer my questions. I've been out of the programming world for a long time, so I am back to being a newbie. Even if you stay in the game, technology changes - so one has to keep lea

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread Paul Hughes
Adrian Klaver Wrote: >>Many on this list(myself included) will want to know how you came to that conclusion and I am speaking as someone who uses Python, Django and Postgres. I came to that conclusion when I saw a list of the top 15 websites (based on traffic). On that list, *all* of the sites th

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread Adrian Klaver
On 05/09/2017 01:00 PM, Paul Hughes wrote: Thank you all for taking the time to answer my questions. I've been out of the programming world for a long time, so I am back to being a newbie. I was told this is the place for newcomers to ask questions. I apologize if my questions did not contain t

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread Paul Hughes
Thank you all for taking the time to answer my questions. I've been out of the programming world for a long time, so I am back to being a newbie. I was told this is the place for newcomers to ask questions. I apologize if my questions did not contain the necessary sophistication or nuance for some

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread Karsten Hilbert
On Mon, May 08, 2017 at 05:45:53PM -0700, Paul Hughes wrote: > Why are Postgres and Python so married, I dare say that's a misconception. However, Python "works so well", that "professional amateurs" (like myself) who gravitate towards PostgreSQL for the obvious reasons might tend to chose Pytho

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread Dick Kniep
As a long time user of the combination, Postgresql, Python, Django, Flask etc. here are my 2 cents: The frameworks of python; Django (enormous) or Flask (smaller) and there are more, are of superb quality, battle hardened and are used in many many companies and high volume sites around the wor

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Steve Crawford
On Mon, May 8, 2017 at 2:26 PM, Paul Hughes wrote: > Hello, > > I noticed that most of the largest web platforms that use PostgreSQL as > their primary database, also use Python as their primary back-end language. > Yet, according to every benchmark I could find over the last couple of > years, b

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread George Neuner
On Mon, 8 May 2017 14:26:02 -0700, Paul Hughes wrote: >Hello, > >I noticed that most of the largest web platforms that use PostgreSQL as >their primary database, also use Python as their primary back-end language. >Yet, according to every benchmark I could find over the last couple of >years, bac

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Francisco Olarte
On Tue, May 9, 2017 at 1:44 PM, vinny wrote: > In fact, I don't think many companies/developers even choose a language > or database, but rather just use whatever they have experience in. That is choosing. You choose them because you know them. Francisco Olarte. -- Sent via pgsql-general mai

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Geoff Winkless
On 8 May 2017 at 22:26, Paul Hughes wrote: > I noticed that most of the largest web platforms that use PostgreSQL as > their primary database, also use Python as their primary back-end language. > Yet, according to every benchmark I could find over the last couple of > years, back-end languages l

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Peter Devoy
> My question still remains though - why is it that all the largest web > platforms that have used PostgreSQL *specifically* choose Python as their > back-end language? If you write the developers a nice tweet or e-mail they might tell you. Anything else is going to be speculation because th

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Guyren Howe
On May 9, 2017, at 2:07 , Paul Hughes wrote: > > Postgres might be a popular choice among Rails devs, but Ruby is not as > popular among the big web platforms that choose Postgres. Ahem. AirBnB, Bloomberg, Crunchbase, Github, Groupon, Heroku, Hulu, Kickstarter, Scribd, Shopify, Slideshare, S

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread D'Arcy Cain
On 2017-05-09 05:26 AM, Francisco Olarte wrote: Do you have any data supporting that? AFAIK people tend to choose the language first, database second, not the other way round, and many times the platform language is nailed, but the db can be changed. Also, WHICH platforms are you referring to?

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread vinny
On 2017-05-09 11:26, Francisco Olarte wrote: Paul: On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote: My question still remains though - why is it that all the largest web platforms that have used PostgreSQL *specifically* choose Python as their back-end language? Do you have any data s

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Neil Anderson
On 9 May 2017 at 06:20, Neil Anderson wrote: > On 9 May 2017 at 05:26, Francisco Olarte wrote: >> Paul: >> >> On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote: >>> My question still remains though - why is it that all the largest web >>> platforms that have used PostgreSQL *specifically* c

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Neil Anderson
On 9 May 2017 at 05:26, Francisco Olarte wrote: > Paul: > > On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote: >> My question still remains though - why is it that all the largest web >> platforms that have used PostgreSQL *specifically* choose Python as their >> back-end language? > > Do y

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-09 Thread Francisco Olarte
Paul: On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote: > My question still remains though - why is it that all the largest web > platforms that have used PostgreSQL *specifically* choose Python as their > back-end language? Do you have any data supporting that? AFAIK people tend to choos

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-08 Thread Neil Anderson
I'm also interested to know which frameworks you're referring to? Regarding Node and Mongo I imagine that they are well suited because Mongo stores JSON documents and Node, being Javascript, has first class support for JSON. Python and PostgreSQL's relationship might be more of a principled one? P

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-08 Thread Paul Hughes
Thank you for the links. I'm glad there are other languages that are working with PostgreSQL. My question still remains though - why is it that all the largest web platforms that have used PostgreSQL *specifically* choose Python as their back-end language? Why are Postgres and Python so married, in

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-08 Thread Adrian Klaver
On 05/08/2017 05:45 PM, Paul Hughes wrote: Thank you for the links. I'm glad there are other languages that are working with PostgreSQL. My question still remains though - why is it that all the largest web platforms that have used PostgreSQL *specifically* choose Python as their back-end langu

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-08 Thread Adrian Klaver
On 05/08/2017 02:26 PM, Paul Hughes wrote: Hello, I noticed that most of the largest web platforms that use PostgreSQL as their primary database, also use Python as their primary back-end language. Yet, according to every benchmark I could find over the last couple of years, back-end languages l

[GENERAL] Python versus Other Languages using PostgreSQL

2017-05-08 Thread Paul Hughes
Hello, I noticed that most of the largest web platforms that use PostgreSQL as their primary database, also use Python as their primary back-end language. Yet, according to every benchmark I could find over the last couple of years, back-end languages like PHP, HHVM, and Node.JS outperform Python

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-06-02 Thread Adrian Klaver
On 06/02/2015 01:24 AM, Rémi Cura wrote: Hey, python is installed from official binary, 64 b for windows, in C/Python32 I can't remember the argument, but it might be irrelevant. The problem doesn't seem to be to install numpy, it works perfectly in the regular terminal. The problem seems to be

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-06-02 Thread Rémi Cura
Hey, python is installed from official binary, 64 b for windows, in C/Python32 I can't remember the argument, but it might be irrelevant. The problem doesn't seem to be to install numpy, it works perfectly in the regular terminal. The problem seems to be that postgres can't use correctly numpy.

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-06-01 Thread Adrian Klaver
On 06/01/2015 09:09 AM, Rémi Cura wrote: Hey, thanks to help me with that. I started fresh to have a truly reproducible process, so you can have all information and rule out some error possibilities. - Uninstall all python. - Check that PythonPath doesn't exist anymore - check that python

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-06-01 Thread Rémi Cura
Here is the test code --- --creating plpython3u DROP LANGUAGE plpython3u CASCADE; CREATE LANGUAGE plpython3u ; --create a test function DROP FUNCTION IF EXISTS rc_test_python( ); CREATE FUNCTION rc_test_python( ) RETURNS void AS $$""" @brief This function test python """ import sys

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-06-01 Thread Rémi Cura
Hey, thanks to help me with that. I started fresh to have a truly reproducible process, so you can have all information and rule out some error possibilities. - Uninstall all python. - Check that PythonPath doesn't exist anymore - check that python doesn't exist anymore - install python 3.2.5

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-05-28 Thread Adrian Klaver
On 05/28/2015 08:54 AM, Rémi Cura wrote: ​Hey thanks for the help ! > Hey dear List, > > On a windows XP 64. > > I installed python (64b), > it works. What version of Python 2 or 3 or both? What does python -V show at the command line? Python 3.2 and python 2.

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-05-28 Thread Alban Hertroys
> On 28 May 2015, at 17:54, Rémi Cura wrote: > > I tried: > > C:\Python32>python.exe > > Python 3.2 (r32:88445, Feb 20 2011, 21:30:00) [MSC v.1500 64 bit (AMD64)] on > win32 Ehm, this seems significant? ---^ It looks l

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-05-28 Thread Rémi Cura
​Hey thanks for the help ! > > Hey dear List, > > > > On a windows XP 64. > > > > I installed python (64b), > > it works. > > What version of Python 2 or 3 or both? > > What does python -V show at the command line? > Python 3.2 and python 2.6, both 64bits are installed on the PC. Whe

Re: [GENERAL] Python 3.2 XP64 and Numpy...

2015-05-27 Thread Adrian Klaver
On 05/27/2015 09:49 AM, Rémi Cura wrote: Hey dear List, On a windows XP 64. I installed python (64b), it works. What version of Python 2 or 3 or both? What does python -V show at the command line? CReating plpython3u works, and python works within database. I installed numpy (manually com

[GENERAL] Python 3.2 XP64 and Numpy...

2015-05-27 Thread Rémi Cura
Hey dear List, On a windows XP 64. I installed python (64b), it works. CReating plpython3u works, and python works within database. I installed numpy (manually compiled,64b), it works outside of Postgres, but inside a plpython3u function, simply doing 'import numpy' raises an error saying that p

Re: [GENERAL] python modul pre-import to avoid importing each time

2014-06-27 Thread Rémi Cura
Hey, thanks, now we have good information: the python package are really loaded once per connection, so no optimization is needed. Unlike plperl or plR there is no easy way to preload packages. There may be some solutions to make this import at connection start but it would involve C modification

Re: [GENERAL] python modul pre-import to avoid importing each time

2014-06-26 Thread Adrian Klaver
On 06/26/2014 02:14 AM, Rémi Cura wrote: Hey, thanks for your answer ! Yep you are right, the function I would like to test are going to be called a lot (100k times), so even 15 ms per call matters. I got to thinking about this. 100K over what time frame? How is it being called? -- Adri

Re: [GENERAL] python modul pre-import to avoid importing each time

2014-06-26 Thread Tom Lane
Adrian Klaver writes: > On 06/26/2014 02:14 AM, Rémi Cura wrote: >> On another internet page (can't find it anymore) somebody mentioned this >> module loading at server startup, one way or another, but gave no >> precision. It seems that the "plpy" python module get loaded by default, >> would'nt

Re: [GENERAL] python modul pre-import to avoid importing each time

2014-06-26 Thread Jeff Janes
On Thu, Jun 26, 2014 at 2:14 AM, Rémi Cura wrote: > Hey, > thanks for your answer ! > > Yep you are right, the function I would like to test are going to be called > a lot (100k times), so even 15 ms per call matters. > > I'm still a bit confused by a topic I found here : > http://stackoverflow.co

Re: [GENERAL] python modul pre-import to avoid importing each time

2014-06-26 Thread Adrian Klaver
On 06/26/2014 02:14 AM, Rémi Cura wrote: Hey, thanks for your answer ! Yep you are right, the function I would like to test are going to be called a lot (100k times), so even 15 ms per call matters. I'm still a bit confused by a topic I found here : http://stackoverflow.com/questions/15023080/h

Re: [GENERAL] python modul pre-import to avoid importing each time

2014-06-26 Thread Rémi Cura
Hey, thanks for your answer ! Yep you are right, the function I would like to test are going to be called a lot (100k times), so even 15 ms per call matters. I'm still a bit confused by a topic I found here : http://stackoverflow.com/questions/15023080/how-are-import-statements-in-plpython-handle

Re: [GENERAL] python modul pre-import to avoid importing each time

2014-06-25 Thread Jeff Janes
On Thu, Jun 19, 2014 at 7:50 AM, Rémi Cura wrote: > Hey List, > > I use plpython with postgis and 2 python modules (numpy and shapely). > Sadly importing such module in the plpython function is very slow (several > hundreds of milliseconds). Is that mostly shapely (which I don't have)? numpy see

[GENERAL] python modul pre-import to avoid importing each time

2014-06-19 Thread Rémi Cura
Hey List, I use plpython with postgis and 2 python modules (numpy and shapely). Sadly importing such module in the plpython function is very slow (several hundreds of milliseconds). I also don't know if this overhead is applied each time the function is called in the same session. Is there a way

[GENERAL] Python mapping with new 9.2 data types

2012-09-24 Thread Daniele Varrazzo
Hello, I've worked at Python-Postgres mapping for the new PostgreSQL 9.2 data types. They should be released with the next psycopg2 version. The current design, susceptible to changes if needed, is documented here: - JSON adaptation: http://initd.org/psycopg/docs/extras.html#json-adaptation - Ra

Re: [GENERAL] Python + listen/notify

2012-07-12 Thread Filipe brandão
Hei Josh, problem solved! Thanks for your help! On Wed, Jul 11, 2012 at 4:27 PM, Josh Kupershmidt wrote: > [Please keep the list CC'd] > > On Wed, Jul 11, 2012 at 3:58 AM, Filipe brandão > wrote: > > > Now, i only need to link these processes (trigger completion and running > the > > script). >

Re: [GENERAL] Python + listen/notify

2012-07-11 Thread Josh Kupershmidt
[Please keep the list CC'd] On Wed, Jul 11, 2012 at 3:58 AM, Filipe brandão wrote: > Now, i only need to link these processes (trigger completion and running the > script). > How can i do it with Listen / Notify? Issue a notify in the end of the > trigger and a listen on the python script? Yes,

Re: [GENERAL] Python + listen/notify

2012-07-10 Thread Josh Kupershmidt
On Tue, Jul 10, 2012 at 3:56 PM, Filipe Brandão wrote: > Hi all. > I needed to have a trigger firing after a commit, but allready realized it's > not possible. > As i searched upon a solution i came across the LISTEN / NOTIFY. I haven't > yet realized exactly what i can do with it, but can i use

[GENERAL] Python + listen/notify

2012-07-10 Thread Filipe Brandão
Hi all. I needed to have a trigger firing after a commit, but allready realized it's not possible. As i searched upon a solution i came across the LISTEN / NOTIFY. I haven't yet realized exactly what i can do with it, but can i use it to run a simple python script located out my DB? Can't run it

[GENERAL] Python UCS4 error

2011-07-05 Thread c k
Dear All, I updated my development machine with Fedora 15 and as there is python 2.7. I have also migrated my few postgresql databases. While creating plpython in one database, I got the following error undefined symbol PyUnicodeUCS4_AsEncodedString. Then I recompiled source code and got a plpython

Re: [GENERAL] Python client + select = locked resources???

2009-07-01 Thread Erik Jones
On Jul 1, 2009, at 9:21 AM, johnf wrote: On Monday 29 June 2009 09:26:24 am Craig Ringer wrote: Try connecting to the database with psql and running "select * from pg_stat_activity" while the web app is running. You should see only "IDLE" or working connections, never idle in transaction. If

Re: [GENERAL] Python client + select = locked resources???

2009-07-01 Thread Scott Mead
On Wed, Jul 1, 2009 at 12:21 PM, johnf wrote: > On Monday 29 June 2009 09:26:24 am Craig Ringer wrote: > > Try connecting to the database with psql and running > > "select * from pg_stat_activity" > > while the web app is running. You should see only "IDLE" or working > > connections, never idl

Re: [GENERAL] Python client + select = locked resources???

2009-07-01 Thread johnf
On Monday 29 June 2009 09:26:24 am Craig Ringer wrote: > Try connecting to the database with psql and running >   "select * from pg_stat_activity" > while the web app is running. You should see only "IDLE" or working > connections, never idle in transaction. If you have anything idle in a > transac

Re: [Fwd: Re: [GENERAL] Python client + select = locked resources???]

2009-07-01 Thread durumdara
Hi! 2009.07.01. 9:43 keltezéssel, Craig Ringer írta: On Wed, 2009-07-01 at 09:23 +0200, durumdara wrote: Firebird have repeatable read, but PG is not have it. Hmmm... Then that is meaning that every statement is in new transaction context which can makes inconsistency in the views... For

Re: [GENERAL] Python client + select = locked resources???

2009-07-01 Thread Scott Marlowe
Hey. You should turn on all statement logging and tail the postgresql logs to see what your python app is really doing. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [Fwd: Re: [GENERAL] Python client + select = locked resources???]

2009-07-01 Thread Craig Ringer
On Wed, 2009-07-01 at 09:23 +0200, durumdara wrote: > > > In this world I was everytime in transaction, because of reads are > > > also working under transactions. > > > > > > > Just like PostgreSQL. You can't run a query without a transaction in > > PostgreSQL; if you don't issue an explici

Re: [GENERAL] Python client + select = locked resources???

2009-06-30 Thread durumdara
Hi! 2009.06.29. 18:26 keltezéssel, Craig Ringer írta: On Mon, 2009-06-29 at 13:36 +0200, durumdara wrote: I wanna ask something. I came from IB/FB world. InterBase / FireBird ? Yes, sorry for short descriptions. In this world I was everytime in transaction, because of re

Re: [GENERAL] Python client + select = locked resources???

2009-06-29 Thread Craig Ringer
On Mon, 2009-06-29 at 13:36 +0200, durumdara wrote: > I wanna ask something. I came from IB/FB world. InterBase / FireBird ? > In this world I was everytime in transaction, because of reads are > also working under transactions. Just like PostgreSQL. You can't run a query without a transaction

[GENERAL] Python client + select = locked resources???

2009-06-29 Thread durumdara
Hi! I wanna ask something. I came from IB/FB world. In this world I was everytime in transaction, because of reads are also working under transactions. In the FB world the transactions without any writes/updates are not locking the database, so another clients can makes a transactions on any r

Re: [GENERAL] python api to backup/restore data

2007-08-04 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/04/07 10:58, Tom Lane wrote: > Acm <[EMAIL PROTECTED]> writes: >> I would like to know whether an API for accessing Postgresql from >> Python exists and whether or not it supports commands for backing up a >> database (or schema) and restoring a

Re: [GENERAL] python api to backup/restore data

2007-08-04 Thread Tom Lane
Acm <[EMAIL PROTECTED]> writes: > I would like to know whether an API for accessing Postgresql from > Python exists and whether or not it supports commands for backing up a > database (or schema) and restoring a backup file. Run pg_dump or pg_restore as a subprocess. regar

[GENERAL] python api to backup/restore data

2007-08-04 Thread Acm
I am working with Postgresql 8.2.4 and Python 2.5. I would like to know whether an API for accessing Postgresql from Python exists and whether or not it supports commands for backing up a database (or schema) and restoring a backup file. I heard about psycopg and psycopg2 but have no idea of how

Re: [GENERAL] Python DB-API 2.0 oddity (was: I receieved an example of

2005-05-02 Thread Marco Colombo
On Mon, 2005-05-02 at 11:56 +0200, Karsten Hilbert wrote: > > The key is getting the "cursor". Once you have a cursor you can do > > inserts, > > updates and deletes, like > Huh ? Pardon me ? Doing inserts, updates and deletes via a > cursor ? The PostgreSQL documentation clearly says that the

Re: [GENERAL] Python DB-API 2.0 oddity (was: I receieved an example of

2005-05-02 Thread Marco Colombo
On Mon, 2005-05-02 at 11:56 +0200, Karsten Hilbert wrote: > A note on what I think is a strangeness in the Python DB-API 2.0. > Please correct me if I am wrong. > > (Note that I am not trying to throw off the OP but simply use > his example to point out an oddity about that API. The point > is to

[GENERAL] Python DB-API 2.0 oddity (was: I receieved an example of Rekall script)

2005-05-02 Thread Karsten Hilbert
A note on what I think is a strangeness in the Python DB-API 2.0. Please correct me if I am wrong. (Note that I am not trying to throw off the OP but simply use his example to point out an oddity about that API. The point is to make sure it *is* an oddity so I can raise it with the appropriate for

Re: [GENERAL] Python Driver

2005-02-11 Thread Michael Fuhr
On Fri, Feb 11, 2005 at 04:26:04PM -0500, Alex Turner wrote: > > What does the column 'relation' in pg_locks key to (Is there any docs > on the website for this?) See the "System Catalogs" chapter in the documentation (substitute your version of PostgreSQL in the link): http://www.postgresql.org/

Re: [GENERAL] Python Driver

2005-02-11 Thread Michael Fuhr
On Fri, Feb 11, 2005 at 04:24:17PM -0500, Alex Turner wrote: > > pg_locks - awesome - I will check it out... See also pg_stat_activity. If you don't see anything in the current_query column then edit postgresql.conf and set stats_command_string = true, then restart the database. With this config

Re: [GENERAL] Python Driver

2005-02-11 Thread Alex Turner
pg_locks - awesome - I will check it out... I think it's uncommitted transactions that are causing the problem. The original code was written very transactionaly. Alex Turner netEconomist On Fri, 11 Feb 2005 14:20:32 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Fri, Feb 11, 2005 at 04:0

Re: [GENERAL] Python Driver

2005-02-11 Thread Alex Turner
What does the column 'relation' in pg_locks key to (Is there any docs on the website for this?) Alex On Fri, 11 Feb 2005 14:20:32 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Fri, Feb 11, 2005 at 04:05:03PM -0500, Alex Turner wrote: > > > > I am now having trouble with psycopg locking up

Re: [GENERAL] Python Driver

2005-02-11 Thread Michael Fuhr
On Fri, Feb 11, 2005 at 04:05:03PM -0500, Alex Turner wrote: > > I am now having trouble with psycopg locking up my database somehow. > It's almost like there are outstanding locks on objects in the database > that are preventing other threads operating. Do you mean the Python script itself is loc

Re: [GENERAL] Python Driver

2005-02-11 Thread Alex Turner
Funny you should say that - the system I am developing has a similar system, although not as fully developed. I am now having trouble with psycopg locking up my database somehow. It's almost like there are outstanding locks on objects in the database that are preventing other threads operating.

Re: [GENERAL] Python Driver

2005-02-11 Thread James Thompson
On Thursday 10 February 2005 08:56 pm, Alex Turner wrote: > Just a small warning for those people using python with postgresql: > pysgresql and psycopg are very different animals. You cannot drop in > one as a replacement for the other, even though both 'claim' to be DB > API 2.0 compliant. None

[GENERAL] Python Driver

2005-02-10 Thread Alex Turner
Just a small warning for those people using python with postgresql: pysgresql and psycopg are very different animals. You cannot drop in one as a replacement for the other, even though both 'claim' to be DB API 2.0 compliant. If you are starting out with python on postgresql, I would strongly rec

Re: [GENERAL] Python Interface

2005-02-10 Thread Michael Fuhr
On Thu, Feb 10, 2005 at 01:29:42PM -0600, James Thompson wrote: > Though if IIRC it does round timestamps which can burn a person at times :) > I don't have a test case to verify if my memory is correct about this though. Actually, I think it's just that mxDateTime defaults to displaying times

Re: [GENERAL] Python Interface

2005-02-10 Thread James Thompson
On Thursday 10 February 2005 10:19 am, you wrote: > Alex Turner wrote: > >Can anyone recommend a python interface other than pygresql for > >postgresql. Yet again they have changed the API (pg.error is now > >pg.Error), and I can get no information from the mailing list, which > >seems dead. > > P

Re: [GENERAL] Python Interface

2005-02-10 Thread Joshua D. Drake
Alex Turner wrote: Can anyone recommend a python interface other than pygresql for postgresql. Yet again they have changed the API (pg.error is now pg.Error), and I can get no information from the mailing list, which seems dead. Pyscopg is very popular. We use it hear at Command Prompt with gre

Re: [GENERAL] Python Interface

2005-02-10 Thread Michael Fuhr
On Thu, Feb 10, 2005 at 10:58:05AM -0500, Alex Turner wrote: > Can anyone recommend a python interface other than pygresql for > postgresql. Yet again they have changed the API (pg.error is now > pg.Error), and I can get no information from the mailing list, which > seems dead. psycopg is popula

[GENERAL] Python Interface

2005-02-10 Thread Alex Turner
Can anyone recommend a python interface other than pygresql for postgresql. Yet again they have changed the API (pg.error is now pg.Error), and I can get no information from the mailing list, which seems dead. Thanks, Alex Turner netEconomist ---(end of broadcast)---

Re: [GENERAL] PYTHON, ODBC

2005-01-14 Thread Matthew Story
thanks for the advice, matt On Sun, 09 Jan 2005 20:47:08 +0100, Pierre-Frédéric Caillaud <[EMAIL PROTECTED]> wrote: > > > > due to the complicated nature of the database, and inability of zope > > Well, I've found that Zope is very good to do a few things, and very > bad > at the res

Re: [GENERAL] PYTHON, ODBC

2005-01-14 Thread Matthew Story
we won't be using any tools aside from psycho pg, no gui application frameworks, ie we're not using zope, ruby on rails, etc. The front end will only work for this particular database. This has come about due to the complicated nature of the database, and inability of zope to do what we need, and

Re: [GENERAL] PYTHON, ODBC

2005-01-09 Thread Pierre-Frédéric Caillaud
due to the complicated nature of the database, and inability of zope Well, I've found that Zope is very good to do a few things, and very bad at the rest. to do what we need, and the problems with overhead we've been experiencing with rails due to the size of the database. Hope this I like p

Re: [GENERAL] PYTHON, ODBC

2005-01-09 Thread mstory
- Forwarded message from Matthew Story <[EMAIL PROTECTED]> - Date: Sun, 9 Jan 2005 12:40:36 -0600 From: Matthew Story <[EMAIL PROTECTED]> Reply-To: Matthew Story <[EMAIL PROTECTED]> Subject: Re: [GENERAL] PYTHON, ODBC To: Pierre-Frédéric Caillaud <[

Re: [GENERAL] PYTHON, ODBC

2005-01-09 Thread Pierre-Frédéric Caillaud
completely proprietary front end written in python. Any help finding useful What does "a completely proprietary front-end in python" means ? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] PYTHON, ODBC

2005-01-09 Thread Matthew Story
We're looking into building a front end for our database in python. The database in question is an educational database, that generates new tables for each teacher, class and student. Was wondering if anyone had any recommendations for similar projects to look at, resources, and general informati

Re: [GENERAL] PYTHON, ODBC

2005-01-08 Thread mstory
I've looked into pshycho pg, it appears to be the best option, my later question now remains, what documentation or examples would be useful in developing a completely proprietary front end written in python. Any help finding useful examples or documentation would be greatly appreciated. thanks,

Re: [GENERAL] PYTHON, ODBC

2005-01-08 Thread Pierre-Frédéric Caillaud
Never used ODBC with Python, but if you want to use Postgres, I'd strongly recommend psycopg which I find the nicest and fastest postgres adapter (certainly a lot better than Pygresql and pypgsql) Regards On Sat, 8 Jan 2005 18:01:01 -0600, <[EMAIL PROTECTED]> wrote: We're looking in

[GENERAL] PYTHON, ODBC

2005-01-08 Thread mstory
We're looking into building a front end for our database in python. The database in question is an educational database, that generates new tables for each teacher, class and student. Was wondering if anyone had any recommendations for similar projects to look at, resources, and general informat

Re: [GENERAL] Python Postgresql support?

2004-09-01 Thread Pierre-Frédéric Caillaud
Use psycopg, it's a hell of a lot faster anyway. On Tue, 31 Aug 2004 23:25:35 -0400, Jerry LeVan <[EMAIL PROTECTED]> wrote: Is it possible to build the python postgresql support library on Mac OSX 10.3.5 with the default python install? Adding "--with-python" gets an error message about libp

[GENERAL] Python Postgresql support?

2004-08-31 Thread Jerry LeVan
Is it possible to build the python postgresql support library on Mac OSX 10.3.5 with the default python install? Adding "--with-python" gets an error message about libpython not being a shared library when attempting to build postgresql. (pg 7.4.5) Thanks for any pointers. Jerry ---

Re: [GENERAL] Python and 8.0 beta

2004-08-24 Thread Gaetano Mendola
Clodoaldo Pinto Neto wrote: >>Are there any python drivers that work with the version 8 beta? >> >>The version seven ones didn't. > > > This script is working with version 7.4.2, FC2, python 2.3.3 > > [SNIP] May you test the following script and let me know which error you are encountering: #!/usr/

Re: [GENERAL] Python and 8.0 beta

2004-08-23 Thread Tim Penhey
Peter Eisentraut wrote: Tim Penhey wrote: Are there any python drivers that work with the version 8 beta? The version seven ones didn't. Why? Changed from using pyPgSQL to psycopg and things are working again... Tim ---(end of broadcast)---

[GENERAL] Python to postgresql interface

2004-04-17 Thread Jurgen Defurne
Dear all, I hope that my following question does not start a flamewar, but what do you consider the most mature Python to postgreSQL interface, psycopg, popy or pygresql ? Regards, Jurgen ---(end of broadcast)--- TIP 8: explain analyze is your fri

[GENERAL] python Backend message type 0x44 arrived while idle

2001-10-17 Thread Adam Haberlach
I'm having trouble selecting "long" rows out of a database of email messages using python. I'm working on an IMAP server in python using Postgres as a backend datastore. All the code can be seen with a little poking around at http://zipcode.sourceforge.net but basically I'm just executi

Re: [GENERAL] Python interface memory leak?

2001-10-17 Thread Tom Lane
Stephen Robert Norris <[EMAIL PROTECTED]> writes: > Actually, it's a bug. I spent most of today with a co-worker looking for > it. There's a Py_DECREF missing in the fetch routine, which makes it > leak the results of every fetch. Who do I send the (one-line) fix to? pgsql-patches list.

Re: [GENERAL] Python interface memory leak?

2001-10-17 Thread Stephen Robert Norris
On Wed, 2001-10-17 at 16:56, Denis Gasparin wrote: > At 16/10/01 14.00, you wrote: > >Does the python interface leak memory? We are seeing the process grow > >with basically every select. Any suggestions on what's going on? There > >are no cycles, and a trivial program (basically a loop around a s

Re: [GENERAL] Python interface memory leak?

2001-10-17 Thread Denis Gasparin
At 16/10/01 14.00, you wrote: >Does the python interface leak memory? We are seeing the process grow >with basically every select. Any suggestions on what's going on? There >are no cycles, and a trivial program (basically a loop around a select) >demonstrates the problem. > >This is 7.1.2 on RH7.[

Re: [GENERAL] Python interface memory leak?

2001-10-16 Thread Keary Suska
good as another. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" > From: Stephen Robert Norris <[EMAIL PROTECTED]> > Date: 16 Oct 2001 22:00:35 +1000 > To: [EMAIL PROTECTED] > Subject: [GENERAL] Python interface memory leak? > > Does th

[GENERAL] Python interface and large objects?

1998-11-09 Thread Mike Meyer
Does someone have the Python interface handling large objects properly? I keep winding up with size 0 objects in PostgreSQL 6.3.2. Thanx,

[GENERAL] Python

1998-07-09 Thread Konstantin S. Kuznetsov
Hello! I have PostgreSQL-6.3.2 and Python1.5 with RedHat-5.1 distribution. But I can't connect PostgreSQL from Python script, cause there are no pg.py (or smth like that) module installed. Can anyone have experience with using such modules? Thank you.