Sqflite Tutorial | Flutter plugin for SQLite | CRUD
HTML-код
- Опубликовано: 30 июл 2024
- Add Local Database support to your Flutter App using SQlite with the Flutter plugin SQFlite. Using SQFlite I'll show you how to do full CRUD (Create, Read, Update, Delete) functions with SQLite in a simple bare bones app example.
00:00 Introduction
01:40 Initial Setup
03:08 Sqflite Install
03:57 Grocery Model
04:55 DatabaseHelper Setup
07:18 READ process
09:07 CREATE process
09:49 DELETE process
10:42 UPDATE process
13:06 Bonus Styling
15:11 End
Full Source Code and transcript:
learnflutterwithme.com/sqlite
#flutter #learnflutter
Instagram:
learnflutterwithme
Stuff I use for this channel (Affiliate Links)
SanDisk 1TB SSD amzn.to/3j1U8py
Elgato Cam Link 4K amzn.to/37EyqBK
Logitech G600 Mouse amzn.to/36DYFYz
Logitech G Pro Keyboard amzn.to/3saco38
Macbook Pro M1 13" amzn.to/36GzbKc
Neewer Mic Arm amzn.to/3z7RvIm
Davinci Resolve amzn.to/3erEb9I
Adobe Photoshop Elements amzn.to/3BkPKth
I must have viewed over 30 RUclips 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.
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!👍
One of best tutorial ever. Its every easy to work on a single page code rather download bundle of files. Thank you so much
Awesome Tutorial. The best Flutter Tutorial i've seen! Keep that great work man!
Thank you, I appreciate it!
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 ☺
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!
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!
Straight to the point. Only the relevant info on how to use sqlite database and no fancy widgets
Simple and right to the point, thank you so much for making this video :D
this one is hell easy to understand. Been watching so much tutorial about sqlite. But this one is really easy to understand . Thanks sir
I can't thank you enough... You're the best tutor in the world!
Awesome tutorial, thanks for take your time to create it
Thank you for the tutorial. It's easy enough to follow along!
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
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.
Clear Straight Quick, no matches, keep it up!!!
Thank you!
thanks for this. Keep moving this will be a great channel
Excellent Tutorial!! Thank you so 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!
What an explanation, really amazing
Amazing teaching. Awesome and straight forward video.
thanks a lot this is even better then documentation keep the good work and make us more videos
This was very helpful, thanks a lot.
very nice work. I like how you initialized the database only if needed
Thank you!
Thank you for this great and simple tutorial.👍
Wow, this helped me a lot. Thanks!
You're welcome!
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!
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 that was so helpful...
Thank you. Your video helped a lot.
Thank Sir ,Super Clear Explanation with relax music
Thank you so much. I’ve waited a lot
You're Welcome! So glad it helped!
Neat Quick job 👍
This channel deserve a lot! Keep itu up!
Thank you so much!
Thank you very much sir. You are awesome!
pretty neat, thank you
Thank you very much!
amazing content I do recommend for anyone who is learning
Thank you Sensei.
you saved my entire day 😇
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
@@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
just simple and cool !
Thank you so much.
Thanks for tutorial!!
you doing great. thank you
Thank you sir!
thank you so much this video help me
Very good. Thank you
Thank you so much! this video big help for me.
You're welcome! Glad it helped!
it was great sqlite tutorial thank you for this
Glad it was helpful, thanks for watching!
Thank you :)
thank you so much sir!
Thank you for watching!
Thanks. Great tutorial!
Thank you!
ty so much sir, very easy explained and helpful
You're welcome!
thankx sir to the point vedio and so easy way and short vedio tutorial thankx sir
easy to be followed
Thanks so much
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!
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 are great!
Thanks . it is really helpful
You're welcome!
very good tutorial and explanation very good that how can do it easily
thank you and thanks for watching!
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?
Great ! Respect....
4:37 what is it that code? this factory from map something?
is there an advantage in using the Future Builder way over the ListViewBuilder Way?
Is there a possibility to query database (sqlite) and get a result that return from databse?
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?
How can I add a new table on existing .db file?
I already have a write db file, how can I use it?
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
Isn't it bad practice to create a future inside of FutureBuilder?
cool Destiny shirt bro
Brooo, Hello! Can you do video Sqflite+GetX and Hive + GetX ... and with more model items ? maybe 4-5 (String, int , bool) ... ???
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 😀
Hello. Thank you for your good teaching. Please publish a tutorial on how to add search to this list. Thanks
somehow when I close my app all the data is deleted after I reopen it. Did the tutorial exactly as in the video...
Thanks, subscribed. What about github-ing the code?
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!
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!
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
the system is adding but name is coming null ı colund't solve
cool
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!
👌👏
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!
this is legit.
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
Kudos for the excellent videos. Really appreciate the way you made the videos keeping in mind what the viewers' want - particularly fast-forwarding the typing :) !
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 != ' ') "
😍
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
so if i want to use both firebase and sqlite at the same time, possible?
yep that shouldn't be a problem!
The Full Source Code Button, is not working.
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
Sir, flutter package Development tuotorial
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
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!
You talk about two pevious videos - wirch onces?
Hey Kim! They are "Flutter Firebase Tutorial" ruclips.net/video/WuYOGBEOEOo/видео.html
and "Flutter Widget Basics: ListView" ruclips.net/video/2jTP9Po04ms/видео.html
Sorry about that!
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!