SQLite + Android - Delete Table Data (Book Library App) | Part 5

🏆 My Online Courses
⭐Discount Coupon: LAUNCH-STEVDZA-SAN

🐱‍👤 Wanna become a member? Join!

📸 Instagram

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.

----------

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.

[muskanyadav]

I found these tutorial really helpful . Currently learning android so yeah ..thanks for such great explanation 😁

[HyperActive]

in 00:08:15 you said inside our "Update Activity" but you wrote it on Main Activity

[Waleed_Al-Haidary]

very clean and clear explanations, can you add a function to upload the sqlite database to mysql database on online server, this is already a great toutorial.

[play_boy_]

thank you so much for this playlists ❤❤

[computertutorial]

great idea sir. thanks a lot u fix my problem 😇

[Edu_HUB]

clear explain and thank for this videos💯💯

[eel]

thank you so much for this play list❤❤

[cyburst]

My delete one row doesn't work it crashes

[jenniesloft]

I dont get how we gonna find empty icon in SVG form?

[pg-lv]

also, how do you delete specified data instead of all data. do we use SELECT and a cursor?

[pg-lv]

i love your videos man. You helping alot of people, keep it up. I have a request though, could you do a video for homepages. Like home page transition to functional requirements.

[jimbotron]

At 8:12 you said UpdateActivity instead of MainActivity! really confused me. But thank you

[SUMITPANDEY-fwyj]

Can you please make a video on searchview with recyclerview using sqlite database

[rogeriobezzerra]

Hello, Stezza-San.
My name is Rogério and I'm from Brazil.

I really enjoyed your video series about the "book library app", very good, congratulations.

Now, how can we present the sequential number instead of showing the book id in the listView? Because if we delete a book, will that order "break" (1, 2, 4, 6, 7, 10, etc.)?

[automarketarmenia]

The material is good. But very difficult to trace, you show one button click on other... You definetely knows subject, but as tutorial maker you should improve your presentation skills. Any way thank you for your work.