Sqflite Tutorial | Flutter plugin for SQLite | CRUD

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 165

  • @arpro3038
    @arpro3038 10 หลายเดือนก่อน +1

    I must have viewed over 30 TH-cam videos about Flutter until I came across yours. Thank you very much for all your videos. I like the no frills, just the topic and that you always start with a fresh new code from the beginning and you share the completed code. I also like that you explain as you work. Thank you.

  • @isho7777
    @isho7777 ปีที่แล้ว

    Straight to the point. Only the relevant info on how to use sqlite database and no fancy widgets

  • @bharathkumar-ji4if
    @bharathkumar-ji4if 2 ปีที่แล้ว +1

    One of best tutorial ever. Its every easy to work on a single page code rather download bundle of files. Thank you so much

  •  3 ปีที่แล้ว +4

    I was watching this topic in the tutorial video recorded in 2019, but the whole syntax has changed and I didn't understand anything, I wrote the same video as the current version and I understood the logic. Thanks ☺

  • @mateusfensterseifer4553
    @mateusfensterseifer4553 3 ปีที่แล้ว +4

    Awesome Tutorial. The best Flutter Tutorial i've seen! Keep that great work man!

  • @averageprogrammingenjoyer2059
    @averageprogrammingenjoyer2059 2 ปีที่แล้ว +1

    Top notch tutorial, no bs, nothing. Thank you very much. You helped out a lot in my project!

  • @ikmal_is1773
    @ikmal_is1773 3 ปีที่แล้ว

    this one is hell easy to understand. Been watching so much tutorial about sqlite. But this one is really easy to understand . Thanks sir

  • @ManontheOutside
    @ManontheOutside ปีที่แล้ว

    Great tutorial, Everything you need to get sqflite up and running quickly, all in one place. Brilliant videos and tutorials, look forward to more. Thank you!👍

  • @LuisOtavioZimmermann
    @LuisOtavioZimmermann ปีที่แล้ว

    Amazing teaching. Awesome and straight forward video.

  • @nabil.hamawi
    @nabil.hamawi 2 ปีที่แล้ว

    I can't thank you enough... You're the best tutor in the world!

  • @gubukbonsai6005
    @gubukbonsai6005 3 ปีที่แล้ว +1

    Clear Straight Quick, no matches, keep it up!!!

  • @ammarboro6089
    @ammarboro6089 3 ปีที่แล้ว +16

    This is such a simple yet straight-forward tutorial. Loved it and highly recommend for someone that is starting out with flutter like me. You sir, earn a subscribe from me

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว +2

      Thank you so much!

    • @infotration2225
      @infotration2225 2 ปีที่แล้ว

      @@LearnFlutterwithMe I was searching for tutorials like at least I found you. You earn subscribers not single but many

  • @caiocamargoantonio
    @caiocamargoantonio ปีที่แล้ว +1

    Thank you for the luck and opportunity to have found this excellent tutorial, in which your explanations were perfect and provided in sync with the context being taught following a very pleasant and captivating format during coding (...plagiarizing a message posted by a previous colleague "Sensational video ").
    Thank you very much.

  • @byteclub-dev
    @byteclub-dev ปีที่แล้ว

    Thank you for the tutorial. It's easy enough to follow along!

  • @alberthajek9067
    @alberthajek9067 2 ปีที่แล้ว +1

    Hi! I juts want ot thank you for making this video! Makes super sense, your explanatory skills are perfect and format is very enjoyable while coding. Helped me a lot, others such as Johannes Milke couldn't do job as great as you did. Awesome video, thank you very much!

  • @romeroo98
    @romeroo98 3 ปีที่แล้ว

    This channel deserve a lot! Keep itu up!

  • @Mithun_Dutta_30
    @Mithun_Dutta_30 2 ปีที่แล้ว

    Thank you very much for this tutorial. I was struggling with it for a week now.

  • @obinnaelviso
    @obinnaelviso 2 ปีที่แล้ว

    Wow. I love this video and the steps. I was able to implement this with an already existing database in my assets folder.

  • @jihedbouchnak
    @jihedbouchnak 2 ปีที่แล้ว

    thanks a lot this is even better then documentation keep the good work and make us more videos

  • @gumdum6764
    @gumdum6764 3 ปีที่แล้ว +1

    very nice work. I like how you initialized the database only if needed

  • @amrhaithem7064
    @amrhaithem7064 3 ปีที่แล้ว

    thanks for this. Keep moving this will be a great channel

  • @mageshkanna
    @mageshkanna ปีที่แล้ว

    you saved my entire day 😇

  • @seankiong
    @seankiong ปีที่แล้ว +1

    nice! btw, is there a way to extends the databasehelper if i would like to have a separate file to store individual table models and functions?

  • @sailinhtut5961
    @sailinhtut5961 2 ปีที่แล้ว

    Thank Sir ,Super Clear Explanation with relax music

  • @antoniomanoel2873
    @antoniomanoel2873 2 ปีที่แล้ว

    amazing content I do recommend for anyone who is learning

  • @husseinj7505
    @husseinj7505 ปีที่แล้ว

    Thank you for this great and simple tutorial.👍

  • @ipott8212
    @ipott8212 3 ปีที่แล้ว +1

    Wow, this helped me a lot. Thanks!

  • @dandy8121
    @dandy8121 2 ปีที่แล้ว

    Just to avoid future updates, i reccommend using an if else statement on the floatingactionbutton to where if the textcontroller is empty, it wont do anything, else does as it suppose to. not necessary but its a good add-on

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  2 ปีที่แล้ว

      Yep! I think any fool proofing is worth the time! Thanks for sharing!

    • @Revamiko
      @Revamiko 2 ปีที่แล้ว

      are you know how to do that? please help me

  • @meandmydodge
    @meandmydodge 2 หลายเดือนก่อน

    Deserved to be Liked and Subscribed ... Done ... Subscribed 👍

  • @vijaybabaria3253
    @vijaybabaria3253 3 ปีที่แล้ว

    like your cool and relaxed style of teaching - hope to see more flutter videos

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว

      Thank you!

    • @vijaybabaria3253
      @vijaybabaria3253 3 ปีที่แล้ว

      @@LearnFlutterwithMe Pls let me know if you have any suggestions to sync back local data to a source, may be initialize data thru REST api at start and sync back after some interval and also destroy local data if there is no user activity within x number of days. Trying to figure out efficient way of syncing local storage back to source. Thanks

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว

      @@vijaybabaria3253 hmmm... depends on the application I suppose. I would say, using user settings as an example, if they change a setting and you want it to be backed up or available across platform, you would need to write that change on save to a remote source immediately to avoid any delay. Think of this - I come from a web design background. If the server does a nightly backup at 22:00 and the database crashes at 21:00 you've lost a whole days worth of data. My vote would be to just store individual changes remotely on saves to avoid heavy bandwidth usage and loss of data. Hope that made sense! You might ask on one of the flutter communities as well as someone there may have more experience than I do: flutter.dev/community

  • @faizanchaudhry8754
    @faizanchaudhry8754 ปีที่แล้ว

    thankx sir to the point vedio and so easy way and short vedio tutorial thankx sir

  • @ohenro19
    @ohenro19 2 ปีที่แล้ว

    Excellent Tutorial!! Thank you so much

  • @andrewshenouda3604
    @andrewshenouda3604 3 ปีที่แล้ว +1

    Very easy to follow tutorial and straight to the point - Thank you!
    Subscribed and would like to see more SQLite tutorials like this one and showing different ways to interact with the SQLite database from the UI frontend perspective
    For example, can you return the data from the db to the frontend in different widgets other than List, like DataTable widget?

  • @bobbysmith8588
    @bobbysmith8588 2 ปีที่แล้ว

    Awesome tutorial, thanks for take your time to create it

  • @gethsun1
    @gethsun1 ปีที่แล้ว

    Neat Quick job 👍

  • @BrunaAraujoPinheiro
    @BrunaAraujoPinheiro 2 ปีที่แล้ว

    Simple and right to the point, thank you so much for making this video :D

  • @hasans7370
    @hasans7370 2 ปีที่แล้ว +1

    Thank you so much sir! Always clear and straight to the point ❤
    I'd really appreciate it if you can do SQFLite video where you have multiple tables and want to use Foreign Key in CRUD.
    Again Thank you :)

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  2 ปีที่แล้ว +1

      Thank you! I'll see what I can do for you! Thanks for watching!

  • @vaishnavinagrale5429
    @vaishnavinagrale5429 ปีที่แล้ว

    Thank you so much that was so helpful...

  • @shihabhossain4190
    @shihabhossain4190 2 ปีที่แล้ว

    Thank you. Your video helped a lot.

  • @mruduladdipalli5417
    @mruduladdipalli5417 3 ปีที่แล้ว

    What an explanation, really amazing

  • @ankitchawla8487
    @ankitchawla8487 2 ปีที่แล้ว

    This was very helpful, thanks a lot.

  • @szyszak9424
    @szyszak9424 2 ปีที่แล้ว +1

    4:37 what is it that code? this factory from map something?

  • @javadmahmoodi2469
    @javadmahmoodi2469 2 ปีที่แล้ว

    Hello. Thank you for your good teaching. Please publish a tutorial on how to add search to this list. Thanks

  • @Hidden_traveler93
    @Hidden_traveler93 2 ปีที่แล้ว

    very good tutorial and explanation very good that how can do it easily

  • @ashishu8888
    @ashishu8888 2 ปีที่แล้ว +1

    thank you so much sir!

  • @kbyo2006
    @kbyo2006 2 ปีที่แล้ว

    Thanks for tutorial!!

  • @jemmytech5474
    @jemmytech5474 3 ปีที่แล้ว

    Thank you so much. I’ve waited a lot

  • @luisnepas3326
    @luisnepas3326 2 ปีที่แล้ว

    Thanks. Great tutorial!

  • @abdelrahmananwar885
    @abdelrahmananwar885 2 ปีที่แล้ว

    is there an advantage in using the Future Builder way over the ListViewBuilder Way?

  • @d4tto92
    @d4tto92 2 ปีที่แล้ว

    it was great sqlite tutorial thank you for this

  • @aunghtet3636
    @aunghtet3636 2 ปีที่แล้ว

    Thank you very much sir. You are awesome!

  • @diamondeagle173
    @diamondeagle173 2 ปีที่แล้ว

    Thank you Sensei.

  • @monobrezel2647
    @monobrezel2647 2 ปีที่แล้ว

    just simple and cool !

  • @BBFTW36
    @BBFTW36 3 ปีที่แล้ว

    ty so much sir, very easy explained and helpful

  • @abdelrahmananwar885
    @abdelrahmananwar885 2 ปีที่แล้ว

    pretty neat, thank you

  • @KK-lr4vx
    @KK-lr4vx 2 ปีที่แล้ว

    your videos are simple and easy to understand. could you make one on drift/moor orm for sqlite.

  • @sriram4738
    @sriram4738 ปีที่แล้ว

    easy to be followed

  • @iasror
    @iasror 2 ปีที่แล้ว

    you doing great. thank you

  • @deveshojha8748
    @deveshojha8748 ปีที่แล้ว

    I am creating a real time chat application in Flutter using socket and and I have to store messages locally when there is no internet connection. Is Sqflite good for this purpose?

  • @jaylee3270
    @jaylee3270 3 ปีที่แล้ว +1

    Many thanks. Such a great tutorial!
    Sir,
    is it possible to put them into categories? For example, Create 'Fruits', 'Meats' and other custom categories and put 'bananas', 'apples' into 'fruits' category. And then CRUD categories and CRUD items in categories.
    Could you please make this tutorial?

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว +1

      Thank you! Yes I will add it to my to-do list!

  • @munaretto_
    @munaretto_ 2 ปีที่แล้ว

    Thank you very much!

  • @sreejapasupuleti5384
    @sreejapasupuleti5384 3 ปีที่แล้ว

    Hello sir, here i am unable to get no groceries in list at 9:00 minute it was showing only loading... thats it any suggestion?

  • @jae7593
    @jae7593 3 ปีที่แล้ว +1

    Thank you :)

  • @earthrelated
    @earthrelated 2 ปีที่แล้ว

    Thank you sir!

  • @dhruvinprajapati4345
    @dhruvinprajapati4345 3 ปีที่แล้ว

    thank you so much this video help me

  • @bongssang
    @bongssang 3 ปีที่แล้ว

    Thank you so much! this video big help for me.

  • @faizulla5838
    @faizulla5838 2 ปีที่แล้ว

    Brooo, Hello! Can you do video Sqflite+GetX and Hive + GetX ... and with more model items ? maybe 4-5 (String, int , bool) ... ???

  • @nilsirl
    @nilsirl ปีที่แล้ว

    Isn't it bad practice to create a future inside of FutureBuilder?

  • @edu28811
    @edu28811 2 ปีที่แล้ว

    Very good. Thank you

  • @Aboudimassi
    @Aboudimassi 2 ปีที่แล้ว

    Hey
    thank you for this nice tutorial
    can you help me to understand this code? why you have created an instance of constructor inside the class it self and you also initialize it, it sounds good but really not understand the following code
    DatabaseHelper ._privateConstructor() ;
    static final DatabaseHelper instance = DatabaseHelper ._privateConstructor() ;
    what above code called ? espcially "DatabaseHelper ._privateConstructor() ;"
    I am coming from a Java background 😀

  • @muradhamed2960
    @muradhamed2960 9 หลายเดือนก่อน

    cool Destiny shirt bro

  • @sbasalan
    @sbasalan 2 ปีที่แล้ว

    Is there a possibility to query database (sqlite) and get a result that return from databse?

  • @chandrasekarchan9386
    @chandrasekarchan9386 2 ปีที่แล้ว

    you are great!

  • @davidowens9597
    @davidowens9597 3 ปีที่แล้ว

    Another great video. I was curious why you like using Android Studio rather than VS Code? Thanks.

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว +1

      Thank you! Well its funny you ask that... I just switch to vs code because android studio was using an excessive amount of memory and it was causing me problems recording videos on my older MacBook. The next video will have vscode.

    • @jemmytech5474
      @jemmytech5474 3 ปีที่แล้ว

      Oh i use android studio as well on my mac m1. Lemme switch to VS. Though I’ve installed earlier but the interface was quite different

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว

      @@jemmytech5474 there ARE themes that will change your colors to the same as Android. I'll try to remember to post it here or maybe search for "android studio theme for vs" or something. Assuming thata's what you want it to look like of course

  • @leoingson
    @leoingson 3 ปีที่แล้ว

    Thanks, subscribed. What about github-ing the code?

  • @Revamiko
    @Revamiko 2 ปีที่แล้ว +1

    please help me, how do I do it so that if the input is empty then we can't add it to the list?

    • @omersar9120
      @omersar9120 2 ปีที่แล้ว

      put a if function in floatingActionButton like " if (textController.text != ' ') "

  • @DavidFuto
    @DavidFuto 2 ปีที่แล้ว

    I already have a write db file, how can I use it?

  • @angelopaligutan1665
    @angelopaligutan1665 3 ปีที่แล้ว

    Thank you so much.

  • @sajeentharthavaneswaran8578
    @sajeentharthavaneswaran8578 2 ปีที่แล้ว

    I installed sqflite too but it shows an error in 'Database' get the quick fix button it shows to add the package sqflite but I already add that package please guide me regarding this

  • @usama_khalid
    @usama_khalid 3 ปีที่แล้ว

    Thanks . it is really helpful

  • @noblenetdk
    @noblenetdk 2 ปีที่แล้ว

    You talk about two pevious videos - wirch onces?

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  2 ปีที่แล้ว +1

      Hey Kim! They are "Flutter Firebase Tutorial" th-cam.com/video/WuYOGBEOEOo/w-d-xo.html
      and "Flutter Widget Basics: ListView" th-cam.com/video/2jTP9Po04ms/w-d-xo.html
      Sorry about that!

  • @luoichannel
    @luoichannel 2 ปีที่แล้ว

    Thanks so much

  • @fleshpaghetti
    @fleshpaghetti 3 ปีที่แล้ว

    How can I add a new table on existing .db file?

  • @jemmytech5474
    @jemmytech5474 3 ปีที่แล้ว

    Sir how to search instantly in the listview? This video helped me a lot, my assignment is almost completed except the searching functionality. Please I’ll be waiting for you.

    • @jemmytech5474
      @jemmytech5474 2 ปีที่แล้ว

      I solved this. Check out in my channel

  • @jemmytech5474
    @jemmytech5474 3 ปีที่แล้ว +1

    Sir my app is to add new user and show it in the listview. But my listview does not update dynamically when i click on the add button. It always needs to reopen the app.
    Please help me , this video helped me a lot but only the above problem still occurring

    • @lephichung
      @lephichung 2 ปีที่แล้ว +1

      You need to add setState to re-render the app

    • @jemmytech5474
      @jemmytech5474 2 ปีที่แล้ว

      @@lephichung where should I add the setState? In the add button?

    • @lephichung
      @lephichung 2 ปีที่แล้ว +1

      @@jemmytech5474 yes, in add button

  • @choroguarda
    @choroguarda 3 ปีที่แล้ว

    Hi! i have a question, i want to do an app that is synchronized with an web app, so i already have a database created, the database has a lot of tables already so my doubt is, i have to initialize the database in all the places that i want to make a crud? o i can put hte code in a file.dart and call it from there, sorry for my bad English i am from south america, thank you and great video.

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว

      Hi! Yes I believe the way people would normally do this is to create an api on your web app that you call from your flutter app in your various crud calls in file.dart. A little bit complicated to put into a single comment. I have plans to discuss apis in the future I'll see if I can get to it sooner than later. Thanks for watching!

  • @sportKO12
    @sportKO12 3 ปีที่แล้ว

    Great ! Respect....

  • @Jonas-mi9yj
    @Jonas-mi9yj 3 ปีที่แล้ว

    One question are the factories toMap and fromMap the same as toJson and fromJson which can be generated through json_serializable?

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว

      This might explain it better than I can atm:
      flutter.dev/docs/development/data-and-backend/json

  • @xXEazy94EXx
    @xXEazy94EXx 2 ปีที่แล้ว

    somehow when I close my app all the data is deleted after I reopen it. Did the tutorial exactly as in the video...

  • @seandillon9605
    @seandillon9605 2 ปีที่แล้ว

    Good tutorial, but I will say, simple if / else statements are much easier to read and follow than multi-line ternary operator statements

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  2 ปีที่แล้ว

      Yeah I agree with you. Watching back the video @12:30 that would definitely be easier to read. I'll have to consider that in future videos. Thanks!

  • @davelogan77
    @davelogan77 2 ปีที่แล้ว

    this is legit.

  • @TheMRTIMBUK2
    @TheMRTIMBUK2 3 ปีที่แล้ว

    Nice Speed Coding ...

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว +1

      Well, I cheated. haha! I speed up the code parts in editing so y'all don't have to sit through all that!

  • @westleykooseenlin356
    @westleykooseenlin356 3 ปีที่แล้ว

    very good video , btw may i know the background music ?

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว

      Thank you! It is called "Leave it Alone" by Underbelly. I've tried to find another one so I'm not always using the same song, but this one works so well I haven't been able to replace it!

  • @jemmytech5474
    @jemmytech5474 3 ปีที่แล้ว

    Sir could make a flutter_slidable tutorial on the same sqlite tutorial

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  3 ปีที่แล้ว +1

      I sure will, I will add it to the list to do!

    • @jemmytech5474
      @jemmytech5474 3 ปีที่แล้ว

      @@LearnFlutterwithMe yes please i need it

  • @maccachan64
    @maccachan64 3 ปีที่แล้ว

    so if i want to use both firebase and sqlite at the same time, possible?

  • @kamalCode
    @kamalCode 3 ปีที่แล้ว

    Sir, flutter package Development tuotorial

  • @halilmertdeveli3846
    @halilmertdeveli3846 2 ปีที่แล้ว

    the system is adding but name is coming null ı colund't solve

  • @ricgor3441
    @ricgor3441 3 ปีที่แล้ว

    The Full Source Code Button, is not working.

  • @abdullaaeham
    @abdullaaeham 3 ปีที่แล้ว

    👌👏

  • @mbithi_ke
    @mbithi_ke 2 ปีที่แล้ว

    used this video just today and guess what, my app went unresponsive when i try adding to database, an update needed or something?

    • @LearnFlutterwithMe
      @LearnFlutterwithMe  2 ปีที่แล้ว

      I will review it and see if I can put out an update soon! Thanks for letting me know!