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 15B089DC832 for ; Sun, 5 Feb 2006 01:50:06 -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 35413-06 for ; Sun, 5 Feb 2006 01:50:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hurricane.stormweb.net (hurricane.stormweb.net [65.39.129.23]) by postgresql.org (Postfix) with ESMTP id 978339DC831 for ; Sun, 5 Feb 2006 01:50:03 -0400 (AST) Received: (qmail 90301 invoked from network); 5 Feb 2006 00:50:03 -0500 Received: from localhost (127.0.0.1) by localhost with SMTP; 5 Feb 2006 00:50:03 -0500 Received: from S0106001310f09c28.vc.shawcable.net (S0106001310f09c28.vc.shawcable.net [24.85.82.132]) by webmail.weaktight.com (Horde MIME library) with HTTP for ; Sun, 05 Feb 2006 00:50:01 -0500 Message-ID: <20060205005001.rhbxys2b4ogkg0k8@webmail.weaktight.com> Date: Sun, 05 Feb 2006 00:50:01 -0500 From: vince@weaktight.com To: Jeff MacDonald Cc: pgsql-php@postgresql.org Subject: Re: PHP/postgreSQL 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> In-Reply-To: <1139115769.3296.236.camel@dionysus.zoidtechnologies.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0.3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.67 required=5 tests=[AWL=0.120, NO_REAL_NAME=0.55] X-Spam-Score: 0.67 X-Spam-Level: X-Archive-Number: 200602/23 X-Sequence-Number: 3439 Quoting Jeff MacDonald : >> 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/ I am still on a 30 day trial with their hosting, but I'm new to web development, so I'm slow to code up the things I want and wasn't sure what I needed going into this... I'm not quite sure what role SOAP would play in the desired system, but I'll look into it. Thanks for your help, Vince. Another technology to learn!