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