I've been meaning to ask...
What's the $dbh->func("busy_timeout") value intended to do? I see it seems to
default to 30 seconds. Does DBD-SQLite wait or retry a statement for 30
seconds if it encounters SQLITE_BUSY? Any light you can shed on this?
Thanks!
-Clark
----- Original Message ----
From: Matt Sergeant <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, May 5, 2006 9:47:10 AM
Subject: Re: [sqlite] sqlite driven web-site
FWIW I've created a very high traffic web site (over 2000 tps) that
uses SQLite at its core (also uses MS SQL Server, but don't blame me
for that). So high traffic isn't a problem with a good design.
On 5-May-06, at 11:30 AM, Clark Christensen wrote:
> I have dynamic apps running on my company's website using Perl and
> SQLite. There's a very good wrapper for using SQLite with the Perl
> DBI. Check out http://search.cpan.org/~msergeant/DBD-SQLite-1.12
>
> It works well for a low-volume app on a public site. I'm working
> on a new app (also all Perl) now that'll be sending considerably
> more traffic to the SQLite database (more frequent reads and
> writes), plus session management. We'll see how that goes, but I'm
> not expecting problems beyond occasional locks.
>
> -Clark
>
> ----- Original Message ----
> From: "Rajan, Vivek K" <[EMAIL PROTECTED]>
> To: [email protected]
> Sent: Thursday, May 4, 2006 10:29:18 PM
> Subject: [sqlite] sqlite driven web-site
>
> Dear SQLite community-
>
> I want to develop a dynamic web-site (for small group of people <
> 5-10).
> For this I am thinking of using SQLite.
>
> Couple of questions:
> * Are there some docs and/or package available to do something like
> this?
> * I would like to use perl as the programming interface - this is most
> what I am familiar with
>
> Has someone done something like that and would share their
> experience on
> this topic.
>
> Vivek
>
>
>
>
>
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
