I cannot use the binaries at the download site for the user machine, they are built for Intel (X86) , and my target machine is a Power PC (ppc7400) CPUs.
I looked for info on "php_pdo_sqlite_external" and I didn't find anything helpful, and I don't know what it is or how to use it. Is it part of PHP? Assuming the architecture would be correct, how would I used that with PHP? Steffenhagen Kerm kst...@visi.com On Feb 5, 2010, at 7:27 PM, Kees Nuyt wrote: > On Fri, 5 Feb 2010 14:53:07 -0600, Steffenhagen Kerm > <kst...@visi.com> wrote: > >> Thanks for your response. >> >> I am not sure I understand you correctly or the software correctly, >> but I think the answer is "no". The system this is targeting is Mac >> OS >> X 10.4.x, and the native sqlite is 2.8.16. I was able to create a >> 3.2.8 pdo_sqlite shared library from source, and it works well. >> However I am looking for the "DROP IF EXISTS table" feature that >> requires 3.3 or above. None of the source archives at 3.3 and above >> are set up to build (phpize) for PHP. > > I hope you misunderstood me and can get it to work. > > php_pdo_sqlite_external allows you to use the sqlite3 > library you can download from > > http://www.sqlite.org/download.html > > The site has precompiled Binaries For Mac OS X (10.5, but it > may be compatible with 10.4, I'm not sure). Try it. > > The php_pdo_sqlite_external extension is just a glue layer > between php_pdo and a recent, original, not phpized, sqlite3 > library. That's a different construction than > php_pdo_sqlite3, which is phpized and has that old sqlite3 > release. > >> My own development system, Mac OS X 10.5 provides pdo_sqlite3 as part >> of a standard install, but I cannot use that module on my user's >> system, it need a PPC binary, and mine is Intel. >> >> The target system (Mac OS 10.4) >>> sqlite -version >> 2.8.16 >> >>> file /usr/local/php5/lib/php/extensions/no-debug-non-zts-20050922/ >> pdo_sqlite.so >> /usr/local/php5/lib/php/extensions/no-debug-non-zts-20050922/ >> pdo_sqlite.so: Mach-O bundle ppc >> >> My system (Mac OS 10.5) >>> sqlite3 -version >> ... >> 3.4.0 >> >>> file /usr/local/php5/lib/php/extensions/no-debug-non-zts-20060613/ >> pdo_pgsql.so >> /usr/local/php5/lib/php/extensions/no-debug-non-zts-20060613/ >> pdo_pgsql.so: Mach-O universal binary with 4 architectures >> /usr/local/php5/lib/php/extensions/no-debug-non-zts-20060613/ >> pdo_pgsql.so (for architecture i386): Mach-O bundle i386 >> /usr/local/php5/lib/php/extensions/no-debug-non-zts-20060613/ >> pdo_pgsql.so (for architecture x86_64)Mach-O 64-bit bundle x86_64 >> /usr/local/php5/lib/php/extensions/no-debug-non-zts-20060613/ >> pdo_pgsql.so (for architecture ppc7400): Mach-O bundle ppc >> /usr/local/php5/lib/php/extensions/no-debug-non-zts-20060613/ >> pdo_pgsql.so (for architecture ppc64):Mach-O 64-bit bundle ppc64 >> >> I would like to build (at least) "20060613" for PPC. >> >> Steffenhagen Kerm >> kst...@visi.com >> 651-430-1161 >> >> >> >> On Feb 5, 2010, at 2:11 PM, Kees Nuyt wrote: >> >>> On Fri, 5 Feb 2010 11:51:33 -0600, Steffenhagen Kerm >>> <kst...@visi.com> wrote: >>> >>>> I am new to this list. I'm looking for assistance building a PHP >>>> version of SQLite 3 (pdo_sqlite3) that is at or above version >>>> 3.3. I >>>> have built and installed a 3.2.8 version, but none of the higher >>>> versions of source conform to the format required to "phpize" them, >>>> and build for PHP PDO. >>>> >>>> Can anyone help? >>> >>> Is php_pdo_sqlite_external an option for you? >>> >>> It allows you to use the native sqlite3 library. >>> >>>> Kerm Steffenhagen >>>> kst...@visi.com >>> -- >>> ( Kees Nuyt >>> ) >>> c[_] >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- > ( Kees Nuyt > ) > c[_] > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users