PHP db support was Re: [GENERAL] Dreamweaver

2003-09-17 Thread Christopher Murtagh
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

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [GENERAL] Dreamweaver

2003-08-18 Thread Robert Treat
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/23.cfm#more

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


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [GENERAL] Dreamweaver

2003-08-16 Thread Tino Wildenhain
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
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [GENERAL] Dreamweaver

2003-08-16 Thread Nikola Milutinovic
 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 [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly