From: Jeff MacDonald <jam@zoidtechnologies.com>
To: vince@weaktight.com
Cc: pgsql-php@postgresql.org
Subject: Re: PHP/postgreSQL
Date: Sun, 05 Feb 2006 00:02:49 -0500
Message-ID: <1139115769.3296.236.camel@dionysus.zoidtechnologies.com> (raw)
In-Reply-To: <20060204232441.9ymj5rrdkc88gko4@webmail.weaktight.com>
References: <20060204171435.7lfphylyooggs08c@webmail.weaktight.com>
<1FC4E0E4-F55C-4308-8493-5680FEBD797E@ehpg.net>
<20060204185757.smqraps7408kwgog@webmail.weaktight.com>
<1139112287.3296.224.camel@dionysus.zoidtechnologies.com>
<20060204232441.9ymj5rrdkc88gko4@webmail.weaktight.com>
On Sat, 2006-02-04 at 23:24 -0500, vince@weaktight.com wrote:
> Quoting Jeff MacDonald <jam@zoidtechnologies.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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: jam@zoidtechnologies.com, vince@weaktight.com
Subject: Re: PHP/postgreSQL
In-Reply-To: <1139115769.3296.236.camel@dionysus.zoidtechnologies.com>
References: <20060204171435.7lfphylyooggs08c@webmail.weaktight.com> <1FC4E0E4-F55C-4308-8493-5680FEBD797E@ehpg.net> <20060204185757.smqraps7408kwgog@webmail.weaktight.com> <1139112287.3296.224.camel@dionysus.zoidtechnologies.com> <20060204232441.9ymj5rrdkc88gko4@webmail.weaktight.com> <1139115769.3296.236.camel@dionysus.zoidtechnologies.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox