Dreamweaver

This may have been better posted in the advocacy list but I am not a
subscriber.

We recently purchased Dreamweaver MX and I was a little surprised to
find that one of its pre-defined scripting systems is PHP + MySQL. I
haven't done much exploring of what is actually offered but wondered
whether any one had tried to convince Macromedia to provide a PHP +
PostgreSQL or at least a PHP + anydb.

If the support for MySQL is in the form of an Extension, is there a
PostgreSQL equivalent as I have been contacted by one of our clients who
has said, "Do we povide MySQL ?", we dont. "Oh! I am teaching myself PHP
+ MySQL using Dreamweaver and I wanted you to host the site" :-(

I use PHP + PosgreSQL alot. I'd love to be able to help people who have
the impression that MySQL is all there is !! When the toolset they have
only mentions MySQL it is easy to understand how they come to that
conclusion.
--

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015

"A Ministry specialising in providing low-cost professional Internet
Services to NZ Christian Churches, Ministries and Organisations"



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

re: Dreamweaver

> This may have been better posted in the advocacy list but I am not a[color=blue]
> subscriber.
>
> We recently purchased Dreamweaver MX and I was a little surprised to
> find that one of its pre-defined scripting systems is PHP + MySQL. I
> haven't done much exploring of what is actually offered but wondered
> whether any one had tried to convince Macromedia to provide a PHP +
> PostgreSQL or at least a PHP + anydb.[/color]

PHP has a shortcoming of NOT having a unified interface to "any" DB. MySQL
uses one set of function calls, while PgSQL another. Yes, of course they
could add support for another (very popular) DB. But I'd rather feel out
their support for JSP/JDBC, which should be in :-)
[color=blue]
> If the support for MySQL is in the form of an Extension, is there a
> PostgreSQL equivalent as I have been contacted by one of our clients who
> has said, "Do we povide MySQL ?", we dont. "Oh! I am teaching myself PHP
> + MySQL using Dreamweaver and I wanted you to host the site" :-([/color]

The only unified interface offered by PHP, that I know of, is ODBC. I know
there are build options to fuse some Java support in, but that is, IMHO, a
waste of time and effort - not to mention resources.

Nix.


---------------------------(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

re: Dreamweaver

Nikola Milutinovic wrote:[color=blue][color=green]
> > This may have been better posted in the advocacy list but I am not a
> > subscriber.
> >
> > We recently purchased Dreamweaver MX and I was a little surprised to
> > find that one of its pre-defined scripting systems is PHP + MySQL. I
> > haven't done much exploring of what is actually offered but wondered
> > whether any one had tried to convince Macromedia to provide a PHP +
> > PostgreSQL or at least a PHP + anydb.[/color]
>
> PHP has a shortcoming of NOT having a unified interface to "any" DB. MySQL
> uses one set of function calls, while PgSQL another. Yes, of course they
> could add support for another (very popular) DB. But I'd rather feel out
> their support for JSP/JDBC, which should be in :-)[/color]

Sounds like PHP needs something similar to DBD for Perl.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

re: Dreamweaver

The closet thing PHP has is PEAR - it has the Dataobject concept and is as
close to "neutral" as PHP gets. A long time ago, I wrote a "DB Neutral set of
routines which works with Oracle, Postgresql and, untested, MySQL. That just
seemed to be the easiest thing to do, but I have not tried to plug it into
Dreamweaver.

Ken


Quoting Bruce Momjian <pgman@candle.pha.pa.us>:
[color=blue]
> Nikola Milutinovic wrote:[color=green][color=darkred]
> > > This may have been better posted in the advocacy list but I am not a
> > > subscriber.
> > >
> > > We recently purchased Dreamweaver MX and I was a little surprised to
> > > find that one of its pre-defined scripting systems is PHP + MySQL. I
> > > haven't done much exploring of what is actually offered but wondered
> > > whether any one had tried to convince Macromedia to provide a PHP +
> > > PostgreSQL or at least a PHP + anydb.[/color]
> >
> > PHP has a shortcoming of NOT having a unified interface to "any" DB. MySQL
> > uses one set of function calls, while PgSQL another. Yes, of course they
> > could add support for another (very popular) DB. But I'd rather feel out
> > their support for JSP/JDBC, which should be in :-)[/color]
>
> Sounds like PHP needs something similar to DBD for Perl.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>[/color]


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

re: Dreamweaver

In response to "Bruce Momjian":[color=blue]
> Nikola Milutinovic wrote:[color=green][color=darkred]
>>> We recently purchased Dreamweaver MX and I was a little surprised to
>>> find that one of its pre-defined scripting systems is PHP + MySQL. I
>>> haven't done much exploring of what is actually offered but wondered
>>> whether any one had tried to convince Macromedia to provide a PHP +
>>> PostgreSQL or at least a PHP + anydb.[/color]
>> PHP has a shortcoming of NOT having a unified interface to "any" DB.
>> MySQL uses one set of function calls, while PgSQL another. Yes, of
>> course they could add support for another (very popular) DB. But I'd
>> rather feel out their support for JSP/JDBC, which should be in :-)[/color]
> Sounds like PHP needs something similar to DBD for Perl.[/color]
True, you need to change commands at PHP, while DBD requires only the change
of a parameter.

Doing what he has to do, OP might try to use the standard binary
distribution of PHP at http://www.php.net/downloads.php -PHP does offer
PG-support through an extention module- and use a PHP extension for
Macromedia Dreamweaver MX from http://www.interakt.ro/products/PHAkt/

Just for what it might be worth,

Hans




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

re: Dreamweaver

The closet thing PHP has is PEAR - it has the Dataobject concept and is as
close to "neutral" as PHP gets. A long time ago, I wrote a "DB Neutral set
of
routines which works with Oracle, Postgresql and, untested, MySQL. That
just
seemed to be the easiest thing to do, but I have not tried to plug it into
Dreamweaver.

---

Is PEAR standardized and present by default? If not, then Macromedia has no
reason to support anything from it. This doesn't mean that your code is
bad - it is most likely the opposite.

Nix.


---------------------------(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

re: Dreamweaver

check out the libraries:

<metabase>
<adodb>

Nikola Milutinovic wrote:
[color=blue][color=green]
>>This may have been better posted in the advocacy list but I am not a
>>subscriber.
>>
>>We recently purchased Dreamweaver MX and I was a little surprised to
>>find that one of its pre-defined scripting systems is PHP + MySQL. I
>>haven't done much exploring of what is actually offered but wondered
>>whether any one had tried to convince Macromedia to provide a PHP +
>>PostgreSQL or at least a PHP + anydb.[/color]
>
>
> PHP has a shortcoming of NOT having a unified interface to "any" DB. MySQL
> uses one set of function calls, while PgSQL another. Yes, of course they
> could add support for another (very popular) DB. But I'd rather feel out
> their support for JSP/JDBC, which should be in :-)
>
>[color=green]
>>If the support for MySQL is in the form of an Extension, is there a
>>PostgreSQL equivalent as I have been contacted by one of our clients who
>>has said, "Do we povide MySQL ?", we dont. "Oh! I am teaching myself PHP
>>+ MySQL using Dreamweaver and I wanted you to host the site" :-([/color]
>
>
> The only unified interface offered by PHP, that I know of, is ODBC. I know
> there are build options to fuse some Java support in, but that is, IMHO, a
> waste of time and effort - not to mention resources.
>
> Nix.
>
>
> ---------------------------(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
>[/color]


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

re: Dreamweaver

On Sat, 2003-08-16 at 12:34, Ken Harris wrote:[color=blue]
> The closet thing PHP has is PEAR - it has the Dataobject concept and is as
> close to "neutral" as PHP gets. A long time ago, I wrote a "DB Neutral set of
> routines which works with Oracle, Postgresql and, untested, MySQL. That just
> seemed to be the easiest thing to do, but I have not tried to plug it into
> Dreamweaver.[/color]

PHP also has a module called dbx that allows you to do this as well. It
has some serious performance advantages over the PEAR library because it
is a module (written in C) rather than a bunch of PHP classes.

More on dbx here:

http://ca.php.net/manual/en/ref.dbx.php

Cheers,

Chris

--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax: (514) 398-2017

---------------------------(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