[RFC|Accepted] Support of SQLite 3.0+

[rxu]

This RFC is partially brought about [RFC] PDO / third party DBAL request.
We really need 3.1 to support SQLite3 to meet modern requirements and satisfy users which are up to date with new versions of SQLite DBMS.

There's an approach by Boris Berdichevski that could be also considered: Support of SQLite 3.0+. The current state of the "patch" is here (not tested by me yet though) :

SQLite3.0_MOD.zip

(45.5 KiB) Downloaded 2320 times

[Boris Berdichevski]

I've tested yet.
And I've tested this many time with my Forum
There is a link for packet of DLLs need to install SQLite 3.0 & driver for php (Windows only). Include drivers for php 5.2.6 & 5.2.9
http://www.borisba.com/~borisba/phpBB3/sqlite3.dlls.zip

[bantu]

Ticket: http://tracker.phpbb.com/browse/PHPBB3-9728

[Sierron]

I'm also currently trying it. Nice Idea, but don't get it to work, because I don't want replace sqlite (2).

Edit: or otherwise. I see, that both things should work, but there also some things get deleted. Currently it doesn't work. I got an empty page, but I'll try to fix that.

[Boris Berdichevski]

Please use actual correct MOD (PDO, php 5.3.x)

[bantu]

Please use actual correct MOD (PDO, php 5.3.x)

Thank you. phpBB 3.1.x will only require PHP 5.2.x, so you cannot expect PHP 5.3.x.

[Boris Berdichevski]

But SQLite 3.0 started including from php 5.3.x!
User cannot use it if SQLite 3.0 doesn't support.
So, it's not a problem. When user start install / convert his forum, he views list of DB drivers there available.
Then, user can manually add SQLite 3.0 with PDO to previous (< 5.3.x) php version.

[bantu]

But SQLite 3.0 started including from php 5.3.x!
User cannot use it if SQLite 3.0 doesn't support.
So, it's not a problem. When user start install / convert his forum, he views list of DB drivers there available.
Then, user can manually add SQLite 3.0 with PDO to previous (< 5.3.x) php versiion.

Oh yes, you're right. Sorry. I thought it was already added in PHP 5.2.

[Boris Berdichevski]

So, previous version of this MOD used any php version with manually added SQLite3.0 driver, but without PDO. Then, previous version of the MOD doesn't work on standard php 5.3.x.

[bantu]

The question is whether it makes sense adding SQLite 3.0+ support using PDO without having a generic PDO implemention because that's been moved back to 3.2.