X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9454C9DC9F6 for ; Sun, 5 Feb 2006 01:02:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29656-03 for ; Sun, 5 Feb 2006 01:02:55 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2C8079DC9B9 for ; Sun, 5 Feb 2006 01:02:55 -0400 (AST) Received: from mxsf34.cluster1.charter.net (mxsf34.cluster1.charter.net [209.225.28.159]) by svr4.postgresql.org (Postfix) with ESMTP id 2ADA15AF0A9 for ; Sun, 5 Feb 2006 05:02:52 +0000 (GMT) Received: from mxip26a.cluster1.charter.net (mxip26a.cluster1.charter.net [209.225.28.181]) by mxsf34.cluster1.charter.net (8.12.11/8.12.11) with ESMTP id k1552oO4006114 for ; Sun, 5 Feb 2006 00:02:50 -0500 Received: from 24-197-119-161.dhcp.spbg.sc.charter.com (HELO toast.zoidtechnologies.com) ([24.197.119.161]) by mxip26a.cluster1.charter.net with ESMTP; 05 Feb 2006 00:02:50 -0500 X-IronPort-AV: i="4.02,89,1139202000"; d="scan'208"; a="747975501:sNHT49553088" Received: from dionysus.zoidtechnologies.com (dionysus.zoidtechnologies.com [192.168.2.9]) by toast.zoidtechnologies.com (Postfix) with ESMTP id 85B78207009; Sun, 5 Feb 2006 00:02:49 -0500 (EST) Subject: Re: PHP/postgreSQL From: Jeff MacDonald To: vince@weaktight.com Cc: pgsql-php@postgresql.org 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> Content-Type: text/plain Date: Sun, 05 Feb 2006 00:02:49 -0500 Message-Id: <1139115769.3296.236.camel@dionysus.zoidtechnologies.com> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/22 X-Sequence-Number: 3438 On Sat, 2006-02-04 at 23:24 -0500, vince@weaktight.com wrote: > Quoting Jeff MacDonald : > > 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/