Drupal Module for DB Sync

  • Posted:
  • Proposals: 0
  • Remote
  • #33178
  • Archived
  • 0

Description

Experience Level: Intermediate
Hi Everyone,
I would like a quote for a drupal(v6) module which performs the following;-

Syncronise records between a database connected to the website and a database on a mobile device.

The concept is that the same data can be entered in the site or on the mobile device and then syncronised.
The online DB is MySql and the mobile one is SQLITE.
The online DB is separate from the Drupal site DB that is used to run Drupal.
The records to be sync'd are selected from each DB using a query that is created already.
One of the fields returned is a "last modified date / time" and the most recent record from either database
is the one to be kept.

I anticipate producing an XML file from the records and comparing them online (with PHP), then an update supplied to the
mobile system as XML or updates done to the online database.

The mobile end of this will be using HTTPS to connect and AJAX based calls to get / put data.

This spec is for the online (PHP Drupal) aspect only, but this site will be membership only and the mobile device will be required to send authentication. Also the interface to enter this data online is not part of this requirement.

Additionally, this module should record some stats / tracking on which users have updated and when (potentially storing the generated XML files ? is there any
future benefit in that for roll back? )

I can provide more details on request, but i would like a quote for creating this as a drupal module.
It would be to start in the next 3 weeks, the mobile app is done, but the intial website set up is still happening.

One feature of the site is that the membership is paid for and so I was thinking of using Ubercart with a subcription.
Any suggestions for that aspect are appreciated as a Drupal expert who could do more than just this module (in terms of setting up and customising)
would be considered so please give me some idea of what sort of costs that would involve (or what info you would need to be able to say).

This is remote work.
I am in London UK being and able to talk in the timezone would be handy.
Also i'm sorry not to specify the budget, i really am not sure how much this will cost, but I do have a realistic budget available and will consider all quotes where the costs and the time seem to be be sensible / justified.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.