Re: [sqlite] Problem with SQLite Pecl extension for PHP4

2007-05-09 Thread Jon Scully
What user is httpd running as? Enter: ps aux | grep -v grep | grep httpd Does that user (typically 'nobody') have permission to access the file at your: /home/xxx/data/xxx.db ? On 5/9/07, Brandon Eley <[EMAIL PROTECTED]> wrote: I've gone through a few tutorials and can't seem to get this

Re: [sqlite] ATTACH and sqlite3_open()

2007-05-09 Thread Jon Scully
nts can be bound and the attach statement can be prepared. I'm not certain this is possible with the ATTACH syntax. I'll try it soon though. Mike -Ursprüngliche Nachricht- Von: Jon Scully [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 10. Mai 2007 01:18 An: sqlite-users@sqlite.org Betreff: Re:

Re: [sqlite] ATTACH and sqlite3_open()

2007-05-09 Thread Jon Scully
Simpler than that. I merely want to attach to two databases (files). flash.db contains a set of tables that hold non-volatile data; ram.db contains a set of tables that is re-built (volatile) on re-boot -- but offers fast, read-only access. No table-name overlaps, of course. I want to access

[sqlite] ATTACH and sqlite3_open()

2007-05-09 Thread Jon Scully
Can one attach multiple database files using C API? The only example I've seen is CLI-based (using ATTACH). The Owens book seems to hint that it's possible to do the same trick using sqlite3_open()... Quote Pgs. 206-207: This is more of a connection handle than a database handle since it is

Re: AW: AW: AW: [sqlite] Function Language

2007-04-09 Thread Jon Scully
AppWeb might be suitable for what you need: http://www.appwebserver.org/ http://www.appwebserver.org/products/appWeb/doc/api/gen/appweb/esp_8js.html http://www.appwebserver.org/products/appWeb/doc/api/gen/appweb/c-api.html It's small-footprint, extensible through modules or compile-time (C or