Re: [sqlite] PHP5 and SQLite3.3.13
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 wrote: 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 2007 22:18, John Stanton wrote: 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 it had compensations because we also use PostgreSQL and it is a common interface. Ultimately we did not persevere because PHP turned out to be a lazy dog and we moved on so I cannot give you current details. I suspect that --with-PDO-sqlite is a default and you have to define --without-PDO-sqlite to defeat it. My dim memory suggests that I used grep to ferret out the sqlite options rather than the --help. The utf8 is to do with the character set. Others here are better equipped to explain that than I am. Ulrich Schöbel wrote: 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 sources in /usr/local/src/sqlite-3.3.13. You didn't mention --with-pdo-sqlite=... and --with-sqlite3 is not to be found with ./configure -help. What about --enable-sqlite-utf8? What does that mean? Ulrich On Thursday 05 April 2007 21:25, John Stanton wrote: This is what I used - To install with SQLITE V3 configure - --without-sqlite --with-sqlite3=/usr/local --with-apxs=/usr/local/apache/bin/apxs - To unsubscribe, send email to [EMAIL PROTECTED] - --- -- To unsubscribe, send email to [EMAIL PROTECTED] --- -- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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 2007 22:18, John Stanton wrote: > 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 it had compensations because we also use PostgreSQL and it is > a common interface. > > Ultimately we did not persevere because PHP turned out to be a lazy dog > and we moved on so I cannot give you current details. > > I suspect that --with-PDO-sqlite is a default and you have to define > --without-PDO-sqlite to defeat it. > > My dim memory suggests that I used grep to ferret out the sqlite options > rather than the --help. > > The utf8 is to do with the character set. Others here are better > equipped to explain that than I am. > > Ulrich Schöbel wrote: > > 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 sources > > in /usr/local/src/sqlite-3.3.13. > > > > You didn't mention --with-pdo-sqlite=... and --with-sqlite3 is > > not to be found with ./configure -help. > > > > What about --enable-sqlite-utf8? What does that mean? > > > > Ulrich > > > > On Thursday 05 April 2007 21:25, John Stanton wrote: > >>This is what I used - > >>To install with SQLITE V3 configure - > >> > >> --without-sqlite --with-sqlite3=/usr/local > >>--with-apxs=/usr/local/apache/bin/apxs > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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 it had compensations because we also use PostgreSQL and it is a common interface. Ultimately we did not persevere because PHP turned out to be a lazy dog and we moved on so I cannot give you current details. I suspect that --with-PDO-sqlite is a default and you have to define --without-PDO-sqlite to defeat it. My dim memory suggests that I used grep to ferret out the sqlite options rather than the --help. The utf8 is to do with the character set. Others here are better equipped to explain that than I am. Ulrich Schöbel wrote: 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 sources in /usr/local/src/sqlite-3.3.13. You didn't mention --with-pdo-sqlite=... and --with-sqlite3 is not to be found with ./configure -help. What about --enable-sqlite-utf8? What does that mean? Ulrich On Thursday 05 April 2007 21:25, John Stanton wrote: This is what I used - To install with SQLITE V3 configure - --without-sqlite --with-sqlite3=/usr/local --with-apxs=/usr/local/apache/bin/apxs - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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 sources in /usr/local/src/sqlite-3.3.13. You didn't mention --with-pdo-sqlite=... and --with-sqlite3 is not to be found with ./configure -help. What about --enable-sqlite-utf8? What does that mean? Ulrich On Thursday 05 April 2007 21:25, John Stanton wrote: >This is what I used - >To install with SQLITE V3 configure - > > --without-sqlite --with-sqlite3=/usr/local > --with-apxs=/usr/local/apache/bin/apxs - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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.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. 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, 2007 1:40 PM To: sqlite-users@sqlite.org Subject: [sqlite] PHP5 and SQLite3.3.13 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 anybody in the know? Thanks Ulrich - To unsubscribe, send email to [EMAIL PROTECTED] - --- -- To unsubscribe, send email to [EMAIL PROTECTED] --- -- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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. > 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, 2007 1:40 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] PHP5 and SQLite3.3.13 > > 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 anybody in the know? > > Thanks > > Ulrich > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > --- >-- To unsubscribe, send email to [EMAIL PROTECTED] > --- >-- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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 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 anybody in the know? Thanks Ulrich - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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 anybody in the know? > I think you have to use the PDO interface to get at SQLite3 from PHP. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] PHP5 and SQLite3.3.13
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, 2007 1:40 PM To: sqlite-users@sqlite.org Subject: [sqlite] PHP5 and SQLite3.3.13 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 anybody in the know? Thanks Ulrich - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PHP5 and SQLite3.3.13
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 packages, so if you get 2.8.x you have the wrong source. Regards, ~ Nuno Lucas Is there anybody in the know? Thanks Ulrich - To unsubscribe, send email to [EMAIL PROTECTED] -