Dreamweaver

Hi Glen,

Glen Eustace wrote:

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.

Usually Macromedia avoids to support anything good :-)
You can however try to script the support into Dreamweaver
using Javascript (most of DWs functionallity is written
in Javascript)

Regards
Tino Wildenhain

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.

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 :-)

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

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.

Nikola Milutinovic wrote:

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.

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 :-)

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

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

Nikola Milutinovic wrote:

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.

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 :-)

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

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

On Saturday 16 August 2003 18:24, Bruce Momjian wrote:

Nikola Milutinovic wrote:

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.

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 :-)

Sounds like PHP needs something similar to DBD for Perl.

There are several libraries such as PEAR::DB and ADODB
(http://php.weblogs.com/ADODB) available, although none
has achieved similar universality to Perl's DBI.

Ian Barwick
barwick@gmx.net

Glen Eustace wrote:

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.

I haven't tried the combination PHP + PostgreSQL but my efforts
to get ColdFusion + PostgreSQL supported were rather unsuccessful
so far.

Your best bet is to write the necessary extensions yourself.
Second best is to fill out http://www.macromedia.com/go/wish/ and
make sure everybody else who feels the same does so too.

Jochem

--
Jochem van Dieten
Team Macromedia Volunteer for ColdFusion

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 :-)

Sounds like PHP needs something similar to DBD for Perl.

It actually does. The PEAR DB Support stuff isn't too bad. I have used
it several times when I wasn't sure which database was going to be used.

I suppose in addition to asking my question, was the unasked one. If
PostgreSQL is to gain broader appeal, then developers like Macromedia
need to be conviced to either make their products 'database neutral' by
providing a generic hook or providing more than one of the popular
alternatives. As it is, there are a bunch of web designers using DW
that go straight for a PHP+MySQL solution because that is what DW
supports :-( PostgreSQL doesn't even get a look in.

Glen
--

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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"

Glen Eustace wrote:

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 :-)

Sounds like PHP needs something similar to DBD for Perl.

It actually does. The PEAR DB Support stuff isn't too bad. I have used
it several times when I wasn't sure which database was going to be used.

I suppose in addition to asking my question, was the unasked one. If
PostgreSQL is to gain broader appeal, then developers like Macromedia
need to be conviced to either make their products 'database neutral' by
providing a generic hook or providing more than one of the popular
alternatives. As it is, there are a bunch of web designers using DW
that go straight for a PHP+MySQL solution because that is what DW
supports :-( PostgreSQL doesn't even get a look in.

Glen

Dreamweaver can interface with various DBs using PEAR, ADOdb, dbx functions.

I do most of my development using dreamweaver and the free extenstion -
to dreamweaver - PHAkt - from interakt
http://www.interakt.ro/products/PHAkt/index.php

It supports multiple databases including my favorite - PostgreSQL -
using ADOdb.

Tim.

In response to "Bruce Momjian":

Nikola Milutinovic wrote:

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.

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 :-)

Sounds like PHP needs something similar to DBD for Perl.

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

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.

check out the libraries:

<metabase>
<adodb>

Nikola Milutinovic wrote:

On Sat, 2003-08-16 at 15:12, Jochem van Dieten wrote:

Glen Eustace wrote:

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.

I haven't tried the combination PHP + PostgreSQL but my efforts
to get ColdFusion + PostgreSQL supported were rather unsuccessful
so far.

Well, some folks are certainly doing it, check out this blog entry:

http://www.redev.org/archives/000023.cfm#more

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

On Sat, 2003-08-16 at 12:34, Ken Harris wrote:

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.

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