The latest PHP DB abstraction layer incorporates the current version of
Sqlite, along with other DBMS's. We use it.
When I compiled PHP V5 to fit into Apache 2 I used the following
configure options -
--without-sqlite --with-sqlite3=/usr/local
--with-apxs=/usr/local/apache/bin/apxs
The common PHP DB interface then accesses Sqlite3, in this case
Sqlite3.2.7 which was the current Sqlite servion at the time. We also
added PostgreSQL 8.0.1 to PHP using the same interface.
Night Media LTD wrote:
Hello John, and thanks for the idea.
But PHP DB is only an abstraction layer, it need a sqlite extention to work
with sqlite database. And this extension only exist at present in pecl of
The sqlite 2.
I think I will go ahead with php 2. And lose in mind the 30% database size
Reduction of the version 3 ... And the better concurrency .....
Best Regards
Derel Bruno
-------Message original-------
De : John Stanton
Date : 05/09/06 00:43:51
A : sqlite-users@sqlite.org
Sujet : Re: [sqlite] Réf. : Re: [sqlite] How to get the lastest version of
SQLITE with PHP ???
Why don't you use the standard PHP DB abstraction layer which provides a
Common interface to all DBMS's and incorporates the current version of
Sqlite, Sqlite3? As I see it the Sqlite2 you are using is in PHP for
Historical reasons to support legacy code.
JS
Night Media LTD wrote:
Due to the size of the binary, I ve choose to develop my application under
php4 instead of php 5
I ve try to install sqlite3
And the only solution I ve found was a plugin developped
http://php-sqlite3
sourceforge.net/
But when trying it, it look bugged, when file are created with :memory:
everything is ok, and as soon we use a file, nothing working anymore.
Anyone has resolve this issue ? (the only other way I got to use sqlite is
by a PECL extension sqlite => but version 2.8.12 => nearly obsolete)
Any help will be appreciate.
Its incredible that a big language as PHP cannot have the lastest version
of
sqlite running with...
Best Regards
Derel Bruno
-------Message original-------
De : Ivan Voras
Date : 05/07/06 21:57:29
A : sqlite-users@sqlite.org
Sujet : Re: [sqlite] How to get the lastest version of SQLITE with PHP ???
--- Night Media LTD <[EMAIL PROTECTED]> wrote:
Release What has changed?
1.0.1 - Updated libsqlite in ext/pdo_sqlite to
3.2.8. (Ilia)
From the source of config.m4 in ext/pdo_sqlite:
--with-pdo-sqlite[=DIR] PDO: sqlite support. DIR is
The sqlite base directory, the bundled sqlite is used
By default])
On my platform (FreeBSD) the bundled version is not
Used by default so that's how I came to the wrong
Conclusion. If you can rebuild it from scratch, maybe
You also can exclude the bundled library.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the Best spam protection around
http://mail.yahoo.com
__________ Information NOD32 1.1525 (20060508) __________
Ce message a ete verifie par NOD32 Antivirus System.
http://www.nod32.com
