pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/




view thread (16+ messages)  latest in thread

Message-ID: <1139115769.3296.236.camel@dionysus.zoidtechnologies.com>
Permalink:  ../1139115769.3296.236.camel@dionysus.zoidtechnologies.com/
Also on:    postgresql.org/message-id/1139115769.3296.236.camel@dionysus.zoidtechnologies.com

 · 

reply

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