Excellent tutorial Man! Honestly I tried lot of UA-cam videos and other articles about database, but none of them was this much simple. Great work. Subscribed even before completing the video !!
Hoping of creating a simplified package that is a shield of the SQLite package you are using to make things even more esier, such that users will never care about instances, helper and stuffs like that. By the way it has been a long time since I did mobile development, i have refreshed my mind, thanks. Ps: NOn-java developers tend to fear maps a lot and most probably they even don't understand what's it. From PHP map is the same as associative arrays and when we introduce lists of maps, is the same as dealing with multidimensional associative arrays in php. Java/JavaFx developers do not need such explanation, we have dealt with Maps so many times. All in all thanks a lot. Many thanks
Thank yooouuuu sooo muuchhhh 😭❣️. I've been struggling with sqflite for a month cause it seemed so abstract but you've explained every little bit of it so clearly! You're a profound teacher!!
Really a great and very helpful tutorial video ! I am just searching around for sqlite to integrate it with my flutter app but don't have any idea on it but after watching this video I think now I can proceed with DB integrating into my flutter app. Thank you !!
This is an excellent video that will lay a good foundation for extending skills in handling data. The progress is logical and well-thought-out. The extension of this needs just a more complex data structure and passing data to the UI. Brilliant, well done, thanks!
Hey dude! Well done! appreciate the effort in making us understand each action you took in the code even if it made your video too long. From one dev to another, appreciation all over ! :)
Excellent tutorial. fantastic, totally worth it all the 40 mins. Dude, you are soo good at explanation. I won't forget this database management for a long time. Just like this if possible make videos in interacting on native components of mobile(camera) etc. That could help our team a lot. And by the way thanks for the explanation.
I love how you explain and break things down to simpler terms. Indeed helpful for beginners. I'm just at the few minutes of the video and loving it. Thank you so much. Got yourself a new subscriber here. And I guess you will be very effective teacher for a tutorial about favorites list with sqflite + provider package.
Thanks for the video but I have a problem - maybe because of newer versions of Dart/Flutter (Dart 2.18.2 Flutter 3.3.3). I need to use notation such as Future insert(...), Database? db, and return await db?.insert to get rid of errors. And the "insert" call from the GUI returns a null. I see that you do not use this in your lecture. Any suggestions?
Guys I'm getting this error 'Non-nullable instance field '_database' must be initialized. Try adding an initializer expression, or add a field initializer in this constructor, or mark it 'late'.' Somebody help me out
hi, first of all thanks for this simplified one of its kind tutorial. i have a doubt. you have used deleted function to delete an id. the resulted database has no value in that id. can we shift all datas after the deleted id to left so as to fill deleted ids .i.e to not have an instance of id without a value when fetched query.
Can't leave this video without a positive comment 😁 It's a well explained tutorial. Thank you for making such great video 🤩 All support for you ❤️ Subscribed 🔔👍
tring path = join(directory.path, _dbName);I got error here which is "Undefined name '_dbName'. (Documentation) Try correcting the name to one that is defined, or defining the name." while i did as you , any idea please
Make a getNames method and write the logic to retrieve the list, use FutureBuilder or call the method in initstate and display it on the screen using Listview
hi, I'm a new bie for flutter i have an old database named patient.dB with column int ID ; String? avatar; String? name; String? describe; String? link; String? date; String? hospital; now, i just want to read all record and display on listview. please help thank you very much!!!
@@TheGrowingDeveloperDear if you don't mind i need your little help so kindly can we share contact info. if you like kindly here is my Email address: Sheraz73427@gmail.com.. looking for response ASAP Thank you.
Great tutorial. Learned a lot from it. Thanks for making it and would like you to please make more sqflite tutorials on advanced database operations like querying and updating multiple tables etc.
Hi The video is really great and help me a lot,but i have a question what happen if i will call initialize database again and ,i mean does it recreate or open the database if already exist.
Highly recommended! Simplified with great explanation, while holding on the basics. Worth the 40 minutes in every sense.
Glad to hear that 😊 thanks ❤️
dude, this is the best tutorial I found to understand sqflite int 2024. Simple and straight forward.
This is the best tutorial on SQLite I've seen so far. Amazing!
One of the most critical things you did here was explain WHY this and that. That was so important, so thank you for that
dude , this is the best video to understand Sqflite Crud , thank you
Glad it helped!
Step by step, no unnecessary complexities and fancy displays, Flutter team can learn from you when creating their tutorials!
Thank you so much for the appreciation!!! Keep supporting!
I have gone through other tutorials where I did not get head and tail of sqflite but this tutorial is really easy to understand. Thanks a lot.
Glad it helped!
Exactly what I was looking for! BTW you were 100% correct in saying that other channels have made it complicated.
Yes, the internet was covered with complex terms and you did present it in a simpler way. Thank you so much for your time and effort.
Glad it helped😊
Excellent tutorial Man!
Honestly I tried lot of UA-cam videos and other articles about database, but none of them was this much simple.
Great work.
Subscribed even before completing the video !!
Thanks 😊♥️
Hoping of creating a simplified package that is a shield of the SQLite package you are using to make things even more esier, such that users will never care about instances, helper and stuffs like that. By the way it has been a long time since I did mobile development, i have refreshed my mind, thanks.
Ps: NOn-java developers tend to fear maps a lot and most probably they even don't understand what's it. From PHP map is the same as associative arrays and when we introduce lists of maps, is the same as dealing with multidimensional associative arrays in php. Java/JavaFx developers do not need such explanation, we have dealt with Maps so many times.
All in all thanks a lot. Many thanks
The very best I could find on the internet. Nicely explained each and every term and the logic behind them.
Glad it helped! 😊
Thank yooouuuu sooo muuchhhh 😭❣️. I've been struggling with sqflite for a month cause it seemed so abstract but you've explained every little bit of it so clearly! You're a profound teacher!!
Finally a begginers tutorial, All i see on youtube is for the advanced ones , Thank You so much
Glad it was helpful!
Just wanna say. Great tutorial overall! Really simple straight to business.
Sir I am writing static Database= _database; and its showing static variable can not be null. 😔😔
Best video in UA-cam about this shared preferences. Clean and nice 👌
Really a great and very helpful tutorial video ! I am just searching around for sqlite to integrate it with my flutter app but don't have any idea on it but after watching this video I think now I can proceed with DB integrating into my flutter app. Thank you !!
Glad it helped 😊
This is an excellent video that will lay a good foundation for extending skills in handling data. The progress is logical and well-thought-out. The extension of this needs just a more complex data structure and passing data to the UI. Brilliant, well done, thanks!
Glad you enjoyed it!
Great video, made the concept very simple and easy to understand. Thank you!
Glad it helped! 😊
Hey dude! Well done! appreciate the effort in making us understand each action you took in the code even if it made your video too long. From one dev to another, appreciation all over ! :)
Glad it helped!
Excellent tutorial. fantastic, totally worth it all the 40 mins. Dude, you are soo good at explanation. I won't forget this database management for a long time. Just like this if possible make videos in interacting on native components of mobile(camera) etc. That could help our team a lot. And by the way thanks for the explanation.
Thank you so much 😊 , I'll try my best to bring these concepts in near future for sure!
A great tutorial with precise and simple explanation. ..appreciation for your efforts!!
Thankyou so much 😇
I love how you explain and break things down to simpler terms. Indeed helpful for beginners. I'm just at the few minutes of the video and loving it. Thank you so much. Got yourself a new subscriber here.
And I guess you will be very effective teacher for a tutorial about favorites list with sqflite + provider package.
Thanks 😊❤️
very good video, thanks for all the great information
the comments are not lying, this is really a good video
Glad you think so !! ❤️
You taught it in very simple way :)
First sqflite tutorial search and I already got it, thanks a lot man
Happy to hear that!
Great teaching skills. Love watching this tutorial. You clear my concept of sqflite basic. Thank you very much.
Great to hear!
Thanks for the video but I have a problem - maybe because of newer versions of Dart/Flutter (Dart 2.18.2 Flutter 3.3.3). I need to use notation such as Future insert(...), Database? db, and return await db?.insert to get rid of errors. And the "insert" call from the GUI returns a null. I see that you do not use this in your lecture. Any suggestions?
Guys I'm getting this error 'Non-nullable instance field '_database' must be initialized.
Try adding an initializer expression, or add a field initializer in this constructor, or mark it 'late'.' Somebody help me out
Great explanation.... Thanx ❤❤❤❤❤
This is the best video with the best basic explanations to the topic. Thank you so much. I loved it.
Glad it helped 😊
It really helped thanks alot. I just have 1 nit picking. It would be really helpful if u provided the code in the github too. For referncing
Bro Give me a hug,,, you are awesome ...Must watch this video to clear your concept
Thank you so much 😀
Hey! I really loved the video. However I want to know, If i want to get pr save data from a different version of database in the UI. what should I do?
HELPED ME A LOT !!! Big THANKS
Glad it helped!
this is a greate and simplified tuto thank you so much sir
Glad it was helpful!
Great Tutorial with Simple Explanation...!!
Loved it
Thanks a lot 😊
Great tutorial!!! Keep up the good work!
Thank you! Cheers!
Very clear to me. Thanks a lot
I really learned a lot from this tutorial. Your efforts in making these videos are very much appreciated!
Glad you like them!
nicely explained, Helped alot in my project.
best video of the month, still valid as of today
Glad it helped!!
hi, first of all thanks for this simplified one of its kind tutorial. i have a doubt. you have used deleted function to delete an id. the resulted database has no value in that id. can we shift all datas after the deleted id to left so as to fill deleted ids .i.e to not have an instance of id without a value when fetched query.
Great work. very easy to follow and you explain very clearly.
Love from ♥️ ..
tring to understand since last 1 year but at last i can understand it..
Glad it was helpful
Really too nice...helpful need more videos about flutter...
Will upload soon
Bruh, it is as simple as you said! Really worth while
Thanks!
Awesome video! Very simple, clear and good starting point for the topic!
Much appreciated!
i don't follow how with the final table name can the insert, update etc be relevant to all created tables
We are executing all the operations on the same table
Very simple and understanding. Thank you for your efforts.
Glad it helped 😊
you are awesome .. i don't know how can i thank you .. really thx so much dude .. your fans from egypt
Happy to help!
Thank you sir, this tutorial helped me a lot.
Glad to hear that
Thank you so much sir your content more better than udemy. again thank you to provide free content. subscribed in first watch
You are most welcome
how to display this data on the screen without datatable widget? Can you please make a video on it.
You can watch my Api video where i explained parsing data and showing it on screen
What database would you recommend for a match app along with chat, cloud Firebase (being the latest) or any other db such as sqflite?
Firebase
Simplified explanation , very helpful tutorial thanks
Glad it was helpful!
there is any github link of project u create in this video so we can download it and understand it.
Thanks Sir
Love from Bangladesh
Hi brother, what are the dependencies in your pubspec.yaml?
path_provider and sqflite
how do i insert the query list data in a listview.builder(). and display in the ui
You can wrap it with FutureBuilder!
@@TheGrowingDeveloper thanks. already i have implemented it
Thanks man, so clear, from Indonesian
You're welcome ☺️
again i want to say .. you are awesome .. im so happy .. thx dude
Glad to hear that
Can't leave this video without a positive comment 😁 It's a well explained tutorial.
Thank you for making such great video 🤩
All support for you ❤️
Subscribed 🔔👍
Thank you so much 😀
Even after using db.execute, I am getting no such table error.
Try removing the app from device and reinstall
@@TheGrowingDeveloper it worked.. Thanks!
Great 😊
@@TheGrowingDeveloper I am using emulator and this still did not work for me
any suggestions?
Any changes in create table command requires complete app reinstallation
WOW!! Thanks a lot, man. Many Many Many Thaks for the video. 😀
Glad it helped!
Damn...thank you. I hope your yt channel will grow!
I hope so too 😊 Keep Supporting
It was going well but even though this video was released after null-safety came in it fails in the helper because of null safety.
Pity.
What are the theme settings you're using for your android studio? I really like it.
I use material theme plugin
tring path = join(directory.path, _dbName);I got error here which is "Undefined name '_dbName'. (Documentation) Try correcting the name to one that is defined, or defining the name." while i did as you , any idea please
Easily implemented as explained. Great work.
Glad it was helpful!
Hi, I'm always getting 'Instance of [insert table name]' instead of the data saved to the specific row in the database
Awesome , Great Tutorial with Simple Explanation ,,,, Thanks
Glad it was helpful!
Just found your channel, this video is awesome, subscribed, thank you
Awesome, thank you!
Really useful, thanks for helped me!
Great
This video helps me a lot and the explanation that you gave in this tutorial is very easy to understand
Glad it helped 😊♥️
great video but i have just one question... if a would want for list of the names to appear on the screen what would i need to do... i
Make a getNames method and write the logic to retrieve the list, use FutureBuilder or call the method in initstate and display it on the screen using Listview
Thank u so much for your efforts. Learnt a lot from you
Glad to hear that
great videos,where have you been these days 😅
hi, I'm a new bie for flutter
i have an old database named patient.dB with column
int ID ;
String? avatar;
String? name;
String? describe;
String? link;
String? date;
String? hospital;
now, i just want to read all record and display on listview.
please help
thank you very much!!!
GREAT TUTORIAL! THANK YOU FOR YOUR EXPLANATION. ITS SO CLEAR. SUBSCRIBED, RING BELL!
Thanks for the sub!
Thank you soo much bro it was very easy to understand. Kindly keep making videos with your unbelievable easy method.
Again Thank you.
Thank you ❤️
@@TheGrowingDeveloperDear if you don't mind i need your little help so kindly can we share contact info. if you like kindly here is my Email address: Sheraz73427@gmail.com.. looking for response ASAP
Thank you.
@@sheraz_razzaq you can contact me on sahebsingh@hotmail.com
@@TheGrowingDeveloper sure Thank you.
This helped a lot!! saved my day!!
Glad it helped!
Great tutorial. Learned a lot from it. Thanks for making it and would like you to please make more sqflite tutorials on advanced database operations like querying and updating multiple tables etc.
Soon !
sir insert was called on null in mycase pls help
Share the code on any of my social media handle
Great video!!! You did your best Bro.
I appreciate it!
Hi The video is really great and help me a lot,but i have a question what happen if i will call initialize database again and ,i mean does it recreate or open the database if already exist.
It'll most probably overwrite the existing file
One of the best and clearest explanation 🙏 keep it up thank you
Subscribed😉
Thankyou so much 😊
Please, show how to retrieve BLOB image data (not String) from existing SQLite database with sqflite in Flutter, can't find it anywhere
Soon!
Best video, very well explained. Leant a lot 👌🏿
Thanks a lot 😊
Really great video for covering basics.
Thanks!!!
Thanks 😊
Thank you for such quality content ❤
Glad it was helpful!
you made it so simple even though it is difficult to follow.
thank you so much sir , thank u Indian people .
Glad it helped!
can you tell me function to delete all rows?
Just execute the delete command without giving any whereargs
Another Excellent tutorial. Perhaps make a video on stored procedures and triggers. Thanks
Sure 😊
Really appreciate your videos! but what if the db is needed to download from url?
Then instead of creating a new File and path we will download the file and then save it to some path and refer to it !
@@TheGrowingDeveloper thanks for your reply, am gonna check it out!
Bro please come back to youtube and continue the journey. Waiting for your new videos.
Soon Durgesh !! ❤️
Great tutorial.
Loved it.
Glad you liked it!
@@TheGrowingDeveloper i am getting error
Method insert is called on null.
Can you help me with it