SQL Lite Database: Android Programming
Why Stack Overflow recommends it
Stack Overflow users link it as an easy-to-follow video alternative to written tutorials for getting started with SQLite on Android, and askers often cite it as the code they started from.
Recommended by 1 people across 1 different months, 2013 to 2015.
What it is
A 32-minute screen-recorded tutorial by Brian Fraser that walks through building an SQLite database for an Android app, including a database adapter class for inserting, querying and deleting rows. Full project code is available on GitHub.
What people said
Recommends Arshia · 2015-10 · Stack Overflow · on “What is good way to create android database”
Take a look at this video, usually videos help better than reading tutorials: [this video] And for your second question, you don't need to create different databases for different tables. A database can handle multiple tables.
Cites RapsFan1981 · 2013-05 · Stack Overflow · on “Can't add more than one record, ID not autoincrimenting”
I'm trying to add site details to a database and then after I insert a row, output the result to a TextView. The record is being inserted into the database because it's being shown in a TextView, however I can only insert one record and I'm not sure why. I'm been using the tutorial here [this video] and modifying it to meet my needs. Here is my DBAdapter: public class DBAdapter { // /////////////////////////////////////////////////////////////////// // Constants & Data // /////////////////////////////////////////////////////////////////// // For logging: private static final String TAG = "DBAdapter"; // DB Fields public static final String KEY_ROWID = "_id"; public static final int COL_ROWID = 0;
Cites Dexter Wong · 2014-12 · Stack Overflow · on “SQL Lite database inserting data to the beginning after deleting all data”
SQL Lite Database: Android Programming [this video] From the previous youtube video, I have learned about the basic SQL lite database. I want to ask that after we clear the data, then you add new data into the database but the id is not reset to the beginning. The data is just added to the next row according to the previous data which is not cleared. Could I just add to the beginning row after clear the data?Thanks!
Cites mcfred · 2015-04 · Stack Overflow · on “Create Android Quiz App”
I am new to android development. I just saw a tutorial on how to insert data in the db. Here's the link: Using SQLite [this video] However, I don't want to insert data every time my app starts. I want to insert it once and retrieve multiple times. Meaning, the data is not inserted via the app. Does someone know a tutorial on how to do that ?