Android sqlite database - where do i start as the tutorial has gone for notepad?

Question

Ive tried to hunt down the tutorial for notepad on android developers but it appears to of gone offline with the recent change.

What i need is a database thats created by the user using 3-4 edittext boxes and 2 date boxes and to store as 1 file i can look back on..

but i have no idea where to start with databases..

ive read tutorials on how to make one but i cant work out what needs to change on the coding of the database for my needs,

i created one that generates a random word i set out of 5 words when i click an add button but that doesnt tell me what i need to do in order to get the information from my text input boxes and date pickers and display them in a listview..

Any help on this will be great.

ps. not looking for people to do it for me im looking to learn about databases.

Just in case you haven't noticed, [the tutorial is back](http://developer.android.com/training/notepad/index.html) — Chilledrat, Jul 06 '12 at 20:07
a good sqlite android tutorial to start http://www.quicktips.in/basic-android-sqlite-database-exampletutorial/ — Deepak Swami, Aug 25 '15 at 03:41
you can get detailed and clear explanation regarding how to create a sqlite database here http://androidcoding.in/2016/03/22/android-sqlite-tutorial-on-inserting-deleting-values-into-database/ — pabhishek, Mar 27 '16 at 05:25

score 6 · Accepted Answer · answered Jun 27 '12 at 15:50

6

This is a good point to start: http://www.vogella.com/articles/AndroidSQLite/article.html

answered Jun 27 '12 at 15:50

Stefano Ortisi

5,288
3
33
41

1

+1, sneaking in there with the same link while I was typing – Barak Jun 27 '12 at 15:52
this is the one ive done.. i will read through this info as it was on a different site and only covered the sample on that page.. Thanks alot, very much appreciated – jamie Jun 27 '12 at 15:55
@Stefano "Use the latest version of Android 4.0. This is currently API Level 15. Otherwise I would have to introduce the Loader class, which should be used as of Android 3.0 for managing a database Cursor. And this class introduces additional complexity." Doesn't this mean it can't be used when targeting, for example, a minimum API level of 11? – ElFik Jul 30 '14 at 16:18
I will not vote it down .. just the tutorial is not done properly. using android sample would be better.. or see :http://developer.android.com/training/basics/data-storage/databases.html – Maher Abuthraa Oct 07 '15 at 15:40

score 2 · Answer 2 · answered Jun 27 '12 at 15:51

2

I hate to answer with just a link, but that's pretty much what is required (I'm not going to post a whole tutorial as an answer :p).

A good tutorial on databases is here

answered Jun 27 '12 at 15:51

Barak

16,318
9
52
84

thanks guys. Shame the tut for the notepads gone.. i have the sample and run it on my device but no idea what im looking at lol.. thankyou – jamie Jun 27 '12 at 15:54

score 2 · Answer 3 · answered May 25 '13 at 21:04

2

Came across this in my own search. Not sure if you're still interested but if anybody else comes across, it can help them out. as of May, 2013, this is still active: http://developer.android.com/training/notepad/index.html

answered May 25 '13 at 21:04

Psest328

6,575
11
55
90

Android sqlite database - where do i start as the tutorial has gone for notepad?

3 Answers3

Linked