lundi 2 novembre 2015

SQLite with lots of tables

I'm doing an application with database.
In this database I will have 3 tables with +30 columns.

I don't want to lose so much memory on variables, and I want to have my application easy to update.

Shall I create this in a normal way which I saw in websites, or some another way?

The normal way to create a table as seen in many web sites:

private static final String USER_ID = "user_id";
private static final String USER_EMAIL = "user_email";
private static final String USER_KEY = "user_key";

private static final String CREATE_USER_TABLE = "CREATE TABLE " + USER_TABLE
        + "(" + USER_ID + "INTEGER PRIMARY KEY, "
        + USER_EMAIL + " TEXT, "
        + USER_KEY + " TEXT);";
}

Aucun commentaire:

Enregistrer un commentaire