Re: [Cgi-session-user] Trouble with C::S::SQLite

[Ron S. <ro...@sa...>]

On Tue, 7 Mar 2006 07:55:41 -0600, Puneet Kishor wrote:

Hi Puneet

> I haven't tested/reproduced the above, but I have a few thoughts --
>
> One, the same error message could be triggered by two seemingly
> very different "outside" steps. In other words, in my case, the
> said message is triggered when I pass a db handle to create the
> session (the db and the table both exist as required), and in your
> case it happens when you try to create the db file itself.

Agreed.

> Two, it doesn't indicate a bug in SQLite. If anything, probably a
> bug in either CGI-Session or in DBD-SQLite.

I have had trouble with SQLite before (see archive for DBI mailing list), so=
 I 
was deeply suspicious of it before this thread started.

> Three, sort of building on two above -- many would not use SQLite
> in production, but for my purposes it is a capable database serving
> my production needs brilliantly. No other db comes even close in
> its portability and ease of management. SQLite is the core
> datasource in Mac OS X. If it is good enough for Apple, it is good
> enough for me.

OK.

> I am surprised, however, that CGI-Session-SQLite has not been
> exercised enough by the community to have brought this problem to
> light earlier. CGI-Session is great product, and a necessary one
> for building websites. It (or something as easy and portable as it)
> should be a part of core CGI, in my highly empirical view. I hope
> this problem can be corrected, and CGI-Session (and/or DBD-SQLite
> or any other dependent modules) made that much more robust as a
> result.

Well, we are all perhaps spread a bit thinly...

-- 
Cheers
Ron Savage, ro...@sa... on 8/03/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company