Android Basic SQLite Database

profgustin · 36K views · 2012 · 10:06

Open on YouTube

Software (other)Databases & storagetutorialdated

Why Stack Overflow recommends it

Stack Overflow users link it as a starter tutorial when askers need to understand how to create and use a local SQLite database in an Android app.

Recommended by 1 people across 1 different months, 2012 to 2014.

What it is

A roughly ten-minute 2012 screencast giving a brief overview of creating a SQLite database on Android and saving data to it. It is a basic tutorial from the channel profgustin aimed at beginners to Android data storage.

What people said

Recommends Ramakishna Balla · 2014-01 · Stack Overflow · on “How to create SQLiteDatabase and use it to populate spinner?”

Follow this on Youtube to get a basic better understanding : [this video] and also other available tutorials at Youtube. Along with it, you can watch out - [LINK] as well. I've used SQLiteDatabase in one of my requirements as part of the tutorials. It has creation of the table, inserting as well as upgrade methods for your reference. I believe it will help you StatusData.Java import winterwell.jtwitter.Status; import android.content.ContentValues; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; @SuppressWarnings("unused") public clas

Cites solitario · 2012-08 · Stack Overflow · on “android openOrCreateDatabase only works in emulator”

I've noticed that openOrCreateDatabase only works in the emulator and not on the phone, when I right-click the project and "Run as Android application." I've checked the DDMS and the database is successfully created through the emulator but not an actual device. When testing on the phone, I get no error message at all. And yes, I do know about the database helper class, which I've also tried, again with no error message. So I'm wondering, is there a permissions issue in place? Some sort of configuration that needs to be set so as to create a SQLite database while testing on the phone? Any help is appreciated. Thanks. P.S. I was following along with this tutorial: [this video] Edited to add the co

Cites Miha GaPiha · 2013-08 · Stack Overflow · on “Android app that uses network for data retrieving/ data sending”

Yes if you want to get data from "external" source you will need to get it from a server, web page,... You also have other options if you want to have that database on your device you can use a SQLite method. [this video]