[RFC|Accepted] Support of SQLite 3.0+

These requests for comments/change have lead to an implemented feature that has been successfully merged into the 3.1/Ascraeus branch. Everything listed in this forum will be available in phpBB 3.1.
User avatar
rxu
Registered User
Posts: 164
Joined: Tue Apr 04, 2006 4:28 pm
Contact:

[RFC|Accepted] Support of SQLite 3.0+

Post by 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 2292 times
Image

User avatar
Boris Berdichevski
Registered User
Posts: 5
Joined: Mon Jul 19, 2010 6:28 pm

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by Boris Berdichevski »

I've tested yet. :idea:
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

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by bantu »


User avatar
Sierron
Registered User
Posts: 62
Joined: Wed Aug 25, 2010 11:41 am
Contact:

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by 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.

User avatar
Boris Berdichevski
Registered User
Posts: 5
Joined: Mon Jul 19, 2010 6:28 pm

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by Boris Berdichevski »

Please use actual correct MOD (PDO, php 5.3.x)
Attachments
SQLite3.0_MOD_5.3.x.zip
SQLite3.0_MOD for php 5.3.x PDO 15-Dec-2010 01:09
(45.71 KiB) Downloaded 2060 times

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by bantu »

Boris Berdichevski wrote: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.

User avatar
Boris Berdichevski
Registered User
Posts: 5
Joined: Mon Jul 19, 2010 6:28 pm

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by 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.
Last edited by Boris Berdichevski on Wed Dec 15, 2010 3:27 pm, edited 1 time in total.

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by bantu »

Boris Berdichevski wrote: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.

User avatar
Boris Berdichevski
Registered User
Posts: 5
Joined: Mon Jul 19, 2010 6:28 pm

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by 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.

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: [RFC|Accepted] Support of SQLite 3.0+

Post by 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.

Post Reply