# php-5.1.5 without sqlite3 support?

- Thread: https://externals.io/message/25409
- Original archive: https://news-web.php.net/php.internals/25409
- Started by Marten Lehmann on 2006-08-23T13:31:29+00:00
- Messages: 3
- Reply by email to internals@lists.php.net
- More for agents: search with https://externals.io/search.md?q={query} · JSON API at https://externals.io/api · documentation at https://externals.io/llms.txt

---

## #25409 — Marten Lehmann — 2006-08-23T13:31:29+00:00

URL: https://externals.io/message/25409#25409

Hello,

compiling php ends with an error on my system:

checking for sqlite_open in -lsqlite... no
configure: error: wrong sqlite lib version or lib not found

This is likely to happen, because I'm working with sqlite3 instead of 
sqlite 2.x:

ldconfig -p | grep sqlite
         libsqlite3.so.0 (libc6,x86-64) => /usr/lib/libsqlite3.so.0
         libsqlite3.so.0 (libc6,x86-64) => /usr/lib64/libsqlite3.so.0
         libsqlite3.so (libc6,x86-64) => /usr/lib/libsqlite3.so
         libsqlite3.so (libc6,x86-64) => /usr/lib64/libsqlite3.so

Sqlite 3.1.3 exists since Feb 19 2005, current release is 3.3.4. Why 
doesn't php support it? sqlite 2.x and sqlite 3.x have a different 
database format, so they are not compatible. All functions are prefixed 
with sqlite3, e.g. sqlite3_open instead of sqlite_open.

Is someone working on a --with-sqlite3 option?

Regards
Marten

---

## #25410 — Ilia Alshanetsky — 2006-08-23T13:37:47+00:00

URL: https://externals.io/message/25409#25410 · In reply to: #25409

SQLite 3 support is available in PHP 5.2.0 (currently in release  
process) through pdo_sqlite extension. There are no plans to add  
support for sqlite3 for the sqlite extension at this time.




> Hello,
>
> compiling php ends with an error on my system:
>
> checking for sqlite_open in -lsqlite... no
> configure: error: wrong sqlite lib version or lib not found
>
> This is likely to happen, because I'm working with sqlite3 instead  
> of sqlite 2.x:
>
> ldconfig -p | grep sqlite
>         libsqlite3.so.0 (libc6,x86-64) => /usr/lib/libsqlite3.so.0
>         libsqlite3.so.0 (libc6,x86-64) => /usr/lib64/libsqlite3.so.0
>         libsqlite3.so (libc6,x86-64) => /usr/lib/libsqlite3.so
>         libsqlite3.so (libc6,x86-64) => /usr/lib64/libsqlite3.so
>
> Sqlite 3.1.3 exists since Feb 19 2005, current release is 3.3.4.  
> Why doesn't php support it? sqlite 2.x and sqlite 3.x have a  
> different database format, so they are not compatible. All  
> functions are prefixed with sqlite3, e.g. sqlite3_open instead of  
> sqlite_open.
>
> Is someone working on a --with-sqlite3 option?
>
> Regards
> Marten
>
> -- 
> 
> 
>
>

Ilia Alshanetsky

---

## #25411 — Antony Dovgal — 2006-08-23T13:39:08+00:00

URL: https://externals.io/message/25409#25411 · In reply to: #25409

SQLite3 is supported by PDO_SQLite.
ext/sqlite supports only SQLite2.


> Hello,
> 
> compiling php ends with an error on my system:
> 
> checking for sqlite_open in -lsqlite... no
> configure: error: wrong sqlite lib version or lib not found
> 
> This is likely to happen, because I'm working with sqlite3 instead of 
> sqlite 2.x:
> 
> ldconfig -p | grep sqlite
>          libsqlite3.so.0 (libc6,x86-64) => /usr/lib/libsqlite3.so.0
>          libsqlite3.so.0 (libc6,x86-64) => /usr/lib64/libsqlite3.so.0
>          libsqlite3.so (libc6,x86-64) => /usr/lib/libsqlite3.so
>          libsqlite3.so (libc6,x86-64) => /usr/lib64/libsqlite3.so
> 
> Sqlite 3.1.3 exists since Feb 19 2005, current release is 3.3.4. Why 
> doesn't php support it? sqlite 2.x and sqlite 3.x have a different 
> database format, so they are not compatible. All functions are prefixed 
> with sqlite3, e.g. sqlite3_open instead of sqlite_open.
> 
> Is someone working on a --with-sqlite3 option?
> 
> Regards
> Marten
> 


-- 
Wbr, 
Antony Dovgal