From: | Jeff MacDonald <jam(at)zoidtechnologies(dot)com> |
---|---|
To: | vince(at)weaktight(dot)com |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: PHP/postgreSQL |
Date: | 2006-02-05 05:02:49 |
Message-ID: | 1139115769.3296.236.camel@dionysus.zoidtechnologies.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | vince | 2006-02-05 05:50:01 | Re: PHP/postgreSQL |
Previous Message | vince | 2006-02-05 04:24:41 | Re: PHP/postgreSQL |