Finishing the Database - Android Room Database With Multiple Tables

In this video we will create the database class and access our database in our app.
⭐ Get certificates for your future job
⭐ Save countless hours of time
⭐ 100% money back guarantee for 30 days
⭐ Become a professional Android developer now:
pl-coding.com/...
🎓 Become an industry-ready developer in the Mobile Dev Campus:
pl-coding.com/...
🎁 Get my FREE 4.5h course "The Best Practice Guide to Android Architecture":
pl-coding.com/...
Read our weekly Android blog:
pl-coding.com/...
Get the source code for this video here:
github.com/phi...
Regular Android tutorials on my Instagram: / _philipplackner_
Checkout my GitHub: github.com/phi...

[@carlosalba9690]

Love the Director and Student names. A true man of class an enjoyer of the arts one who pays attention to all the small details.

[@markdee2153]

Honestly, I dont know how one can code without watching these videos, it's my go to reference for all Kotlin related stuff. Man you are nearly as good as ChatGPT. Good job!

[@rahulraj94391]

by reading documentation carefully.

[@mateuszkowalski7855]

Hi Philip, love the videos. Nobody else in the comments has mentioned anything about the Director's names. Just thought I'd throw a mention to the fact that they made me chuckle audibly. Keep it up!

[@wagnerarcieri]

Mike Litoris was an awesome choice of name ! congrats ! made my day

[@vathsan3906]

I didn't knew dat of database before this playlist.. Now learnt a lot.. You are simply awesome...

[@thomaswaldorf2829]

Well after living with Firestore for a few years, I may need to re watch this series a few times... :)

[@hacheguioneme]

"Donny Jepp, Hom Tanks, Mark Suckerberg" HAHAHAHAHA thanks a lot! this video was very helpful.

[@wagnerarcieri]

Director Mike Litoris

[@chuka_obi5167]

This was an awesome series Phillip! I learnt so much from watching it. Thank you

[@alextroy605]

This your playlist - are AMAZING, thanky you so much, Philipp Lackner!

[@АннаПомыткина-и8ш]

Awesome course on Room! Everything is clear, massive thank you!

[@niazsagor]

Awesome content Phillip, really helpful.

[@AdWit]

Great set of videos Philip. Really useful. Keep doing great job! Wish you all best.

[@prasannakumaranisetti2350]

Thanks Philipp, this series helped me a lot.

[@CodeWithNiks101]

Amazing explaination, just went through the complete playlist.

[@arunkumarka1809]

Thanks Philip for this wonderful tutorial.....

[@jorghaumann6841]

An realy awesome tutorial, I'm you newest Fan. Just right to the point!

[@fakhrymubarak8957]

it helps me a lot on my internship, thank you very much

[@acaradovanovic3923]

Very good video bro best explanation on YT. U can store data in local Json and then insert it in datebase and in same time show people how to use local Json.

[@brandednomad3075]

Great tutorial. Keep them coming.

[@areuin2it]

Great series

[@jonathanfelix445]

Very well structured(3 relation types) series !!!

[@nikiheaney5099]

Thanks, dude, this helped ALOT.. got yourself a new subscriber. cheers

[@mustafaammar551]

what an awesome tutorial Thank you bro Wish you all the best👍👍👍❤❤❤

[@PhilippLackner]

You're welcome!

[@fredzouza]

Congratulations, this series helps a lot but i got one question, if i need to create a maintenance screen to any entity i need to replicate the Database class to each entity ?

[@GriNAME]

Another thanks, Philipp!

[@albertocastro5496]

This was a great series thank you

[@haykmkrtchyan7093]

This was amazing Phillipp, thanks a lot))

[@Ayor88]

nice videos, I wish you also show how to delete stuff, especially with the N to M relation

[@sohaibkhan845]

Very well explained.

[@fahidsarker4858]

This playlist was amazing. Thanks a lot. It really helped me.

[@PhilippLackner]

You're very welcome!

[@souparnodey7382]

it was very amazing series.

[@rishikeshsingh9946]

Amazing!

[@moriz8549]

Thanks dear Philipp, that was great tutorial. I found a logical bug which is in 'getSchoolWithStudents' Query function in Dao Interface. the query must be: "SELECT * FROM student WHERE schoolName = :schoolName"

[@pepiyoutube1342]

I think you don't need list as return type for getSubjectsOfStudent and getStudentsOfSubject here there will be always only 1 element in the list.

[@techbrainz]

Superb 💓💓💓💓💓

[@RaulSC9]

What is the reason for returning a list of "StudentWithSubjects"? If in any case it will not return more than one object of this type. Best regards and thanks for the videos

[@FckYouPlz]

I don't understand why do we need the crossRef table if we need to manually manage to enter values into it like you did in the MainActivity where you created a crossRef instance and added it to the DB. This means that for a big complex production app I will need to know each and every cross references tables that each table has before entering values into it and make sure I add each and every one of them manually and correctly otherwise I will cause massive errors. Did I get it right?

[@rahulnirmesh3388]

Awesome point mate :) Any thoughts Philipp??

[@snansahmarov1524]

Thank you Philipp

[@hichemhammadache8798]

Thank you philipp

[@soontaek]

Thank you as always 🙂

[@tonyblack1981]

Brilliant tutorial but if I decide to use autogenerated primary key how do I insert that as a foreign key into another entity

[@andrer2664]

I had the same Question

[@andrer2664]

If you define return type in Dao. You get the inserted id from insert function.

[@reeceyamato]

Great sets of videos as always I'm a beginner and I have learned so much from your tutorials Thank you! I have one question, if I want to create an app with 3 different data let's said:a note app one activity will be costumers, the other activity will be employees and the last activity will be notes, but I don't want the data to have relation, just want to have my data independent in every activity, in this scenario I know that I need to create 3 entitys, but; do I need to create 3 Databases and 3 interfaces? Or can be done with only one interface and one database? I hope that you understand what I mean, English is not primary language, Thank you in advance for your help!

[@dreamer6228751]

It's cool bro!

[@AryanvedhFromIndia]

great video, thanks, you did add entries here yourself, but what would have been the code if there was a prepopulated database.db

[@yutech2091]

It helped so much

[@rubinho388]

Mike Litoris killed me XD

[@djtrzeszczyk]

Thanks for this viedo:)

[@mauriciopriego1700]

merci

[@YouGuto]

Love It 😘

[@pavlo_kulinenko]

Cool video

[@paulvickers8059]

I would be great if you could show a real app with this kind of stuff. You only get the basic crud todo apps. A more complex app teaching this kind of stuff would be invaluable.

[@techbrainz]

Please make a video to delete data with data linked in multiple tables

[@amineayachi335]

Great playlist thanks , is room better than realm ?

[@PhilippLackner]

Yes it is

[@vathsan3906]

lmao .. I laughed hard at the entities you created at the last...

[@shs4293]

Where's the model view and view for this??

[@fahidsarker4858]

Can you make another tutorial showing how to include a .db file with preloaded data by using room?

[@alij3fer]

Thanks bro

[@arpitgupta3151]

I'm getting error on using lifecycleScope. It's not available

[@KotlinBek]

I tried to make many to many relationship but it didn't work. and you also didn't show the result. all you have to do write LOG.

[@hamedhardani8302]

What if I want to get all the students and know what is the name of each student's School? I mean each Student goes to a specific (1) School, And each School has many (N) students. So what should the query be like if I want to get a List of Students that contains the School name too? I want to show all the Student names AND their School name in a RecyclerView item.

[@zoltansolutions]

What if my primary keys are integers and I would like to insert and query from multiple tables? I have sofar three entity: Products/prodId, Name, etc/ Account/ accId, accName, etc/ Expenses/itemId, prodId, accId, price, etc/. As I understood my relation is 1 to n, but I can not find a solution for that. Thank you Philipp!

[@solomonfried9353]

did you figure this out? I want to do the same thing.

[@MDDanishAnsariDev]

Can someone tell me with the procedure of taking admission in Jake Wharton school?

[@Traffic_Pro]

beff jezos😁

[@brunopistolero2265]

Ja awesome Philipp aber what about a german Tutorial? - da gibts viel zu wenige von

[@PhilippLackner]

Haha ja, international hat Reichweiten technisch halt einfach das viel größere Potential, im deutschen ist mir die nische zu klein

[@vikramragunathan6392]

Names ROFL 😄😄

[@blattwald7650]

tired of CTRL+C, CTRL+P, use CTRL+D,

[@akashdeepwadhwa5828]

usualy ALT+F4 is sufficent

[@pierremarais7669]

Philipp, thanks for this, I am new to Android, this will help me with my new App, I do follow you also on Instagram, I have a question, will you be so great to assist me, thanks

[@vivekdevre4402]

why am i getting this error: Not sure how to convert a Cursor to this method's return type (java.lang.Object). public abstract java.lang.Object getSchoolAndDirectorWithSchoolName(@org.jetbrains.annotations.NotNull()