[Tutor] in-memory pysqlite databases

[Dinesh B Vadhia]

Why do you say: "Now you didn't mention webpy before, that makes a big difference!" ?

<rant on> 
As an aside, it really is a huge pain in the neck that, in general standard Python works (and works wonderfully) but as soon as you include external libraries (eg. Numpy, Scipy, webpy - and probably other web frameworks etc. etc.) things start to fall apart (badly!).  And, from my experience with Python so far it is not of my incompetance (well, not most of the time!).
<rant off> 

Dinesh

..............................................................................
Date: Sat, 12 Apr 2008 23:23:30 +0100
From: "Alan Gauld" <alan.gauld at btinternet.com>
Subject: Re: [Tutor] in-memory pysqlite databases
To: tutor at python.org
Message-ID: <ftrcp7$gda$1 at ger.gmane.org>
Content-Type: text/plain; format=flowed; charset="Windows-1252";
reply-type=original


"Dinesh B Vadhia" <dineshbvadhia at hotmail.com> wrote 

> However, a web version using webpy doesn't work 

Now you didn't mention webpy before, that makes a big 
difference!

> an execution thread is created by pysqlite and 
> another thread by webpy and hence webpy is not 
> seeing the table.  

Almost certainly the case but if you are using the web 
you can almost certainly afford to use a file based 
SqlLite database and that way the data can be shared. 
The network delays will more than overcome the 
slowdown of moving to the file based database.


-- 
Alan Gauld
Author of the Learn to Program web site
http://www.freenetpages.co.uk/hp/alan.gauld


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20080413/e2cd266d/attachment.htm