Re: Content management in PHP + PostgreSQL

On Mon, 8 Apr 2002, Francisco Reyes wrote:

> On Sun, 7 Apr 2002, Vince Vielhaber wrote:
>
> > On Sun, 7 Apr 2002, Francisco Reyes wrote:
> >
> > > Any recommendations for a content management program for PHP + PostgreSQL.
> > >
> > > Today I was looking at PostNuke, but it uses MySQL.
> >
> > It's a REAL pain in the ass, but I've gotten PostNuke to run with
> > PostgreSQL. For the most part the core stuff is already adodb, but
> > the modules are lacking in readiness. Check out www.clickcorrs.com
> > to see where we're at - it's been production since St Paddy's Day.
> > Ain't been a hell of alot of sleep either since then!
>
> Where do I get the latest code? From the Post-Nuke web site?

I grabbed it from CVS sometime around the 7.1 release which wasn't
adodb complete yet. 7.1.1 is on the website but I haven't looked at
it yet. The table setups also took alot of converting but my2pg.pl
got me 99% of the way there. I just had to manually go thru and touch
things up.

One of the biggest problems is that they use the same table variables
for inserts, updates and selects. Unfortunately they define them as
table.column which doesn't work in pg with inserts. We discussed it
recently in Hackers but I don't think anything's happened yet and I
haven't looked at it yet. I got rid of the table. part of it and went
in and cleaned up the couple dozen or so selects that needed it. I
liked the look and ease of administration of postnuke or I wouldn't
have gone thru the trouble and the PostNukeBlue theme looks really
nice, but doesn't work 100% with netscape 4.7x.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================