Re: [sqlite] :memory: and sessions with PHP

2006-02-14 Thread drh
"Robert Foster" <[EMAIL PROTECTED]> wrote: > PHP Sessions are similar to session in ASP, ASP.Net, etc. Objects within > the session are serialised into a stream and stored in the specified storage > medium. By Default, PHP stores sessions in a file in the /tmp directory, > identified by a unique

RE: [sqlite] :memory: and sessions with PHP

2006-02-14 Thread Robert Foster
Comments below... Robert Foster General Manager Mountain Visions P/L http://mountainvisions.com.au -Original Message- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 February 2006 8:38 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] :memory: and sessions

Re: [sqlite] :memory: and sessions with PHP

2006-02-14 Thread Jay Sprenkle
> You can also write custom session handlers, allowing you to store the > session anywhere else including a database. There is some documentation on > the Zend.com site for using the Session api, but it's simply a matter of > writing some functions with specific names, and hooking them in via the

RE: [sqlite] :memory: and sessions with PHP

2006-02-14 Thread Robert Foster
://mountainvisions.com.au Serialised is spelt with an 's', not a 'z' (I'm Australian) -Original Message- From: Kervin L. Pierre [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 February 2006 7:01 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] :memory: and sessions with PHP Hello, I think the problem

Re: [sqlite] :memory: and sessions with PHP

2006-02-14 Thread Kervin L. Pierre
Hello, I think the problem is that PHP uses a file-based session serialization. Therefore anything that cannot be saved to a file and returned ( eg. you can't do this with file handles, etc. ) cannot be saved in session scope in PHP as it is implemented by default. There is the 'mm' extension

Re: [sqlite] :memory: and sessions with PHP

2006-02-14 Thread Andrew Piskorski
On Wed, Feb 15, 2006 at 08:31:17AM +1300, CrazyChris wrote: > We may be at crossed paths... I'm wanting to save the :memory: database to > the session, not the other way round, so that when the 2nd page loads, the > :memory: database can be recreated and available as it was on the last page >

RE: [sqlite] :memory: and sessions with PHP

2006-02-14 Thread CrazyChris
We may be at crossed paths... I'm wanting to save the :memory: database to the session, not the other way round, so that when the 2nd page loads, the :memory: database can be recreated and available as it was on the last page load. The advantage is that after some time, the session is deleted

Re: [sqlite] :memory: and sessions with PHP

2006-02-13 Thread Firman Wandayandi
On 2/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "CrazyChris" <[EMAIL PROTECTED]> writes: > > > Hi there, > > > > I have a need to create a :memory: sqlite database, but save it into the > > user session (PHP) but can't see a way to access the data to save. Looking > > for a sqlite

Re: [sqlite] :memory: and sessions with PHP

2006-02-13 Thread Derrell . Lipman
"CrazyChris" <[EMAIL PROTECTED]> writes: > Hi there, > > I have a need to create a :memory: sqlite database, but save it into the > user session (PHP) but can't see a way to access the data to save. Looking > for a sqlite version of serialize() I guess. > > Has anyone managed to do this? Is it

[sqlite] :memory: and sessions with PHP

2006-02-13 Thread CrazyChris
Hi there, I have a need to create a :memory: sqlite database, but save it into the user session (PHP) but can't see a way to access the data to save. Looking for a sqlite version of serialize() I guess. Has anyone managed to do this? Is it even possible? Wanting to be able to maintain a large