How to sync Remote MySQL DB to SQLite on Android?
Jul13

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.

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?
Apr06

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 JSON Parsing Tutorial – Using AQuery
Feb08

Android JSON Parsing Tutorial – Using AQuery

I hope you folks understood how easy it is to develop Android application with AQuery library in handling image loading, making asynchronous call and lot more from my previous posts. If not take a look at the below posts and they are prerequisite to develop the Application which I am going to teach you in this post.

Introduction to AQuery ā€“ Android Query
AQuery Button Listener
AQuery AJAX Callback
AQuery Image Loading

It’s time to explore the other most wonderful feature of AQuery and that is ‘Asynchronous Network Calls’ to download JSON from remote server. In this post we will be developing simple application to demonstrate how to download JSON from Internet and render it over UI after parsing it. I already wrote a separate article – Android JSON Web Service Tutorial on how to make Asynchronous call to download JSON from Network using Android Dot Net Webservice combo.

Read More
Android JSON Web Service Tutorial
Sep14

Android JSON Web Service Tutorial

In this post we will be discussing on how to consume JSON response (returned on invoking web service) in Android applications. I took simple example to demonstrate the JSON Web service tutorial. The example which we are gonna create will have two spinner controls (called Dropdownlist in traditional desktop applications), one to display ‘Countries’ list and other to display ‘Cities’ list.

When user selects a country from the ‘Countries’ spinner control, cities belong to the selected country will be populated in the ‘Cities’ spinner control.

Read More

JSON Tutorial

Android Tutorials
We are happy to announce that we have launched tutorial on JSON – JavaScript Object Notation. Click through the below links to learn JSON – modern way of handling data transfer between heterogenous servers, web applications and mobile applications. Lot more tutorials are coming soon, keep watching the space for more updates.

Read More
x
Subscribe and stay in touch!!

Enter your email and stay on top of things:

Your email address will not be published