News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Sameer Borate:
Efficiently Replicating RETS data to MySQL
May 03, 2013 @ 10:26:33

Sameer Borate has a new post to his site that shares how he converted a RETS database to MySQL with the help of a PHP library, PHPRETS.

A recent project of mine entailed replicating a RETS database on a local MySQL database server. The client had a new real-estate mobile search app in development and wanted to have a local copy of the RETS database for search queries instead of a remote RETS server. [...] Replicating RETS data rather than using the live version is slightly complex, however. In order to replicate the RETS data into your own local database, a series of processes are needed in order to make sure the data you have is both updated and in sync with the server.

He breaks it down into three main steps with some sample code for each:

  • Grabbing the complete database once
  • Keeping the data in sync
  • Ensuring the cron job is executed on regular intervals
0 comments voice your opinion now!
rets database replication mysql phprets library tutorial

Link: http://www.codediesel.com/data/efficiently-replicating-rets-data-to-mysql

blog comments powered by Disqus

Similar Posts

Francois Zaninotto's Blog: Validating a YAML file against a schema in PHP

IBM developerWorks: Paint 3-D images with PHP

Stefan Mischook's Blog: Turning on display_errors in WAMP - Video Tutorial

Brian Swan's Blog: Consuming SQL Azure Data with the OData SDK for PHP

IBM developerWorks: Cook up Web sites fast w/CakePHP, Part 1: Adding related information & services


Community Events





Don't see your event here?
Let us know!


threedevsandamaybe testing refactor api laravel release framework community series code list opinion symfony2 language podcast unittest interview developer introduction install

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework