How to sync Remote MySQL DB to SQLite on Android?

In this post, I am going to explain how to sync data present in remote MySQL DB to Android SQLite database. The data present in the remote MySQL DB (or any Database) needs to be synced with SQLite DB in Android in order to maintain the data integrity.

If there is change in remote DB data, it can be synced with Android SQLite DB when User explicitly hits ‘Sync’ button or asynchronously by the application itself (in particular interval) when Internet connectivity is available.

Before we start developing the application, quickly take a look at the prerequisites below.

Prerequisite:

You must have knowledge of SQLite before you start creating the application. Have a glance at the below articles which will make you understand much about SQLite

What is SQLite?

Android SQLite CRUD example

Read More

How to sync SQLite on Android to MySQL DB?

In this post, I am going to explain how to sync data present in Android SQLite database to remote MySQL DB. In most of the Android applications, the data present in the local SQLite database will be synced with remote DB in order to perform statistical operations at the server end, maintain backup of the offline data etc.

In such cases, offline data will be synced with remote DB when User explicitly hits ‘Sync’ button or asynchronously by the application itself (in particular interval) when Internet connectivity is available.

Prerequisite:

You must have knowledge of SQLite before you start creating the application. Have a glance at the below articles which will make you understand much about SQLite

What is SQLite?

Android SQLite CRUD example

Read More

Android SQLite CRUD example

In this post, I will walk you through how to perform Create, Read, Update and Delete (CRUD) operations in SQLite DB embedded in Android devices.

Prerequisite:

You must know about SQLite before you start creating the application. Take a look at What is SQLite? post which will make you understand much about SQLite.

Here are the quick links:

Read More

What is SQLite?

In this post, we will discuss about SQLite – A Thin Relational Database.

SQLite is used in most of the applications which need less complicated relational database.

SQLite is embedded in every Android device and it provides phenomenal support to perform database operations in Android via in built Android APIs.

Here are the quick links:

Read More

Pin It on Pinterest