Syncing the Desktop and Mobile Database?

Asked

Viewed 145 times

0

Well I will start working on a LARGE project, which will be MULTIPLATFORM, both for Desktop and Mobile, and we are discussing a way, to work with the DATA BASE in both applications. The interactions would be more or less like FACEBOOK.

  1. Every BD UPDATE via Desktop, must be notified on Mobile & Tablet. Just like when a FACE friend shares something and you are notified.
  2. A chat always synchronized on both platforms.

Would you like to know how to do that? We were discussing building our application in PHP and Postgresql, what do you think? While you’re at it, where do you recommend hosting this app? Were you thinking about Digital Ocean? Remembering that the Desktop application refers to a SITE.

php database postgresql mobile

  • Version mobile is also a website, but accessed by mobile browser, tablet and similar, which may have the same desktop presentation or a reduced form. In the case you refer to the creation of an APP?

  • 1

    Yes! Sorry I may not have been very clear. I refer to an APP!!

  • Unless it is something internal, try to keep as little information as possible on the mobile device, such as important and privileged information, etc... Only what is necessary so that it does not consume excess bandwidth. Use services like Rest, Soap and others. Otherwise, you will need to tailor the modeling of your database to meet the needs of a bi-directional database, such as field and table control.

1 answer

1


You should do it this way:

Stores everything in the bank postgres and access the information via JSON on mobile device. Then, when you did an update in the bank, you would warn via JSON itself by issuing a notification.

For chat, you always use the get and POST method to receive and send the data.

But, if you want the user to view the information offline, you should create a sqlite database on mobile and save the information on it.

About Digital Ocean, I have a server with them and fully recommend.

Browser other questions tagged php database postgresql mobile

You are not signed in. Login or sign up in order to post.