pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedContent management in PHP + PostgreSQL
10+ messages / 5 participants
[nested] [flat]
* Content management in PHP + PostgreSQL
@ 2002-04-08 01:20 Francisco Reyes <lists@natserv.com>
0 siblings, 3 replies; 10+ messages in thread
From: Francisco Reyes @ 2002-04-08 01:20 UTC (permalink / raw)
To: pgsql-php
Any recommendations for a content management program for PHP + PostgreSQL.
Today I was looking at PostNuke, but it uses MySQL.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 02:08 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Francisco Reyes <lists@natserv.com>
2 siblings, 0 replies; 10+ messages in thread
From: Christopher Kings-Lynne @ 2002-04-08 02:08 UTC (permalink / raw)
To: Francisco Reyes <lists@natserv.com>; pgsql-php
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
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 03:56 Vince Vielhaber <vev@michvhf.com>
parent: Francisco Reyes <lists@natserv.com>
2 siblings, 1 reply; 10+ messages in thread
From: Vince Vielhaber @ 2002-04-08 03:56 UTC (permalink / raw)
To: Francisco Reyes <lists@natserv.com>; +Cc: pgsql-php
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
==========================================================================
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 11:51 Francisco Reyes <lists@natserv.com>
parent: Vince Vielhaber <vev@michvhf.com>
0 siblings, 2 replies; 10+ messages in thread
From: Francisco Reyes @ 2002-04-08 11:51 UTC (permalink / raw)
To: Vince Vielhaber <vev@michvhf.com>; +Cc: Francisco Reyes <lists@natserv.com>; pgsql-php
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?
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 11:59 Vince Vielhaber <vev@michvhf.com>
parent: Francisco Reyes <lists@natserv.com>
1 sibling, 1 reply; 10+ messages in thread
From: Vince Vielhaber @ 2002-04-08 11:59 UTC (permalink / raw)
To: Francisco Reyes <lists@natserv.com>; +Cc: pgsql-php
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
==========================================================================
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 12:10 Andy Samuel <anci@centrin.net.id>
parent: Francisco Reyes <lists@natserv.com>
1 sibling, 0 replies; 10+ messages in thread
From: Andy Samuel @ 2002-04-08 12:10 UTC (permalink / raw)
To: pgsql-php
Check out drupal.org
I have never used it.
Best regards
Andy
----- Original Message -----
From: Francisco Reyes <lists@natserv.com>
To: Vince Vielhaber <vev@michvhf.com>
Cc: Francisco Reyes <lists@natserv.com>; PostgresSQL PHP list
<pgsql-php@postgresql.org>
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.
> >
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 14:41 Francisco Reyes <lists@natserv.com>
parent: Vince Vielhaber <vev@michvhf.com>
0 siblings, 1 reply; 10+ messages in thread
From: Francisco Reyes @ 2002-04-08 14:41 UTC (permalink / raw)
To: Vince Vielhaber <vev@michvhf.com>; +Cc: pgsql-php
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?
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 14:45 Vince Vielhaber <vev@michvhf.com>
parent: Francisco Reyes <lists@natserv.com>
0 siblings, 1 reply; 10+ messages in thread
From: Vince Vielhaber @ 2002-04-08 14:45 UTC (permalink / raw)
To: Francisco Reyes <lists@natserv.com>; +Cc: pgsql-php
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
==========================================================================
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-08 15:37 Francisco Reyes <lists@natserv.com>
parent: Vince Vielhaber <vev@michvhf.com>
0 siblings, 0 replies; 10+ messages in thread
From: Francisco Reyes @ 2002-04-08 15:37 UTC (permalink / raw)
To: Vince Vielhaber <vev@michvhf.com>; +Cc: pgsql-php
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.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Content management in PHP + PostgreSQL
@ 2002-04-11 18:00 Boris Köster <koester@x-itec.de>
parent: Francisco Reyes <lists@natserv.com>
2 siblings, 0 replies; 10+ messages in thread
From: Boris Köster @ 2002-04-11 18:00 UTC (permalink / raw)
To: pgsql-php; Francisco Reyes <lists@natserv.com>
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)
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2002-04-11 18:00 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-08 01:20 Content management in PHP + PostgreSQL Francisco Reyes <lists@natserv.com>
2002-04-08 02:08 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-04-08 03:56 ` Vince Vielhaber <vev@michvhf.com>
2002-04-08 11:51 ` Francisco Reyes <lists@natserv.com>
2002-04-08 11:59 ` Vince Vielhaber <vev@michvhf.com>
2002-04-08 14:41 ` Francisco Reyes <lists@natserv.com>
2002-04-08 14:45 ` Vince Vielhaber <vev@michvhf.com>
2002-04-08 15:37 ` Francisco Reyes <lists@natserv.com>
2002-04-08 12:10 ` Andy Samuel <anci@centrin.net.id>
2002-04-11 18:00 ` Boris Köster <koester@x-itec.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox