addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

RE: [php-46] Online/Offline Web App

From: user 1.
Sent on: Tuesday, October 26, 2010 12:16 PM

No problems Colin, happy to help.

 

Yes it would, so if you do not want this to happen, the scenario you have suggested might be better served by replication depending on the database and its ability to update across servers. Are you talking about having a local server at a place of business or single/multiple devices, then an online database server? The online server will always be ‘On’ unless you are controlling it via managed services/vhost.

 

To structure the database, depends what you mean by ‘structure’? I suggested xml-rpc for the synchronisation part as you had mentioned applications. My best advice, don’t try to over think it too much. Start with the database problem on its own, i.e. how am I going to get this thing to talk to the online database when it has a connection and which one do I want to be the master while all others would be considered clones/slaves. The structure, whatever it is, would really need to be consistent between database instances.

 

Noel

 

 

From: [address removed] [mailto:[address removed]] On Behalf Of Colin Burns
Sent: Tuesday, 26 October[masked]:33 AM
To: [address removed]
Subject: Re: [php-46] Online/Offline Web App

 

Hi Noel,

 

Thanks for the reply. Correct me if I am wrong, but won't this still require that my app in online to connect back to the original server to get and put information?

 

I am looking for information about how to structure the database so that it can run in offline mode (through local storage using HTML5) and then synchronising it back to the online database when an internet connection is available.

 

Thanks for your response.

 

Regards,

Colin


Colin Burns
Phone: [masked]
Fax: [masked]
Email: [address removed]
Web: http://www.ourtravellifestyle.com
Location: Penang, Malaysia
GMT: +8hours

On Tue, Oct 26, 2010 at 8:10 AM, Noel Dixon <[address removed]> wrote:

Hi Colin,

 

As a first point of call, I don’t know your level of dev skill, but try http://www.xmlrpc.com/

 

Kind Regards,

Noel M Dixon

E             [address removed]

M            [masked]

W           www.noxidsoft.com

cid:image001.jpg@01CAF127.E6D02660 

T           http://twitter.com/noxidsoft

F           http://www.facebook.com/people/@/100001649615988

L           http://au.linkedin.com/pub/noel-dixon/a/732/42a

S           http://www.myspace.com/550554119

R           http://screenr.com/user/noxidsoft

 

Get competitive Australian hosting at: http://noxidsoft.secureapi.com.au

 

 

From: [address removed] [mailto:[address removed]] On Behalf Of Colin Burns
Sent: Monday, 25 October[masked]:46 AM
To: [address removed]
Subject: [php-46] Online/Offline Web App

 

Hi All,

 

Sorry if you receive this twice I am sending it to the Web Design and the PHP/MySQL groups.

 

I have been looking into building an online/offline app and I was wondering if anyone had any suggested articles I could read to better understand how I should structure the database to allow for synchronisation of data entered when in an offline mode etc.

 

I am sure this is something that many people have had to overcome in the past so I thought I would ask for some assistance before I plough ahead with so ill conceived idea of how to do it :)

 

Thanks in advance.

 

Colin

 

Colin Burns
Phone: [masked]
Fax: [masked]
Email: [address removed]
Web: http://www.ourtravellifestyle.com
Colin Burns
Phone: [masked]
Fax: [masked]
Email: [address removed]
Web: http://www.ourtravellifestyle.com
Location: Penang, Malaysia
GMT: +8hours




--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Colin Burns ([address removed]) from The Brisbane PHP & MySQL User Group.
To learn more about Colin Burns, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here

Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]





--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])

This message was sent by Noel Dixon ([address removed]) from The Brisbane PHP & MySQL User Group.
To learn more about Noel Dixon, visit his/her member profile


To unsubscribe or to update your mailing list settings, click here

Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]

 





--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Colin Burns ([address removed]) from The Brisbane PHP & MySQL User Group.
To learn more about Colin Burns, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here

Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]

This email message originally included an attachment.

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy