SQLite Database Tutorial Android Studio | Note List View App with Persistent Data

How to build a simple note taking app with persistent data using SQLite Database, Java and Android Studio. In this beginner friendly tutorial learn how to create an SQLite open helper java class to save, edit and delete persistent data. An excellent beginner Android App idea to follow along with to further your understanding of how to use list views and SQL Databases.

SQLite Tutorial Source Code:

⏱️ TIMESTAMPS ⏱️
00:00 - Intro
00:53 - Note App XML
04:40 - List View Java
07:58 - SQLite Helper
13:36 - Save Data
14:25 - Edit Data
16:39 - Delete Data

#AndroidNoteApp #SQLiteAndroidStudio #AppDevelopment

[captainbucket]

Probably one of the best Android tutorials out there, great job!

[loup]

thanks for the good video But no matter how I look at it, I don't know how to link to the basic weekly list data storage. Can you give me some tips?

[ahmedamer]

hi Cal, thanks a lot for this amazing tutorial, I assuming i have the same app and i want to implement a button to share a note or some notes the user select to share them to an other device that has the app installed what is the best way to do that ? ... in short I am trying to share parts of the sqlite database how to do that ? waiting for your kind response and thanks in advance <3

[sleep-zzz]

How can i add api json data to sqlite database and how update, edit and delete it?

[GoodGuyOlo]

Hi, first of all, great tutorial, but I do have some problems. At 7:42 when You start the app, and add notes, in Your case, after adding new notes, they show up after You click SAVE button. In my case, nothing shows up and I cant get it to work. I've tried and tried and probably redone whole project like 20 times and I still cant get my list to show up. Any ideas?
Best regards

[PhilosephersStone]

Hey, I have an issue. I set a custom path for my Database, but when I uninstall and reinstall the app, it says I can't open the database (which has not been deleted). So if anyone has an answer DX

[kingjiealdwinlee]

great tutorial i hope you could make a tutorial where you use firebase to do the same thing as the video

[janettaylor]

Hi Cal, great tutorial. Would you be able to advise how to create a dialog of Yes / No before the delete? Also, to add a filter search for the notes. Thanks

[chigoziehenryike]

I love your videos Man keep making more videos, Please make a login and registration video and a simple booking app..

[aanshi]

Hey ! Can you make an application that uses both Android and dbms . A small company app that contains details of employees and company

[gametech]

how to add one more option in listview?

[rodrigoleitefonseca]

Good night friend. Do know how can i copy a database SQLITE from the assets directory to a APK? In kotlin.

[abdessamedben]

thanks so much. I have checked Playback speed, it is still Normal

[prismalakai]

My Application say this "process system isnt reponding" and "myapp" keeps stopping can someone help me?. ;)

[Daily_SketchBook]

hi cal can u please tell me how I can add an image and get the date and time when the note is taken

[glaubenskraft]

Hey cal first of all ty for the vid. I'm having a problem with SQLite which is this quote on SQLiteManager.java: try (Cursor result = * from " + TABLE_NAME, null)) Can you help?

[maryannadelman]

Would you happen to have a version of this same tutorial for Kotlin?

[techtrash]

please make more tutorials on android with java

[finvest]

Please help. I have created a database which containing name of a product and quantity of the product, again user enter the same product name but quantity in negative or it could be in positive, now I Want to update the product and it's available quantity by performing the calculation, if user entered quantity in positive than old quantity + this new quantity, same for subtraction. How do I do this please help, make a video on this.

[RoseColoredMew]

I’m having issues deleting an item.. I select the button and it sends me back to the list view with the items still there. Any advice cal?