You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 discussion → anybody using sqlite3 ?
I am currently writing a script to migrate phorum to punbb. I want to migrate to punbb and sqlite instead of phorum/mysql. Just wondering if i should go for sqlite3 or sqlite2? In the documentation page it says that it has only been tested up to version 2? anybody using sqlite3?
Actually, PunBB does not support sqlite3 at all. Supporting it would mean supporting PDO (a new feature in PHP) and that won't happen for some time.
Mmm.... i see.
PDO provides a data-access abstraction layer, which means that, regardless of which database you're using, you use the same functions to issue queries and fetch data. PDO does not provide a database abstraction; it doesn't rewrite SQL or emulate missing features. You should use a full-blown abstraction layer if you need that facility.
Punbb already has such a feature. Rickard, I take the chance to ask, was it you writing punbb dblayer for punbb usage only? I think it could have been a good option to integrate in other applications before PDO.
Punbb already has such a feature. Rickard, I take the chance to ask, was it you writing punbb dblayer for punbb usage only? I think it could have been a good option to integrate in other applications before PDO.
I'm not sure I understand. Yes, I wrote the db abstraction class for PunBB only. At the time, there was no such thing as PDO. Anyway, PDO isn't really an option as virtually no hosting companies run PHP environments with PDO.
That's a cool database abstraction then.
I think it can be practical to use in other applications, that's what i meant
PDO for PHP4 is also available, have look this classes here....
http://phpclasses.org/browse/package/2572.html
kirk
PDO for PHP4 is also available, have look this classes here....
http://phpclasses.org/browse/package/2572.htmlkirk
Its not supported by hosting companies though, so rather irrelevant
Actually, PunBB does not support sqlite3 at all. Supporting it would mean supporting PDO (a new feature in PHP) and that won't happen for some time.
I've put my pdo sqlite3 mod on punres, if the link isn't in my sig, I'll edit this post 
beipink wrote:PDO for PHP4 is also available, have look this classes here....
http://phpclasses.org/browse/package/2572.htmlkirk
Its not supported by hosting companies though, so rather irrelevant
I just quote:
This package implements the PDO database abstraction interface that is compatible with PHP 4.
PDO is an extension introduced in PHP 5 that provides a common interface to several types of relational databases.
Since PDO only became standard extension with PHP 5.1 and very few hosting companies provide PHP 5.1 servers, the idea of this package is to provide an implementation of the PDO API that works under PHP 4 without special extension in a compatible way to the PHP 5 extension.
I can read in the way that hosting that support PHP4 have not istalled SQLite library ;-)
kirk
Its not supported by hosting companies though, so rather irrelevant
My two hosting run pdo sqlite since june 2006
it's ovh.com (free hosting demo1g look to the phpinfo in http://belguise.ovh.org)
and 1and1.fr
Suprisingly enough, Netfirms supports SQLite versions 2 and 3 through PDO.
Unsurprisingly, they're too braindead to support MySQL through PDO.
PunBB Forums → PunBB 1.2 discussion → anybody using sqlite3 ?
Powered by PunBB, supported by Informer Technologies, Inc.