Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread John Stanton
I ended up writing my own application server and embedded language and it works about 100 times better than PHP (and I am being kind to PHP). It is a vindication of what they teach you in fundamental CS, it can be easier to just replace bloatware than to try to live with it. Ulrich Schöbel wro

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread Ulrich Schöbel
Thanks again for your help. I've given up to use SQLite with PHP and tried Postgres. This works. I'll probably give up entirely on this PHP crap. As you say, it's a lazy dog and with 12MB module size it's also a monster dog. Long live Tcl and, of course, SQLite! Ulrich On Thursday 05 April 200

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread John Stanton
It is some time since I compiled it so my memory is hazy and I rely on my sparse notes. I compiled php-5.1.0 with those options and what was then the current version of Sqlite. I then compiled and linked it into Apache V2. It worked. The only ugly part was having to learn the PDO rules, but

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread Ulrich Schöbel
Thanks, John, this is much better, although still not what I want. It now has (mysteriously) a sqlite version of 3.3.3. No idea where this is originated, maybe part of the bundle. I compiled sqlite-3.3.13, it's running fine, the lib is in /usr/local/lib, the headers are in /usr/local/include, the

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread John Stanton
This is what I used - To install with SQLITE V3 configure - --without-sqlite --with-sqlite3=/usr/local --with-apxs=/usr/local/apache/bin/apxs SQLITE V3.2.7 is installed in /usr/local Ulrich Schöbel wrote: Yes, I'm using ./configure --enable-shared --with-pdo-sqlite=/usr/local/src/sqlite-3.

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread Ulrich Schöbel
Yes, I'm using ./configure --enable-shared --with-pdo-sqlite=/usr/local/src/sqlite-3.3.13 --enable-sqlite-utf8 sqlite itself compiled fine, no problems there. Ulrich On Thursday 05 April 2007 19:45, Nathan Biggs wrote: > Are you using the PDO object in PHP? If not, PHP only supports 2.8.x. > T

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread John Stanton
AS I recollect compiling and linking the current Sqlite V3 library into PHP was fairly straightforward once it was appreciated that Sqlite 3 linked into the PHP PDO common dataabse interface. If you use Sqlite 3 omit the Sqlite 2 and its interface. Ulrich Schöbel wrote: Hi all, my apologies

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread drh
Ulrich =?iso-8859-1?q?Sch=F6bel?= <[EMAIL PROTECTED]> wrote: > Hi all, > > my apologies if this is the wrong list to ask: > > I'm trying to get php5 with sqlite3.3.13 running, but I'm completely stuck. > Whatever I tell configure, it always configures the bundled 2.8.x sqlite. > > Is there anybo

RE: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread Nathan Biggs
Are you using the PDO object in PHP? If not, PHP only supports 2.8.x. To use 3 or greater, you must use the PDO object to connect. Also make sure that you extension is enabled for pdo_sqlite. -Original Message- From: Ulrich Schöbel [mailto:[EMAIL PROTECTED] Sent: Thursday, April 05, 200

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread Nuno Lucas
On 4/5/07, Ulrich Schöbel <[EMAIL PROTECTED]> wrote: Hi all, my apologies if this is the wrong list to ask: I'm trying to get php5 with sqlite3.3.13 running, but I'm completely stuck. Whatever I tell configure, it always configures the bundled 2.8.x sqlite. 2.8.x and 3.3.x are separate packag