Any recommendations for a content management program for PHP + PostgreSQL.
Today I was looking at PostNuke, but it uses MySQL.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
As far as i was aware, the PostNuke guys had just switched to using ADODB
for their db abstraction layer and so postgres support was possible - I
might be wrong tho.
Chris
> -----Original Message-----
> From: pgsql-php-owner@postgresql.org
> [mailto:pgsql-php-owner@postgresql.org]On Behalf Of Francisco Reyes
> Sent: Monday, 8 April 2002 9:21 AM
> To: PostgresSQL PHP list
> Subject: [PHP] Content management in PHP + PostgreSQL
>
>
> Any recommendations for a content management program for PHP + PostgreSQL.
>
> Today I was looking at PostNuke, but it uses MySQL.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
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!
Vince.
--
============================================================ ==============
Vince Vielhaber -- KA8CSH email: vev@michvhf.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
============================================================ ==============
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
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?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
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@michvhf.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
============================================================ ==============
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Check out drupal.org
I have never used it.
Best regards
Andy
----- Original Message -----
From: Francisco Reyes
To: Vince Vielhaber
Cc: Francisco Reyes
Sent: Monday, April 08, 2002 6:51 PM
Subject: Re: [PHP] Content management in PHP + PostgreSQL
> 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.
> >
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Mon, 8 Apr 2002, Vince Vielhaber wrote:
> We discussed it
> recently in Hackers but I don't think anything's happened yet and I
> haven't looked at it yet.
When you say "we discussed it recently... " Do you mean submited
your changes to them?
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On Mon, 8 Apr 2002, Francisco Reyes wrote:
> On Mon, 8 Apr 2002, Vince Vielhaber wrote:
>
> > We discussed it
> > recently in Hackers but I don't think anything's happened yet and I
> > haven't looked at it yet.
>
> When you say "we discussed it recently... " Do you mean submited
> your changes to them?
No, it was discussed a while back and the decision was that
INSERT INTO foo(foo.a) ...
wouldn't be supported. However with other databases supporting it and
software such as postnuke trying to do it, that it would be supported
under certain conditions. But AFAIK noone's submitted a patch.
Vince.
--
============================================================ ==============
Vince Vielhaber -- KA8CSH email: vev@michvhf.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
============================================================ ==============
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
On Mon, 8 Apr 2002, Vince Vielhaber wrote:
> No, it was discussed a while back and the decision was that
>
> INSERT INTO foo(foo.a) ...
> wouldn't be supported. However with other databases supporting it and
> software such as postnuke trying to do it, that it would be supported
> under certain conditions. But AFAIK noone's submitted a patch.
Ok.. thanks for the info. I guess I will pass on post-nuke for now.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hello Francisco,
Monday, April 8, 2002, 3:20:40 AM, you wrote:
FR> Any recommendations for a content management program for PHP + PostgreSQL.
There is a commercial 4 business only CMS from our company
based on postgresql + optional mysql called CMS/R, examples at
www.x-itec.net and a customer example at www.familienservice.de
I´m sorry currently only with german documentation and
administration, but we are working for an international version.
Maybe it´s interesting for anyone, maybe not - who knows *g
--
Best regards,
Boris Köster mailto:koester@x-itec.de
Developer of X-ITEC CMS/R Content Management System (CMS)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)