Import SQLite Database into Android using SQLite Browser

July 29, 2015 - PRLog -- To review the complete tutorial and download source code go to : http://androidgifts.com/import-sqlite-database-into-android-using-sqlite-browser/

How to Import SQLite Database into Android using SQLite Browser, Most all of the Android tutorials assume that you want to create and populate your database at runtime by Java coding but what if we need to access an independent, preloaded database with your Android application.

In our previous tutorial we talked about Android Design SQLite Database using Workbench (http://androidgifts.com/android-design-sqlite-database-using-workbench/) and generated SQLite file that we will use in this tutorial.

In this tutorial we are going to take the SQLite database file, import it into SQLite Browser (Download From Here) (http://sqlitebrowser.org/) to generate our database and insert some content into it so it will be preloaded, then we’ll copy this file into the assetsthen we would access it via Java code to deal with it as a normal database.

What is SQLite Browser ?
DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

It is for users and developers needing to create databases, search, and edit data. It uses a familiar interface, so you don’t need to learn complicated SQL commands.

Database Overview:
Our database contains 3 tables, Employee which has some attributes like: Name, Age, Mail, Phone and the other for Department which has attributes like: Title.

The Employee table has multi-valued attribute which is Phone, so we create a table calledEmployeePhone and link between by putting a reference for EmployeeID in EmployePhone table.