Topic: 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?

Re: 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.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: anybody using sqlite3 ?

Mmm.... i see.

php.net wrote:

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.

Re: anybody using sqlite3 ?

pedrotuga wrote:

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.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: anybody using sqlite3 ?

That's a cool database abstraction then.
I think it can be practical to use in other applications, that's what i meant

Re: anybody using sqlite3 ?

PDO for PHP4 is also available, have look this classes here....
http://phpclasses.org/browse/package/2572.html

kirk

Re: anybody using sqlite3 ?

beipink wrote:

PDO for PHP4 is also available, have look this classes here....
http://phpclasses.org/browse/package/2572.html

kirk

Its not supported by hosting companies though, so rather irrelevant

Re: anybody using sqlite3 ?

Rickard wrote:

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 tongue

echo "deadram"; echo; fortune;

Re: anybody using sqlite3 ?

Connorhd wrote:
beipink wrote:

PDO for PHP4 is also available, have look this classes here....
http://phpclasses.org/browse/package/2572.html

kirk

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

Re: anybody using sqlite3 ?

Connorhd wrote:

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

Re: anybody using sqlite3 ?

Suprisingly enough, Netfirms supports SQLite versions 2 and 3 through PDO.

Unsurprisingly, they're too braindead to support MySQL through PDO.

Looking for a certain modification for your forum? Please take a look here before posting.