Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^3: SQLite with mod_perl

by punkish (Priest)
on Oct 09, 2010 at 02:21 UTC ( #864310=note: print w/replies, xml ) Need Help??

in reply to Re^2: SQLite with mod_perl
in thread SQLite with mod_perl

Alternatively, you may have kept the same database handle open across a fork call, which this mentions as the source of problems, so don't do that either.
So, this may partly be just my ignorance. I am assuming that Apache2 is the forking server here. After all, it spawns little children to manage the web queries.

I am not sure how things work under a mod_perl (or even a fastcgi) kind of persistent perl environment under Apache2. I am assuming that my entire application is compiled and loaded when the server starts. At this point, a db handle is not created. Then, a user queries, which causes a db handle to be created. Since I don't want a new db handle created for subsequent queries by the same user, I reuse the db handle. And, I don't disconnect the db handle, because, if I do, then subsequent queries will fail. How do I ensure that a persistent, unique db handle is created for each user to my web site?


when small people start casting long shadows, it is time to go to bed

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://864310]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2018-03-18 14:48 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (230 votes). Check out past polls.