Multi Language Database Design

I use to work on a multi language (English, Malay, Chinese) Android mobile app previously, which required to keep the value in database. There is no perfect solution to design a database to support this.

Interface + Gradle Build Variants

When I’m working on a regional mobile app recently, I start to notice an useful usage of interface when combine with Gradle Build Variants in Android Studio.

Firstly, I put an interface in the main project.

From Anonymous To User Database

For a standard mobile app that required database as a storage, the sample code normally look like this:

public class DatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "anonymous.db";
    private static final…