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 with

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

2006-02-14 Thread Robert Foster
abase serialisation method and serialise the database to the session. It would, however, be a lot more efficient to simply create a file-based database in the first place and re-open it every time a page is called. Hope this helps, Robert Foster General Manager Mountain Visions P/L

[sqlite] ALTER TABLE Command restrictions

2005-11-22 Thread Robert Foster
Hi, I was just playing with ALTER TABLE, and it appears that you can only add 1 column with each command. Is this correct? If so, how hard would it be to enable adding multiple columns with the same command? Thanks, Robert Foster General Manager Mountain Visions P/L http

RE: [sqlite] Versions 2.8.16 and 3.1.2

2005-02-15 Thread Robert Foster
Nope, the link is wrong... http://www.sqlite.org/releasenotes310.html Should do it. Rob. -Original Message- From: Tito Ciuro [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 February 2005 12:30 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Versions 2.8.16 and 3.1.2 Hello, http://www