Sqflite Tutorial | Flutter plugin for SQLite

No video

Sqflite Tutorial | Flutter plugin for SQLite | CRUD

Рет қаралды 51,163

Learn Flutter with Me

Күн бұрын

Пікірлер: 164

@arpro3038 7 ай бұрын

I must have viewed over 30 KZfaq 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.

2 жыл бұрын

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 ☺

@bharathkumar-ji4if 2 жыл бұрын

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

@isho7777 Жыл бұрын

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

@ammarboro6089 3 жыл бұрын

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 3 жыл бұрын

Thank you so much!

@infotration2225 2 жыл бұрын

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

@mateusfensterseifer4553 3 жыл бұрын

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

@LearnFlutterwithMe 3 жыл бұрын

Thank you, I appreciate it!

@averageprogrammingenjoyer2059 Жыл бұрын

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

@LearnFlutterwithMe Жыл бұрын

That's great! Thank you so much for watching!

@gubukbonsai6005 3 жыл бұрын

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

@LearnFlutterwithMe 3 жыл бұрын

Thank you!

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

@caiocamargoantonio Жыл бұрын

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.

@ikmal_is1773 2 жыл бұрын

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

@nabil.hamawi 2 жыл бұрын

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

@alberthajek9067 2 жыл бұрын

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!

@mageshkanna Жыл бұрын

you saved my entire day 😇

@LuisOtavioZimmermann Жыл бұрын

Amazing teaching. Awesome and straight forward video.

@faizanchaudhry8754 9 ай бұрын

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

@MithunDuttaIL 2 жыл бұрын

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

@LearnFlutterwithMe 2 жыл бұрын

I'm glad you were able to figure it out!

@gumdum6764 3 жыл бұрын

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

@LearnFlutterwithMe 3 жыл бұрын

Thank you!

@obinnaelviso Жыл бұрын

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

@LearnFlutterwithMe Жыл бұрын

Glad it worked for you!

@hasans7370 2 жыл бұрын

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 2 жыл бұрын

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

@romeroo98 3 жыл бұрын

This channel deserve a lot! Keep itu up!

@LearnFlutterwithMe 3 жыл бұрын

Thank you so much!

@andrewshenouda3604 2 жыл бұрын

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?

@user-ec1ch4sx3r Жыл бұрын

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

@jihedbouchnak Жыл бұрын

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

@sailinhtut5961 2 жыл бұрын

Thank Sir ,Super Clear Explanation with relax music

@ipott8212 3 жыл бұрын

Wow, this helped me a lot. Thanks!

@LearnFlutterwithMe 3 жыл бұрын

You're welcome!

@husseinj7505 Жыл бұрын

Thank you for this great and simple tutorial.👍

@seankiong Жыл бұрын

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?

@ashishu8888 2 жыл бұрын

thank you so much sir!

@LearnFlutterwithMe 2 жыл бұрын

Thank you for watching!

@antoniomanoel2873 2 жыл бұрын

amazing content I do recommend for anyone who is learning

@vaishnavinagrale5429 Жыл бұрын

Thank you so much that was so helpful...

@amrhaithem7064 2 жыл бұрын

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

@sriram4738 Жыл бұрын

easy to be followed

@vijaybabaria3253 3 жыл бұрын

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

@LearnFlutterwithMe 3 жыл бұрын

Thank you!

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

@diamondeagle173 Жыл бұрын

Thank you Sensei.

@Hidden_traveler93 2 жыл бұрын

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

@LearnFlutterwithMe 2 жыл бұрын

thank you and thanks for watching!

@jae7593 3 жыл бұрын

Thank you :)

@gethsun1 Жыл бұрын

Neat Quick job 👍

@BrunaAraujoPinheiro 2 жыл бұрын

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

@ohenro19 2 жыл бұрын

Excellent Tutorial!! Thank you so much

@javadmahmoodi2469 Жыл бұрын

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

@bobbysmith8588 2 жыл бұрын

Awesome tutorial, thanks for take your time to create it

@munaretto_ Жыл бұрын

Thank you very much!

@shihabhossain4190 2 жыл бұрын

Thank you. Your video helped a lot.

@muradhamed2960 6 ай бұрын

cool Destiny shirt bro

@earthrelated 2 жыл бұрын

Thank you sir!

@abdelrahmananwar885 Жыл бұрын

pretty neat, thank you

@ankitchawla8487 2 жыл бұрын

This was very helpful, thanks a lot.

@dhruvinprajapati4345 2 жыл бұрын

thank you so much this video help me

@jemmytech5474 3 жыл бұрын

Thank you so much. I’ve waited a lot

@LearnFlutterwithMe 3 жыл бұрын

You're Welcome! So glad it helped!

@iasror 2 жыл бұрын

you doing great. thank you

@mruduladdipalli5417 3 жыл бұрын

What an explanation, really amazing

@aunghtet3636 2 жыл бұрын

Thank you very much sir. You are awesome!

@angelopaligutan1665 2 жыл бұрын

Thank you so much.

@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 2 жыл бұрын

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

@Revamiko 2 жыл бұрын

are you know how to do that? please help me

@BBFTW36 2 жыл бұрын

ty so much sir, very easy explained and helpful

@LearnFlutterwithMe 2 жыл бұрын

You're welcome!

@d4tto92 2 жыл бұрын

it was great sqlite tutorial thank you for this

@LearnFlutterwithMe 2 жыл бұрын

Glad it was helpful, thanks for watching!

@monobrezel2647 2 жыл бұрын

just simple and cool !

@szyszak9424 2 жыл бұрын

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

@chandrasekarchan9386 2 жыл бұрын

you are great!

@KK-lr4vx 2 жыл бұрын

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

@LearnFlutterwithMe 2 жыл бұрын

Thank you! I'll see what I can do!

@bongssang 3 жыл бұрын

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

@LearnFlutterwithMe 3 жыл бұрын

You're welcome! Glad it helped!

@luoichannel Жыл бұрын

Thanks so much

@abdelrahmananwar885 Жыл бұрын

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

@luisnepas3326 2 жыл бұрын

Thanks. Great tutorial!

@LearnFlutterwithMe 2 жыл бұрын

Thank you!

@Revamiko 2 жыл бұрын

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 2 жыл бұрын

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

@edu28811 2 жыл бұрын

Very good. Thank you

@kbyo2006 2 жыл бұрын

Thanks for tutorial!!

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

@nilsirl Жыл бұрын

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

@davelogan77 2 жыл бұрын

this is legit.

@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 3 жыл бұрын

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 3 жыл бұрын

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

@faizulla5838 2 жыл бұрын

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

@TheMRTIMBUK2 2 жыл бұрын

Nice Speed Coding ...

@LearnFlutterwithMe 2 жыл бұрын

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

@usama_khalid 3 жыл бұрын

Thanks . it is really helpful

@LearnFlutterwithMe 3 жыл бұрын

You're welcome!

@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

@sreejapasupuleti5384 2 жыл бұрын

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?

@DavidFuto 2 жыл бұрын

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

@halilmertdeveli3846 2 жыл бұрын

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

@ricgor3441 2 жыл бұрын

The Full Source Code Button, is not working.

@sportKO12 3 жыл бұрын

Great ! Respect....

@sbasalan 2 жыл бұрын

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

@noblenetdk 2 жыл бұрын

You talk about two pevious videos - wirch onces?

@LearnFlutterwithMe 2 жыл бұрын

Hey Kim! They are "Flutter Firebase Tutorial" kzfaq.info/get/bejne/jduJgqpzqrWpf6M.html and "Flutter Widget Basics: ListView" kzfaq.info/get/bejne/aNCEg5yB1JaYnac.html Sorry about that!

@davidowens9597 3 жыл бұрын

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

@LearnFlutterwithMe 3 жыл бұрын

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 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 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 2 жыл бұрын

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

@jemmytech5474 2 жыл бұрын

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 2 жыл бұрын

I solved this. Check out in my channel

@jemmytech5474 3 жыл бұрын

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 2 жыл бұрын

You need to add setState to re-render the app

@jemmytech5474 2 жыл бұрын

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

@lephichung 2 жыл бұрын

@@jemmytech5474 yes, in add button

@fleshpaghetti 3 жыл бұрын

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

@Aboudimassi Жыл бұрын

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 😀

@kamalCode 3 жыл бұрын

Sir, flutter package Development tuotorial

@zhujinlu6022 2 жыл бұрын

cool

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

@abdullaaeham 2 жыл бұрын

👌👏

@mbithi_ke Жыл бұрын

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

@LearnFlutterwithMe Жыл бұрын

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

@dsdridi5362 2 жыл бұрын

😍

@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 3 жыл бұрын

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

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

@huynhphuso 5 ай бұрын

where file groceries.txt ?

@sathiesha 2 жыл бұрын

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 :) !