Re: [Tutor] how to pause or stop a running python script?

2007-01-25 Thread Wong Vincent
Hi, If I use run a script which consist the following line: -->os.popen("python c:\\test.py") Is it possible for me to interrupt the pause/stop the running of "test.py" halfway? If not, can you please suggest a way. Thanks Best regards Vincent -

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Eike Welk
On Thursday 25 January 2007 04:12, Shadab Sayani wrote: > Hi, > I am using vim editor to code my project in python.Is there a > good IDE where in I type the name of the class object and then > dot then all the attributes of the object are displayed so on.I I use Pydev, it is a plugin for the

Re: [Tutor] Optimal solution in dealing with huge databases in python

2007-01-25 Thread Eike Welk
You could try Pytables: http://www.pytables.org/moin It is not a database, but a storage library for large amounts of data. Regards, Eike. ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor

Re: [Tutor] Optimal solution in dealing with huge databases in python

2007-01-25 Thread Shadab Sayani
Hi, I got your point.But before inserting data I need to store it into a file in a format supported by postgresql.Wont this operation incur a performance hit as it includes writing to a file which is on disk? Thanks and Regards, Shadab. johnf <[EMAIL PROTECTED]> wrote: On Wednesda

Re: [Tutor] Optimal solution in dealing with huge databases inpython

2007-01-25 Thread Alan Gauld
"Eric Walstad" <[EMAIL PROTECTED]> wrote >> Loadfile.sql would in turn contain lots of SQL commands like: >> >> INSERT into CUSTOMER >> VALUES ( 'fred', 'bloggs', 45, '01773-987321'); > I think PostgreSQl will wrap each of these INSERT statements into a > transaction, which will add a lot of over

Re: [Tutor] Python re without string consumption

2007-01-25 Thread Terry Carroll
On Thu, 25 Jan 2007, Jacob Abraham wrote: >I would like to thank you for the solution and > the helper funtion that I have written is as follows. That's very similar to a solution I coded up for a friend, who was doing searches in genetic sequences, and had exactly the same problem you did

Re: [Tutor] Optimal solution in dealing with huge data bases in python

2007-01-25 Thread johnf
On Thursday 25 January 2007 14:36, Eric Walstad wrote: > Alan Gauld wrote: > > "Shadab Sayani" <[EMAIL PROTECTED]> wrote > > > >> The data I need to deal with is in 100s of GB. > >> I am using postgresql backend and SQLALCHEMY ORM. > > > > All ORMs will introduce a significant performance hit. > >

Re: [Tutor] Optimal solution in dealing with huge databases inpython

2007-01-25 Thread Eric Walstad
Alan Gauld wrote: > "Shadab Sayani" <[EMAIL PROTECTED]> wrote > >> Thank you very much for immediate response.I didnt get >> the point of loading the data using SQL.What does that >> mean? > > It means writing a SQL file that can then be run from > the database SQL prompt. I don't know what tha

Re: [Tutor] Optimal solution in dealing with huge databases in python

2007-01-25 Thread Eric Walstad
Alan Gauld wrote: > "Shadab Sayani" <[EMAIL PROTECTED]> wrote > >> The data I need to deal with is in 100s of GB. >> I am using postgresql backend and SQLALCHEMY ORM. > > All ORMs will introduce a significant performance hit. > If you really need high speed, and populating a 100G+ database > p

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Dave Kuhlman
On Thu, Jan 25, 2007 at 07:02:43AM -0900, Tim Johnson wrote: [snip] > > IMHO: If one programs in more than one programming language, the > ultimate would be an editor/IDE that can accommodate all with similar > functionality and behavior for all. Maybe Eclipse (http://www.eclipse.org/)? There i

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Mike Hansen
> > > Activestate just released Komodo Edit and Komodo IDE. I > believe both do > > auto-completion that shows a list of possibilities. Komodo > Edit is free > > and Komodo IDE cost some $$. > > IMHO: If one programs in more than one programming language, the > ultimate would be an editor/ID

Re: [Tutor] Optimal solution in dealing with huge databases in python

2007-01-25 Thread johnf
On Wednesday 24 January 2007 19:22, Shadab Sayani wrote: > Hi, > I am working in a biodatabases project.The data I need to deal with is > in 100s of GB.I am using postgresql backend and SQLALCHEMY ORM.I need to > read the bio datafiles and parse them and then store them in database.I am > in t

Re: [Tutor] Optimal solution in dealing with huge databases inpython

2007-01-25 Thread Alan Gauld
"Shadab Sayani" <[EMAIL PROTECTED]> wrote > Thank you very much for immediate response.I didnt get > the point of loading the data using SQL.What does that > mean? It means writing a SQL file that can then be run from the database SQL prompt. I don't know what that means in PostGres terms sinc

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Tim Johnson
On Thursday 25 January 2007 06:17 am, Mike Hansen wrote: > Someone mentioned that VIM 7 does this. You might need to pick up the > latest python.vim file from vim.org. Vim offers some intriguing possibilities for python: If you compile Vim from source, the python interpreter can be "compiled int

Re: [Tutor] Optimal solution in dealing with huge databases in python

2007-01-25 Thread Chuck Coker
This page has some info on C/C++ for PostgreSQL: http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html Shadab Sayani wrote: > Do have any idea about the C api for Postgresql and > some documentation to use it? -- == Chuck

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Mike Hansen
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shadab Sayani > Sent: Wednesday, January 24, 2007 8:12 PM > To: tutor@python.org > Subject: [Tutor] Best IDE for Python > > Hi, > I am using vim editor to code my project in python.Is there a > goo

Re: [Tutor] Optimal solution in dealing with huge databases in python

2007-01-25 Thread Shadab Sayani
Hi Alan, Thank you very much for immediate response.I didnt get the point of loading the data using SQL.What does that mean?Does it mean Bulk file load.If so then there will I/O performance hit right.Writing the parsed tokens in the csv format in a file.After that only I can bulk load this file. Do

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Hieu Hoang
On 1/25/07, OkaMthembo <[EMAIL PROTECTED]> wrote: > hi guys, > > would someone please point me to an active link to download SPE? the url to > Stani's site just wont click through to > http://stani.be/python/spe/blog/ A while ago the SPE's author said something on python-list to the effect that he

Re: [Tutor] Best IDE for Python

2007-01-25 Thread OkaMthembo
hi guys, would someone please point me to an active link to download SPE? the url to Stani's site just wont click through to http://stani.be/python/spe/blog/ i have a similar problem with the url to the Windows distro of Lighttpd from http://www.kevinworthington.com:8181/ would appreciate any h

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Hieu Hoang
Hi all, > -- Forwarded message -- > From: "Alan Gauld" <[EMAIL PROTECTED]> [snip] > > Is there a good IDE where in I type the name of > > the class object and then dot then all the attributes > > of the object are displayed so on. > > There are several that do this but many ar

Re: [Tutor] Python re without string consumption

2007-01-25 Thread Kent Johnson
Jacob Abraham wrote: > Hi Danny Yoo, > >I would like to thank you for the solution and > the helper funtion that I have written is as follows. But I do hope > that future versions of Python include a regular expression syntax to > handle such cases simply because this method seems very process

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Senthil_OR
Dick Moores wrote: >> Hi, >> I am using vim editor to code my project in python.Is there a good >> IDE where in I type the name of the class object and then dot then >> all the attributes of the object are displayed so on. > > I believe IPython does this. Check out >

Re: [Tutor] Optimal solution in dealing with huge databases in python

2007-01-25 Thread Alan Gauld
"Shadab Sayani" <[EMAIL PROTECTED]> wrote > The data I need to deal with is in 100s of GB. > I am using postgresql backend and SQLALCHEMY ORM. All ORMs will introduce a significant performance hit. If you really need high speed, and populating a 100G+ database probably is included in that, the

Re: [Tutor] Best IDE for Python

2007-01-25 Thread Alan Gauld
"Shadab Sayani" <[EMAIL PROTECTED]> wrote > I am using vim editor to code my project in python. Its not so much tthe editor that matters as the OS! Are you using Linux(I suspect) or Windows or MacOS? (Or something else!) > Is there a good IDE where in I type the name of > the class object a

Re: [Tutor] Send binary/hex data to a TCP socket

2007-01-25 Thread Alan Gauld
"Tod Haren" <[EMAIL PROTECTED]> wrote >I need to send a server at the other end of a socket a 36 byte > "frame", where each byte represents a specific field in the custom > data structure. If its all single bytes then its fairly easy. > The documentation for the server says to initialize each fi

Re: [Tutor] Send binary/hex data to a TCP socket

2007-01-25 Thread Tod Haren
The struct module seems to fit the bill. Thanks Adam ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor

Re: [Tutor] Python re without string consumption

2007-01-25 Thread Jacob Abraham
Hi Danny Yoo, I would like to thank you for the solution and the helper funtion that I have written is as follows. But I do hope that future versions of Python include a regular expression syntax to handle such cases simply because this method seems very process and memory intensive. I also not