SQLite + Android - Create Database Schema (Book Library App) | Part 1

Подписаться 82 тыс.

Просмотров 366 тыс.

50% 1

🏆 My Online Courses
⭐Discount Coupon: LAUNCH-STEVDZA-SAN
stevdza-san.com
🐱‍👤 Wanna become a member? Join!
/ @stevdzasan
📸 Instagram
/ stevdza_san
With this video I'm going to start tutorial series for SQLite Database on Android. We are going to create a Book Library application. Our application will have all the necessary functionality which every app with database should have. That includes CRUD, or Create, Read, Update and Delete functions. Also I'm going to teach you how to add Recyclerview and display data from our SQLite database in it. We are going to add some animations as well.
Project Files: github.com/stevdza-san/SQLite...
Part 2 (Insert Data in Database Table) - • SQLite + Android - Ins...
Part 3 (Display Data in Recyclerview) - • SQLite + Android - Dis...
Part 4 (Update Table Data) - • SQLite + Android - Upd...
Part 5 (Delete Table Data) - • SQLite + Android - Del...
Part 6 (Animate Recyclerview) - • SQLite + Android - Ani...
One of the main principles of SQL databases is the schema: a formal declaration of how the database is organized. The schema is reflected in the SQL statements that you use to create your database. You may find it helpful to create a companion class, known as a contract class, which explicitly specifies the layout of your schema in a systematic and self-documenting way.
A contract class is a container for constants that define names for URIs, tables, and columns. The contract class allows you to use the same constants across all the other classes in the same package. This lets you change a column name in one place and have it propagate throughout your code.

Опубликовано:

19 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 107

@fajarfardiansyah1264 3 года назад

This Channel its amazing. Easy to understand step by step and the more importantly a short video but covered important thing.

@mirsadhadzic5076 Год назад

Svaka cast, tutorial je za 10! Preporucujem svima.

@zbienn Год назад

This guide litterally saved me on my university's android course!! I couldn't have done it without you!! much love from portugal

@khayra_Ommah 3 месяца назад

me too

@calebblaze9114 4 года назад

Just the vidoe i was looking for. thanks for this great tutorial 🔥

@dmytroazhdier2311 4 года назад

Its great! Thank u, and waiting for the next video :)

@lenerggonzalez8071 2 года назад

You are amazing, i found you yesterday and i love and i watch all your videos, you are the man of the movie, BEST

@veteranJUGGERNAUT1 Год назад

THANK YOU FOR THIS AMAZING TUTORIAL. REALLY HELPED ME AT MY INTERNSHIP, LOVE FROM NIGERIA.

@nowaysgaming 3 года назад

Amazing tutorial! 10/10 Nice Work.

@leolwin8976 3 года назад

Thanks for this tutorial. Really helpful for me.

@ashtonburgess8939 Год назад

Your an amazing Teacher 10/10 !!

@gabrielrodriguezgonzalez7791 3 года назад

Grate tutorial, thank you so much!

@kyokyo4237 8 месяцев назад

how do you setup your project at the start in order to get that?

@pratikdhargalkar4876 3 года назад

Thank You Very Much For Putting This Much Of Hardwork.

@DiptaSahaCSE 4 года назад

sir,can you make a video using multiple table communication like,how to use foreign key in SQLite.can you make an demo app where having all the concept about all sqlite features like foreign key,order by,join etc

@ZeeshanAcademy 2 года назад

excellent tutorial. very helpful thanks.

@elliotmiller3187 3 года назад

Thanks for Nice tutorial, keep most of your tutorials in Java, thank you. :D

@user-tu5bh8tv8q 3 года назад

Thank you i completed my university project with your help

@alibyh4295 2 года назад

may I ask What was it about?

@user-tu5bh8tv8q 2 года назад

@@alibyh4295 android application woman safety app

@alibyh4295 2 года назад

@@user-tu5bh8tv8q what’s that about? Sorry for asking but I’m looking for some ideas for my university project and I’m running out of time.

@Gandalf18404 Год назад

Greetings ! I have a question. Why do we need to drop table in onUpgrade method, than create the same table in onCreate method ?

@Effectivebasketball 3 года назад

Hello, first of all, thank you for your hard work. Second I am new to Android dev. and your tutorials helped me a lot. At this stage, I have to ask you regarding SQLite vs ROOT. Basically, I work on an app, and I have to implement local DB or save data locally. The question quite simple should I go and deal with SQLite or I rather just go straight to ROOT? without bothering with SQLite understanding and implementations. The reason I have to because I afraid if I do skip SQLite at some point I get in trouble. Would be enough to dedicate my time only for ROOT? Thank you.

@StevdzaSan 3 года назад

You probably mean ROOM*. I would advise you to switch to ROOM lib, because it is a lot easier to create and maintain a database.

@Effectivebasketball 3 года назад

@@StevdzaSan Thank you for the answer, yea you cough exception right away ROOM, not ROOT.

@Effectivebasketball 3 года назад

@@StevdzaSan Follow up question because your tutorials for ROOM revolve around Kotlin and, to be honest, my knowledge about Kotlin stops on the name, shell I try to follow it or I rather not... A long time ago in 2010-2012, I use to code in Java, and even after many years I recognize most of it - Kotlin on other hand makes not really clicking in my head. So I have a dilemma I know I forgot most of the Java and I heard that Kotlin should be better and easy for Android development, but is it worth to invest in it (it took me about a year to study Java back in days). Is it a good investment of time and effort to study Kotlin? for 42 years old? Could be done without messing up big time?

@StevdzaSan 3 года назад

@@Effectivebasketball Kotlin is very easy to learn and use, lots of benefits from it. It's never too late to learn new things my friend. You should give it a try and you'll not regret. Kotlin makes you 50% happier developer. 👍

@Effectivebasketball 3 года назад

@@StevdzaSan I will take Happy over anything :) Thank you.

@iffashafiqah8673 3 года назад

sir... u save my life...

@sebastianochoa716 2 года назад

Thanks, this tutorial has been very useful and helper

@StevdzaSan 2 года назад

Glad to hear that buddy 👍

@michaelmutekeri8770 4 года назад

Great video, except the speed. Though you got it covered with the source code. I have been struggling to get something that actually work on androidx, the other tutorials have the basics but will have extra work in changing and configuring the depreciated dependencies, making debugging difficult for beginners like us.

@StevdzaSan 4 года назад

There will be a new tutorial series about room library with Kotlin as well 👍

@sinoiumarzoda7857 3 года назад

Thank you for the good job!!!

@skanerkodowkreskowychqr3794 5 месяцев назад

Very good video. Perfect job

@cubedev4838 4 года назад

Amazing!! Amazing!!

@francesconicastro9923 3 года назад

Ottimo lavoro

@EricBalcon Год назад

Very nice, but how can we retrieve data from a sqlite local database stored in android studio ?

@raffyrey9604 3 года назад

Hi sir can i ask, how many data can i put there? Or is it infinite?

@divided_by_dia446 Год назад

does autoincrement change the id of entries, when an entry is deleted, that has successors (so all the successors get substracted in the id by 1?)

@FCL00 2 года назад

can you make tutorial on how we can save the data from sql lite database into pdf file format? thank you

@palustrecarlgabriel1477 3 года назад

THANK YOU SOOOOO MUCHH!!!

@paramex-px 2 года назад

Mantab bang...sangat bermanfaat

@krishnaacharya8800 3 года назад

Brother Can you please the next parts .. I am so eager when you upload bro..

@eondubz1416 3 года назад

tq sir good tutorial

@dasuneranda 3 года назад

Great bro..

@ahmad7a.4k28 3 года назад

thank you very very match from syria

@suryakarmakar894 3 года назад

sir you are best

@antoniofuller2331 2 месяца назад

Helped. . .a lot

@marija7434 Год назад

odličan :D

@insyaallahbermanfaat7847 2 года назад

great, thanks bro

@namanagarwal3831 3 года назад

Tutorials awesome but one thing is going wrong when I rotate phone from portate to landscape recycling view not showing any data how to fix it portate mode working fine 🙄

@xantaclaws Год назад

hey i need to know something ... the things i add should be reflected on whomever using the app using a common shared database .... is there any way i can implement that?

@peterkim5853 3 года назад

Would you please make a lecture to create sqlitedatabase in google drive and treat it with android app.

@quenchpit8621 2 года назад

you are awesome!!

@Foczka669 2 года назад

Hellp, my android studio did not add a dependencies when I add a RecycleView ? Could you tell me how to change this. Thank you.

@eyyosyber 2 года назад

Thank you for the tutorial Sir but may I know how to create multiple table in the database ?

@papermaker107 Год назад

I'm new to this as well, but couldn't you just call "CREATE TABLE" again to create another table? worth a try!

@Electrologia 8 месяцев назад

How did you add action bar? You skip this part!

@samiulbasir1212 3 года назад

How we can protect this own db from stolen. Anyone can get this database by unzipping from asset folder. Is there any way to encrypt or encode specific column which I made using sqlite db browser.

@xivxvi263 3 года назад

What if I want to edit an existing database in assets?

@user-ns6ee9lf4i 4 года назад

thank you

@alibyh4295 2 года назад

Which version are you using?

@alfian3570 3 года назад

how to add all data directly in sqlite ?

@gilmarcossantos3951 2 года назад

Muito obrigado!

@user-sc1sm3em9w 4 месяца назад

cool video)

@pandakaradi4959 3 года назад

How to add images also when creating a new book title ?

@yasmine6902 Год назад

Hi please if u did figure out how to do it can u send me the code or show me the tips

@sanatandharmademystified Год назад

When we delete upper rows, Id doesn't refresh. Can we fix it?

@ericfricke4512 3 года назад

🖐️ high five

@saaddarell9174 4 года назад

i like your video but if you don't mind can you tell me the configuration of your computer because it run fast i mean android studio

@StevdzaSan 4 года назад

Install Android Studio on fast and quality SSD. Have at least 6GB RAM.

@windowtothemind8534 2 года назад

Hello, sir! Thank you so much for this amazing tutorial. i can not thank you enough for this. This has really been a great help for beginners like myself. You are a master of what you do, sir! i have a question, sir: can we use this source code to create apps with the same principle and sell it to clients? in other words, is it okat to use your source code to create apps and sell them? Thank you once again for being so generous and so knowledgable!

@StevdzaSan 2 года назад

Thank you my friend 👍 Yes of course, that's why I release my source codes as open source on Github. 👌

@windowtothemind8534 2 года назад

@@StevdzaSan Thank you a million, sir. this is marvellous. i can't even thank you enough. i will check your paid courses and buy some for myself. Thank you

@isuruthiwanka9448 3 года назад

hey broh..there is a wrong with the video..I cannot play in higher resolutions..

@omereyuboglu1114 Год назад

I understand you, although not very much. I wish you could tell me in Turkish. It's great to write with you

@pltsm3970 2 года назад

Hello Everyone! I need to SUM all page of available books and show in a textview in MainActivity, Book 1( pages 110) Book 2( pages 120) Book 3( pages 100) Textview (pages 330) anyone help me please. Thanks in advance.

@reeceyamato 2 года назад

Although it's a good tutorial to learn how to understand SQlite it's pointless, since the way this project is set, won't allow you to use search view in the recycler view, what is the point to have a recycler view, if you can apply Search View option?

@leosmithune1117 3 года назад

But I don't understand how did you create the database

@xivxvi263 3 года назад

Me too

@amirhosainarabzade5990 Год назад

👌🙏

@aimanaqari687 4 года назад

Can u make a tutorial using kotlin programming language please

@StevdzaSan 4 года назад

I will, my newest tutorials are already made using Kotlin.

@aimanaqari687 4 года назад

@@StevdzaSan I will be waiting for it keep going 😀🔥🔥

@sleepycatzzz6790 11 месяцев назад

mine didnt work w add activity thing :(

@sleepycatzzz6790 11 месяцев назад

somthing w context and intent

@emanuelhosseini7623 2 года назад

Hello,Sir! it was a really nice & usefull tutorial. I have just a question please. To display the data on first page(MainActivity), i have to close the app and open it again, after it i'm able to see the data. I actully tryed to call the storeDataArrays in onResume method, however it doesn't work. thanks in advance!