Re: PHP/postgreSQL

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/