Re: PHP/postgreSQL

[Jeff MacDonald <jam(at)zoidtechnologies(dot)com>]

On Sat, 2006-02-04 at 23:24 -0500, vince(at)weaktight(dot)com wrote:
> Quoting Jeff MacDonald <jam(at)zoidtechnologies(dot)com>:
> > ok.. now the hopefully easy question :): why are you trying to set
> > things up this way?

> Fair question.  I'll tell you what I'm trying to do, and perhaps you 
> can advise a better solution.
> 
> On my local machine I have a postpreSQL database.  This database I update
> constantly let's say.
> 
> Hosted on another machine in cyberspace is my webserver.  On this machine I have
> a webpage that I want to update using data from the database on my local
> machine.  The webserver is running PHP/mySQL.
> 

> I'm not sure if my web host would allow me to run a postgreSQL server on it as
> well.  So, ftp'ing the database up once a day say may not be an option.
> 

ask. if they say no, get an isp that will say yes.

> One of my original thoughts (before I understood the systems at all)
>  was that I would have to have a "cron" job running on my local machine
>  that would ftp up data as it was collected.  The webserver, the next
>  time a php script ran, would check for new data, parse it, add it to
>  the mySQL database on the webserver, and then run the scripts using
>  the data from the webserver's mySQL server.
> 

have you considered SOAP? as much as I "love" mySQL, it does work (most
of the time ;)) and with SOAP you can still update your data fairly
often.

regards,
J
-- 
Jeff MacDonald
Zoid Technologies, http://zoidtechnologies.com/