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

[sqlite] Re: Database Disk Full

2006-02-13 Thread Dave Dyer
At 04:47 AM 2/13/2006, John Stanton wrote: >Sigh... what is wrong with a message "disk full" when the disk space is >exhausted? Why is simple and to the point a problem? The "disk full" error is actually "write failed". Disk full may be the expected reason for a write to fail, but there are

RE: [sqlite] Linux fcntl() threaded locking problem

2006-02-13 Thread David Fiddes
> SQLite tests for the linux thread-locking bug at run-time using > the routine testThreadLockingBehavior() in os_unix.c. You can > use that code. Excellent. Thanks for the quick response. I'll have a look at the code and see how it fares. Dave

Re: [sqlite] extensible indexing

2006-02-13 Thread Noel Frankinet
Martin Pfeifle wrote: Dear all, is it somehow possible to add an own index-structure, e.g. M-tree, R-tree, Quadtree...to SQLite? Has anyone ever done that? Best Martin ___ Telefonate ohne weitere

Re: [sqlite] Linux fcntl() threaded locking problem

2006-02-13 Thread drh
David Fiddes <[EMAIL PROTECTED]> wrote: > > Is there any test software or way of testing a particular Linux distribution > or C library installation to see if it suffers from the fcntl() locking > problem. > SQLite tests for the linux thread-locking bug at run-time using the routine

[sqlite] Linux fcntl() threaded locking problem

2006-02-13 Thread David Fiddes
Hi, Is there any test software or way of testing a particular Linux distribution or C library installation to see if it suffers from the fcntl() locking problem. I would really like to use the new thread pooling capability in 3.3.x but am obviously wary of doing so if I'm not 100% confident in

RE: [sqlite] Re: Database Disk Full

2006-02-13 Thread Drew, Stephen
Exactly, as per my original mail, there was no shortage of disk space on the drive in question, on the drive containing the temporary files, and the database file was 100kb. So SQLITE_FULL was misleading in this case. I will post further information about the exact cause when I have tracked it

Re: [sqlite] Re: Database Disk Full

2006-02-13 Thread Michael Knigge
Sigh... what is wrong with a message "disk full" when the disk space is exhausted? Why is simple and to the point a problem? The point is, that this error is returned everytime a write to the disk failed - even if (for example) the write failed because of a network error (NFS-Server is

Re: [sqlite] Re: Database Disk Full

2006-02-13 Thread John Stanton
Sigh... what is wrong with a message "disk full" when the disk space is exhausted? Why is simple and to the point a problem? Drew, Stephen wrote: John, Thanks for the reply. I disagree - my error message informs my users (who are technonerds) that the disk or db file is full, when neither

RE: [sqlite] Re: Database Disk Full

2006-02-13 Thread Drew, Stephen
John, Thanks for the reply. I disagree - my error message informs my users (who are technonerds) that the disk or db file is full, when neither of these is the case. Surely you can see that even a different constant error message in this context would be preferable? SQLITE_WRITE_FAILED or

[sqlite] extensible indexing

2006-02-13 Thread Martin Pfeifle
Dear all, is it somehow possible to add an own index-structure, e.g. M-tree, R-tree, Quadtree...to SQLite? Has anyone ever done that? Best Martin ___ Telefonate ohne weitere Kosten vom PC zum PC: