Re: [Tutor] Java Virtual Machine Launcher Question

2010-12-26 Thread Steven D'Aprano
Apologies if you get (half of) this message twice, I'm having trouble with Thunderbird. Ben Ganzfried wrote: Happy holidays everyone! My current question relates to a broader python programming question I have and so I thought it was worth posting here. I'm trying to read a single MAGE-TAB fi

[Tutor] Java Virtual Machine Launcher Question

2010-12-26 Thread Ben Ganzfried
Happy holidays everyone! My current question relates to a broader python programming question I have and so I thought it was worth posting here. I'm trying to read a single MAGE-TAB file (http://www.mged.org/mage-tab/) and acquire metadata. I just downloaded WinRAR to open zip files, but when tr

Re: [Tutor] Opening and closing SQLite db

2010-12-26 Thread Noah Hall
> > >Which is suggestible just in case the app or program crashes during use. > (To O.P) Indeed, though in such cases you must rely on your programmers instinct to make the right decision - what applies for certain instances of an application doesn't always conform with what applies for other inst

Re: [Tutor] Opening and closing SQLite db

2010-12-26 Thread David Hutto
Unless intermittent > saves are necessary within the app loop. Which is suggestible just in case the app or program crashes during use. ___ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/

Re: [Tutor] Opening and closing SQLite db

2010-12-26 Thread David Hutto
On Sun, Dec 26, 2010 at 11:16 AM, Noah Hall wrote: > As a rule, I tend to open and close a connection based on what I'm doing > with the database. I +1 that. Usually if I open the db in a function, I commit and close. If it's in an app, for me personally, that should be the only place it takes pl

Re: [Tutor] Opening and closing SQLite db

2010-12-26 Thread Noah Hall
As a rule, I tend to open and close a connection based on what I'm doing with the database. If I were to directly run a series of queries one after another, I would keep it open until a change in interface (referring to changes in objects, both masters and slaves). Also, you can perform any query t

Re: [Tutor] Opening and closing SQLite db

2010-12-26 Thread David Hutto
Just for future reference, when it's part of the python standard library, always go to the docs for the full functions and methods available. http://docs.python.org/library/sqlite3.html It can make the usage a lot easier. ___ Tutor maillist - Tutor@py

Re: [Tutor] Opening and closing SQLite db

2010-12-26 Thread Chris Fuller
You can call the commit() method of the connection object to ensure that any changes are saved to disk, but it's strictly optional. Closely/reopening is not necessary. Cheers On Sunday 26 December 2010, Timo wrote: > Hello, I use SQLite in my application as database, but I think I'm doing > s

[Tutor] Opening and closing SQLite db

2010-12-26 Thread Timo
Hello, I use SQLite in my application as database, but I think I'm doing something wrong. Currently, I open a connection and cursor object every time I do an operation (insert, select, update, ...) and close it afterwards. Now I was wondering if it wouldn't be better to open the connection if my a