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

Sdílet
Vložit
  • čas přidán 7. 09. 2024

Komentáře • 114

  • @zbien
    @zbien Před rokem +21

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

  • @fajarfardiansyah1264
    @fajarfardiansyah1264 Před 3 lety +2

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

  • @veteranJUGGERNAUT1
    @veteranJUGGERNAUT1 Před 2 lety +1

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

  • @lenerggonzalez8071
    @lenerggonzalez8071 Před 2 lety

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

  • @user-tu5bh8tv8q
    @user-tu5bh8tv8q Před 3 lety +1

    Thank you i completed my university project with your help

    • @alibyh4295
      @alibyh4295 Před 2 lety

      may I ask What was it about?

    • @user-tu5bh8tv8q
      @user-tu5bh8tv8q Před 2 lety

      @@alibyh4295 android application woman safety app

    • @alibyh4295
      @alibyh4295 Před 2 lety

      @@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.

  • @calebblaze9114
    @calebblaze9114 Před 4 lety +3

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

  • @mirsadhadzic5076
    @mirsadhadzic5076 Před 2 lety

    Svaka cast, tutorial je za 10! Preporucujem svima.

  • @dmytroazhdier2311
    @dmytroazhdier2311 Před 4 lety +3

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

  • @kyokyo4237
    @kyokyo4237 Před rokem +2

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

  • @DiptaSahaCSE
    @DiptaSahaCSE Před 4 lety +2

    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

  • @Gandalf18404
    @Gandalf18404 Před rokem +1

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

  • @EricBalcon
    @EricBalcon Před rokem +1

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

  • @pratikdhargalkar4876
    @pratikdhargalkar4876 Před 4 lety +3

    Thank You Very Much For Putting This Much Of Hardwork.

  • @ashtonburgess8939
    @ashtonburgess8939 Před rokem +1

    Your an amazing Teacher 10/10 !!

  • @apiuagou9601
    @apiuagou9601 Před 3 měsíci

    Very clear explanation thankyou

  • @leolwin8976
    @leolwin8976 Před 3 lety +1

    Thanks for this tutorial.
    Really helpful for me.

  • @user-gj2fg7dn6j
    @user-gj2fg7dn6j Před 3 měsíci

    tnx Stev but How we can export Sqlite db to Excel file and Imported !!

  • @namanagarwal3831
    @namanagarwal3831 Před 3 lety

    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 🙄

  • @peterkim5853
    @peterkim5853 Před 3 lety

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

  • @divided_by_dia446
    @divided_by_dia446 Před rokem

    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?)

  • @Foczka669
    @Foczka669 Před 2 lety

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

  • @michaelmutekeri8770
    @michaelmutekeri8770 Před 4 lety +2

    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
      @StevdzaSan  Před 4 lety +2

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

  • @xantaclaws
    @xantaclaws Před rokem

    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?

  • @sebastianochoa716
    @sebastianochoa716 Před 2 lety

    Thanks, this tutorial has been very useful and helper

  • @iffashafiqah8673
    @iffashafiqah8673 Před 3 lety

    sir... u save my life...

  • @pandakaradi4959
    @pandakaradi4959 Před 4 lety +3

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

    • @yasmine6902
      @yasmine6902 Před rokem

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

  • @gabrielrodriguezgonzalez7791

    Grate tutorial, thank you so much!

  • @elliotmiller3187
    @elliotmiller3187 Před 4 lety +3

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

  • @KIRUZE
    @KIRUZE Před 2 měsíci

    What version android studio you use in this video?

  • @ZeeshanAcademy
    @ZeeshanAcademy Před 2 lety

    excellent tutorial. very helpful thanks.

  • @nowaysgaming
    @nowaysgaming Před 4 lety

    Amazing tutorial! 10/10
    Nice Work.

  • @paramex-px
    @paramex-px Před 2 lety

    Mantab bang...sangat bermanfaat

  • @eyyosyber
    @eyyosyber Před 2 lety +1

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

    • @papermaker107
      @papermaker107 Před 2 lety

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

  • @skanerkodowkreskowychqr3794
    @skanerkodowkreskowychqr3794 Před 8 měsíci

    Very good video. Perfect job

  • @samiulbasir1212
    @samiulbasir1212 Před 4 lety

    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.

  • @FCL00
    @FCL00 Před 2 lety

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

  • @omereyuboglu1114
    @omereyuboglu1114 Před rokem

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

  • @Effectivebasketball
    @Effectivebasketball Před 3 lety +5

    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
      @StevdzaSan  Před 3 lety +1

      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
      @Effectivebasketball Před 3 lety +1

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

    • @Effectivebasketball
      @Effectivebasketball Před 3 lety

      @@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
      @StevdzaSan  Před 3 lety +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
      @Effectivebasketball Před 3 lety +1

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

  • @sanatandharmademystified

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

  • @krishnaacharya8800
    @krishnaacharya8800 Před 3 lety

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

  • @alfian3570
    @alfian3570 Před 3 lety +1

    how to add all data directly in sqlite ?

  • @ahmad7a.4k28
    @ahmad7a.4k28 Před 4 lety

    thank you very very match from syria

  • @isuruthiwanka9448
    @isuruthiwanka9448 Před 3 lety

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

  • @suryakarmakar894
    @suryakarmakar894 Před 4 lety

    sir you are best

  • @raffyrey9604
    @raffyrey9604 Před 3 lety +1

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

  • @Electrologia
    @Electrologia Před rokem

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

  • @antoniofuller2331
    @antoniofuller2331 Před 6 měsíci

    Helped. . .a lot

  • @pltsm3970
    @pltsm3970 Před 3 lety

    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.

  • @insyaallahbermanfaat7847

    great, thanks bro

  • @eondubz1416
    @eondubz1416 Před 4 lety

    tq sir good tutorial

  • @francesconicastro9923
    @francesconicastro9923 Před 4 lety

    Ottimo lavoro

  • @dasuneranda
    @dasuneranda Před 4 lety

    Great bro..

  • @reeceyamato
    @reeceyamato Před 2 lety

    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?

  • @sinoiumarzoda7857
    @sinoiumarzoda7857 Před 3 lety

    Thank you for the good job!!!

  • @marija7434
    @marija7434 Před rokem

    odličan :D

  • @user-sc1sm3em9w
    @user-sc1sm3em9w Před 8 měsíci

    cool video)

  • @leosmithune1117
    @leosmithune1117 Před 4 lety +1

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

  • @saaddarell9174
    @saaddarell9174 Před 4 lety

    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
      @StevdzaSan  Před 4 lety

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

  • @xivxvi263
    @xivxvi263 Před 4 lety

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

  • @quenchpit8621
    @quenchpit8621 Před 2 lety

    you are awesome!!

  • @cubedev4838
    @cubedev4838 Před 4 lety

    Amazing!! Amazing!!

  • @palustrecarlgabriel1477

    THANK YOU SOOOOO MUCHH!!!

  • @the_gost_gamer3841
    @the_gost_gamer3841 Před 2 lety

    thank you

  • @alibyh4295
    @alibyh4295 Před 2 lety

    Which version are you using?

  • @DavidKabs
    @DavidKabs Před 2 lety +3

    Man you are going way to fast... Couldn't get anything...

  • @gilmarcossantos3951
    @gilmarcossantos3951 Před 2 lety

    Muito obrigado!

  • @ericfricke4512
    @ericfricke4512 Před 3 lety

    🖐️ high five

  • @sleepycatzz
    @sleepycatzz Před rokem

    mine didnt work w add activity thing :(

  • @aimanaqari687
    @aimanaqari687 Před 4 lety

    Can u make a tutorial using kotlin programming language please

    • @StevdzaSan
      @StevdzaSan  Před 4 lety +1

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

    • @aimanaqari687
      @aimanaqari687 Před 4 lety

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

  • @emanuelhosseini7623
    @emanuelhosseini7623 Před 2 lety

    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!

  • @windowtothemind8534
    @windowtothemind8534 Před 2 lety +1

    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
      @StevdzaSan  Před 2 lety +1

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

    • @windowtothemind8534
      @windowtothemind8534 Před 2 lety

      @@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

  • @alkaramessi
    @alkaramessi Před rokem

    I can't see title in emulator . Brate ako si naš na sprskom odgovori. 😂

  • @troll2637
    @troll2637 Před 2 lety +1

    Jesus christ. Even the playback speed button couldn't slow you down.

  • @adrimntlr7767
    @adrimntlr7767 Před 3 lety

    possible to make kotlin version thx

    • @StevdzaSan
      @StevdzaSan  Před 3 lety +1

      I have a tutorial series about ROOM library + Kotlin. Check my playlist.

  • @amirhosainarabzade5990

    👌🙏

  • @pankajwandre5961
    @pankajwandre5961 Před 4 lety

    👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

  • @user-rt5br3mw9j
    @user-rt5br3mw9j Před 2 lety

    Почему название на русском а звук на англиском ?

  • @user-ur5ks5he6d
    @user-ur5ks5he6d Před 10 měsíci

    Родной русский, да?

  • @gabrielamaralpassos9537
    @gabrielamaralpassos9537 Před 2 měsíci

    Too fast my man, TOOO F FAST, slow the fuck down. But good video.

  • @TheLordx7
    @TheLordx7 Před 3 lety

    Good tutorial, but mannn you are too fast....

  • @goodnightt1520
    @goodnightt1520 Před rokem

    брат, не пытай себя просто говори по русский

  • @user-ns6ee9lf4i
    @user-ns6ee9lf4i Před 4 lety

    thank you