I must have viewed over 30 UA-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.
Straight to the point. Only the relevant info on how to use sqlite database and no fancy widgets
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 ☺
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!👍
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
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!
@@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
@@vee-obsidian 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
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.
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?
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 :)
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
Hey Kim! They are "Flutter Firebase Tutorial" ua-cam.com/video/WuYOGBEOEOo/v-deo.html and "Flutter Widget Basics: ListView" ua-cam.com/video/2jTP9Po04ms/v-deo.html Sorry about that!
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?
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?
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 😀
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 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
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
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.
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!
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.
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!
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
Love the to-the-point style, love the visual presentation of the code but bro... How come you don't explain the concepts ? What the hell is a DataBaseHelper?
That's something I struggle heavily with; trying to balance explaining everything I'm doing in a clear manner while trying to keep it as simple as possible to try to prevent overwhelming those who are brand new. In this specific example, if you're talking about the Class name, it's just the name I used, you can replace "DatabaseHelper" with anything you'd like to call it. Hope that helps, thank you for watching!
@@LearnFlutterwithMe Thank you for your answer. I think the balance is right. Just add explanations for the concepts you're introducing and for questions you think newbies might ask themselves. Your style is already straight to the point, so I don't think doing that would hurt the quality of your videos
I must have viewed over 30 UA-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.
One of best tutorial ever. Its every easy to work on a single page code rather download bundle of files. Thank you so much
Straight to the point. Only the relevant info on how to use sqlite database and no fancy widgets
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 ☺
Awesome Tutorial. The best Flutter Tutorial i've seen! Keep that great work man!
Thank you, I appreciate it!
Top notch tutorial, no bs, nothing. Thank you very much. You helped out a lot in my project!
That's great! Thank you so much for watching!
this one is hell easy to understand. Been watching so much tutorial about sqlite. But this one is really easy to understand . Thanks sir
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!👍
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
Thank you so much!
@@LearnFlutterwithMe I was searching for tutorials like at least I found you. You earn subscribers not single but many
Clear Straight Quick, no matches, keep it up!!!
Thank you!
Amazing teaching. Awesome and straight forward video.
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!
Wow. I love this video and the steps. I was able to implement this with an already existing database in my assets folder.
Glad it worked for you!
Thank you very much for this tutorial. I was struggling with it for a week now.
I'm glad you were able to figure it out!
I can't thank you enough... You're the best tutor in the world!
very nice work. I like how you initialized the database only if needed
Thank you!
This channel deserve a lot! Keep itu up!
Thank you so much!
Thank you for the tutorial. It's easy enough to follow along!
like your cool and relaxed style of teaching - hope to see more flutter videos
Thank you!
@@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
@@vee-obsidian 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
thanks a lot this is even better then documentation keep the good work and make us more videos
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.
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?
you saved my entire day 😇
Thank Sir ,Super Clear Explanation with relax music
thanks for this. Keep moving this will be a great channel
thankx sir to the point vedio and so easy way and short vedio tutorial thankx sir
Deserved to be Liked and Subscribed ... Done ... Subscribed 👍
Thank you for this great and simple tutorial.👍
amazing content I do recommend for anyone who is learning
Wow, this helped me a lot. Thanks!
You're welcome!
4:37 what is it that code? this factory from map something?
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?
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 :)
Thank you! I'll see what I can do for you! Thanks for watching!
very good tutorial and explanation very good that how can do it easily
thank you and thanks for watching!
Awesome tutorial, thanks for take your time to create it
Excellent Tutorial!! Thank you so much
Neat Quick job 👍
thank you so much sir!
Thank you for watching!
Simple and right to the point, thank you so much for making this video :D
Hello. Thank you for your good teaching. Please publish a tutorial on how to add search to this list. Thanks
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
Yep! I think any fool proofing is worth the time! Thanks for sharing!
are you know how to do that? please help me
Thank you so much that was so helpful...
Thank you. Your video helped a lot.
is there an advantage in using the Future Builder way over the ListViewBuilder Way?
What an explanation, really amazing
This was very helpful, thanks a lot.
it was great sqlite tutorial thank you for this
Glad it was helpful, thanks for watching!
Thank you so much. I’ve waited a lot
You're Welcome! So glad it helped!
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?
Thanks for tutorial!!
your videos are simple and easy to understand. could you make one on drift/moor orm for sqlite.
Thank you! I'll see what I can do!
ty so much sir, very easy explained and helpful
You're welcome!
Thank you Sensei.
cool Destiny shirt bro
Thanks. Great tutorial!
Thank you!
easy to be followed
Thank you very much sir. You are awesome!
please help me, how do I do it so that if the input is empty then we can't add it to the list?
put a if function in floatingActionButton like " if (textController.text != ' ') "
pretty neat, thank you
you doing great. thank you
just simple and cool !
thank you so much this video help me
Thank you very much!
Isn't it bad practice to create a future inside of FutureBuilder?
You talk about two pevious videos - wirch onces?
Hey Kim! They are "Flutter Firebase Tutorial" ua-cam.com/video/WuYOGBEOEOo/v-deo.html
and "Flutter Widget Basics: ListView" ua-cam.com/video/2jTP9Po04ms/v-deo.html
Sorry about that!
Brooo, Hello! Can you do video Sqflite+GetX and Hive + GetX ... and with more model items ? maybe 4-5 (String, int , bool) ... ???
Thank you :)
Thank you so much! this video big help for me.
You're welcome! Glad it helped!
Thank you sir!
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?
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?
Thank you! Yes I will add it to my to-do list!
Very good. Thank you
Thanks . it is really helpful
You're welcome!
Thank you so much.
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 😀
Another great video. I was curious why you like using Android Studio rather than VS Code? Thanks.
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.
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
@@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
Thanks, subscribed. What about github-ing the code?
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
you are great!
Thanks so much
Nice Speed Coding ...
Well, I cheated. haha! I speed up the code parts in editing so y'all don't have to sit through all that!
Is there a possibility to query database (sqlite) and get a result that return from databse?
I already have a write db file, how can I use it?
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.
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!
somehow when I close my app all the data is deleted after I reopen it. Did the tutorial exactly as in the video...
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.
I solved this. Check out in my channel
very good video , btw may i know the background music ?
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!
Sir, flutter package Development tuotorial
Sir could make a flutter_slidable tutorial on the same sqlite tutorial
I sure will, I will add it to the list to do!
@@LearnFlutterwithMe yes please i need it
Great ! Respect....
One question are the factories toMap and fromMap the same as toJson and fromJson which can be generated through json_serializable?
This might explain it better than I can atm:
flutter.dev/docs/development/data-and-backend/json
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
You need to add setState to re-render the app
@@lephichung where should I add the setState? In the add button?
@@jemmytech5474 yes, in add button
Good tutorial, but I will say, simple if / else statements are much easier to read and follow than multi-line ternary operator statements
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!
so if i want to use both firebase and sqlite at the same time, possible?
yep that shouldn't be a problem!
How can I add a new table on existing .db file?
the system is adding but name is coming null ı colund't solve
The Full Source Code Button, is not working.
used this video just today and guess what, my app went unresponsive when i try adding to database, an update needed or something?
I will review it and see if I can put out an update soon! Thanks for letting me know!
this is legit.
Love the to-the-point style, love the visual presentation of the code but bro... How come you don't explain the concepts ? What the hell is a DataBaseHelper?
That's something I struggle heavily with; trying to balance explaining everything I'm doing in a clear manner while trying to keep it as simple as possible to try to prevent overwhelming those who are brand new. In this specific example, if you're talking about the Class name, it's just the name I used, you can replace "DatabaseHelper" with anything you'd like to call it. Hope that helps, thank you for watching!
@@LearnFlutterwithMe Thank you for your answer. I think the balance is right. Just add explanations for the concepts you're introducing and for questions you think newbies might ask themselves. Your style is already straight to the point, so I don't think doing that would hurt the quality of your videos