Thread: phpBB 2.2 and PostgreSQL support

phpBB 2.2 and PostgreSQL support

From
Birzan George Cristian
Date:
Hello!

I recently tried the open source forum software phpBB the CVS version,
2.1/2.2. To my surprise, I've found that it's lacking PostgreSQL
support, or, rather, that its support is not functional.

After playing around for a bit, I managed to get a semi-functional
2version working, I went and had a talk with the phpBB people. Amazingly
enough, they refused to accept any of my changes in their codebase,
saying it's still too early for that and the developers will fix it when
they think the time is right.

The reason I'm mailing you is that I've managed to get a relatively
functional version of it and wondered if anyone is interested in
helping me further maintain/fix it, until the phpBB developers
consider it's time to support other SQL backends.

For those interested, I've put up my version up on CVS on=20
:pserver:anonymous@cvs.wolfheart.ro:/phpbb, the module being
phpbb2-pgsql, press enter for the password.
(For reasons beyond my comprehension at this late/early hour, cvsd seems
to freeze once in a while, when one tries to login, so don't do that :-P.
Seriously, though,  even if it does break, there's
http://cvs.wolfheart.ro/cgi-bin/cvsweb/phpbb2-pgsql/ from where you can
download a tarball until I wake up and actually get cvs working
properly)

So, if anyone is interested, drop me a line. If you want to keep this
thread on pgsql-general, please Cc: me as I am not subscribed.

--
Birzan George            Violence is the last refuge of
  Cristian            the incompetent -- Salvor Hardin

Attachment

Re: phpBB 2.2 and PostgreSQL support

From
Birzan George Cristian
Date:
On Sun, Feb 22, 2004 at 09:52:25PM +0100, David Costa wrote:
> Are you sure they don't support it ? from their site "Based on the
> powerful PHP server language and your choice of MySQL, MS-SQL,
> PostgreSQL or Access/ODBC database servers, phpBB is the ideal free
> community solution for all web sites." What kind of db abstraction
> layer they use ? Pear DB?

They wrote their own. And it's supported, in 2.0.x, not in 2.1/2.2,
which is the development version.
http://area51.phpbb.com/phpBB22/viewtopic.php?t=14033#88003
(It's not only the schema, but still)

--
Birzan George            Violence is the last refuge of
  Cristian            the incompetent -- Salvor Hardin

Attachment

Re: phpBB 2.2 and PostgreSQL support

From
Adam Alkins
Date:
The phpBB developers have always maintained a policy of doing their code
in house. 2.2 is still ALPHA, you really can't fault them for not fixing
the PostgreSQL code yet. The developers work on MySQL natively, then
they polish up everything else before releasing it as a package.

It really should not be "surprising" or "amazing".

-Adam

Birzan George Cristian wrote:

>Hello!
>
>I recently tried the open source forum software phpBB the CVS version,
>2.1/2.2. To my surprise, I've found that it's lacking PostgreSQL
>support, or, rather, that its support is not functional.
>
>After playing around for a bit, I managed to get a semi-functional
>2version working, I went and had a talk with the phpBB people. Amazingly
>enough, they refused to accept any of my changes in their codebase,
>saying it's still too early for that and the developers will fix it when
>they think the time is right.
>
>The reason I'm mailing you is that I've managed to get a relatively
>functional version of it and wondered if anyone is interested in
>helping me further maintain/fix it, until the phpBB developers
>consider it's time to support other SQL backends.
>
>For those interested, I've put up my version up on CVS on=20
>:pserver:anonymous@cvs.wolfheart.ro:/phpbb, the module being
>phpbb2-pgsql, press enter for the password.
>(For reasons beyond my comprehension at this late/early hour, cvsd seems
>to freeze once in a while, when one tries to login, so don't do that :-P.
>Seriously, though,  even if it does break, there's
>http://cvs.wolfheart.ro/cgi-bin/cvsweb/phpbb2-pgsql/ from where you can
>download a tarball until I wake up and actually get cvs working
>properly)
>
>So, if anyone is interested, drop me a line. If you want to keep this
>thread on pgsql-general, please Cc: me as I am not subscribed.
>
>--
>Birzan George            Violence is the last refuge of
>  Cristian            the incompetent -- Salvor Hardin
>
>


--
Adam Alkins
1-868-627-9115
http://www.rasadam.com


Attachment

Re: [GENERAL] phpBB 2.2 and PostgreSQL support

From
Harry Broomhall
Date:
Adam Alkins writes:
> The phpBB developers have always maintained a policy of doing their code
> in house. 2.2 is still ALPHA, you really can't fault them for not fixing
> the PostgreSQL code yet. The developers work on MySQL natively, then
> they polish up everything else before releasing it as a package.
>
> It really should not be "surprising" or "amazing".

   I haven't seen the original posting, so I'm commenting on this comment
(so to speak)

   I run phpBB 2.0.6 with PostgreSQL with no probs at all.  I just downloaded
the package from www.phpbb.com and followed the instructions.  It was one
of the easist installations I can remember for a long time!

   Downloading CVS/ALPHA has always struck me as living dangerously!
   And I note that 2.0.6 is the current release.

   Regards,
       Harry.

> >Hello!
> >
> >I recently tried the open source forum software phpBB the CVS version,
> >2.1/2.2. To my surprise, I've found that it's lacking PostgreSQL
> >support, or, rather, that its support is not functional.
> >
> >After playing around for a bit, I managed to get a semi-functional
> >2version working, I went and had a talk with the phpBB people. Amazingly
> >enough, they refused to accept any of my changes in their codebase,
> >saying it's still too early for that and the developers will fix it when
> >they think the time is right.
> >
> >The reason I'm mailing you is that I've managed to get a relatively
> >functional version of it and wondered if anyone is interested in
> >helping me further maintain/fix it, until the phpBB developers
> >consider it's time to support other SQL backends.
[SNIP]


Re: phpBB 2.2 and PostgreSQL support

From
David Costa
Date:
On Feb 22, 2004, at 12:19 PM, Birzan George Cristian wrote:
>
<snip>

> For those interested, I've put up my version up on CVS on=20
> :pserver:anonymous@cvs.wolfheart.ro:/phpbb, the module being
> phpbb2-pgsql, press enter for the password.
> (For reasons beyond my comprehension at this late/early hour, cvsd
> seems
> to freeze once in a while, when one tries to login, so don't do that
> :-P.
> Seriously, though,  even if it does break, there's
> http://cvs.wolfheart.ro/cgi-bin/cvsweb/phpbb2-pgsql/ from where you can
> download a tarball until I wake up and actually get cvs working
> properly)
>
> So, if anyone is interested, drop me a line. If you want to keep this
> thread on pgsql-general, please Cc: me as I am not subscribed.
>
> --
> Birzan George            Violence is the last refuge of
>   Cristian            the incompetent -- Salvor Hardin
>

Hi!
Are you sure they don't support it ? from their site "Based on the
powerful PHP server language and your choice of MySQL, MS-SQL,
PostgreSQL or Access/ODBC database servers, phpBB is the ideal free
community solution for all web sites." What kind of db abstraction
layer they use ? Pear DB?

Regards,
David Costa, PostgreSQL Advocate      PHP&PostgreSQL tutorials at
http://dotgeek.org
david at postgresql ddoot org                 gurugeek att php dot net
$dsn = 'pgsql://world:most_advanced@localhost/open_source_database';