Flutter Sqflite | Easiest Tutorial | Flutter Tutorial for beginners

The most awaited and most requested by the viewers on the channel is here.❤️ . In this video we will learn the implementation of Sqflite in the most simplest ways possible.Learn to make a local database for your mobile application.
We will discuss about the CRUD operations like create , insert, update and delete commands.For any queries, suggestions or feedback feel free to write down in the comments.
___________________________________________________
For more tutorials subscribe to the channel :
www.youtube.co...
COVID-19 Mobile app complete tutorial -
• COVID 19 App | Flutter...
Flutter 21 Days Challenge:
• Flutter 21 Day Challenge
For other videos on Flutter:
• Flutter Tutorial for B...
Do like and follow 'The Growing Developer' on other social platforms as well. Below are the links -
Facebook link - / thegrowingdeveloper
Instagram Page link - / thegrowingdeveloper
LinkedIn Profile - / singh-saheb

[@thelitterateman]

Highly recommended! Simplified with great explanation, while holding on the basics. Worth the 40 minutes in every sense.

[@TheGrowingDeveloper]

Glad to hear that 😊 thanks ❤️

[@herseem]

One of the most critical things you did here was explain WHY this and that. That was so important, so thank you for that

[@bensosfrequents]

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

[@dawidmilitowski8801]

Step by step, no unnecessary complexities and fancy displays, Flutter team can learn from you when creating their tutorials!

[@TheGrowingDeveloper]

Thank you so much for the appreciation!!! Keep supporting!

[@ntandotshongweni5240]

dude, this is the best tutorial I found to understand sqflite int 2024. Simple and straight forward.

[@glrbrasil]

This is the best tutorial on SQLite I've seen so far. Amazing!

[@nagukr]

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.

[@TheGrowingDeveloper]

Glad it helped!

[@bre3eze983]

dude , this is the best video to understand Sqflite Crud , thank you

[@TheGrowingDeveloper]

Glad it helped!

[@vinamrasaxena7313]

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.

[@TheGrowingDeveloper]

Glad it helped😊

[@queensley9006]

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

[@JaspreetSingh-fo2qe]

Exactly what I was looking for! BTW you were 100% correct in saying that other channels have made it complicated.

[@faizc9984]

Excellent tutorial Man! Honestly I tried lot of KZbin videos and other articles about database, but none of them was this much simple. Great work. Subscribed even before completing the video !!

[@TheGrowingDeveloper]

Thanks 😊♥️

[@theimpulson]

The very best I could find on the internet. Nicely explained each and every term and the logic behind them.

[@TheGrowingDeveloper]

Glad it helped! 😊

[@alfiopapotto8890]

very good video, thanks for all the great information

[@PaulMcKillop]

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!

[@TheGrowingDeveloper]

Glad you enjoyed it!

[@kenducs14]

Finally a begginers tutorial, All i see on youtube is for the advanced ones , Thank You so much

[@TheGrowingDeveloper]

Glad it was helpful!

[@danieldey]

the comments are not lying, this is really a good video

[@TheGrowingDeveloper]

Glad you think so !! ❤️

[@omkarshinde2740]

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

[@TheGrowingDeveloper]

Glad it helped 😊

[@esntlaman3433]

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

[@vlycie6628]

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.

[@TheGrowingDeveloper]

Thanks 😊❤️

[@Newburyk]

Great video, made the concept very simple and easy to understand. Thank you!

[@TheGrowingDeveloper]

Glad it helped! 😊

[@abhishekmahajan3782]

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

[@TheGrowingDeveloper]

Glad it helped!

[@averageprogrammingenjoyer2059]

Just wanna say. Great tutorial overall! Really simple straight to business.

[@umakanthp8415]

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.

[@TheGrowingDeveloper]

Thank you so much 😊 , I'll try my best to bring these concepts in near future for sure!

[@MohammadAli-vj4sr]

Love from ♥️ .. tring to understand since last 1 year but at last i can understand it..

[@TheGrowingDeveloper]

Glad it was helpful

[@shakilahmedkhan1161]

Great teaching skills. Love watching this tutorial. You clear my concept of sqflite basic. Thank you very much.

[@TheGrowingDeveloper]

Great to hear!

[@hananeca4773]

this is a greate and simplified tuto thank you so much sir

[@TheGrowingDeveloper]

Glad it was helpful!

[@dashaxedit]

Very clear to me. Thanks a lot

[@arshneetkathuria1757]

A great tutorial with precise and simple explanation. ..appreciation for your efforts!!

[@TheGrowingDeveloper]

Thankyou so much 😇

[@sanjayadhikari1276]

In _onCreate method (AUTO INCREMENT) is required Future _onCreate(Database db, int version) async { db.execute(''' CREATE TABLE $_tableName ($columnId INTEGER PRIMARY KEY AUTOINCREMENT, $columnName TEXT NOT NULL) '''); }

[@TheGrowingDeveloper]

AUTOINCREMENT was not needed at that time, don't know if it is mandatory now. Btw thanks for the update.

[@furkanfrk5179]

Best video in KZbin about this shared preferences. Clean and nice 👌

[@ottoslampenladen9914]

Thank you sir, this tutorial helped me a lot.

[@TheGrowingDeveloper]

Glad to hear that

[@rajausama2127]

Bro Give me a hug,,, you are awesome ...Must watch this video to clear your concept

[@TheGrowingDeveloper]

Thank you so much 😀

[@oussamaaniba392]

First sqflite tutorial search and I already got it, thanks a lot man

[@TheGrowingDeveloper]

Happy to hear that!

[@_mantis]

I really learned a lot from this tutorial. Your efforts in making these videos are very much appreciated!

[@TheGrowingDeveloper]

Glad you like them!

[@amg_academy2001]

you are awesome .. i don't know how can i thank you .. really thx so much dude .. your fans from egypt

[@TheGrowingDeveloper]

Happy to help!

[@K19-fromfuture]

great videos,where have you been these days 😅

[@davidhadwin3566]

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.

[@usmanasad7367]

nicely explained, Helped alot in my project.

[@nullcodeer]

Thanks Sir Love from Bangladesh

[@chippandenga6722]

This is the best video with the best basic explanations to the topic. Thank you so much. I loved it.

[@TheGrowingDeveloper]

Glad it helped 😊

[@harshgupta6305]

Great Tutorial with Simple Explanation...!! Loved it

[@TheGrowingDeveloper]

Thanks a lot 😊

[@hardiklakhalani6268]

HELPED ME A LOT !!! Big THANKS

[@TheGrowingDeveloper]

Glad it helped!

[@schmoppel4899]

Awesome video! Very simple, clear and good starting point for the topic!

[@TheGrowingDeveloper]

Much appreciated!

[@programmingarmy]

thank you so much sir , thank u Indian people .

[@TheGrowingDeveloper]

Glad it helped!

[@msharibahmed]

Very simple and understanding. Thank you for your efforts.

[@TheGrowingDeveloper]

Glad it helped 😊

[@RetselisitsoeMoabi]

Great work. very easy to follow and you explain very clearly.

[@abilovestotrade]

Just found your channel, this video is awesome, subscribed, thank you

[@TheGrowingDeveloper]

Awesome, thank you!

[@queenpds3414]

Thanks man, so clear, from Indonesian

[@TheGrowingDeveloper]

You're welcome ☺️

[@amg_academy2001]

again i want to say .. you are awesome .. im so happy .. thx dude

[@TheGrowingDeveloper]

Glad to hear that

[@nandhinib1262]

Really too nice...helpful need more videos about flutter...

[@TheGrowingDeveloper]

Will upload soon

[@mohdaamir5979]

Really great video for covering basics. Thanks!!!

[@TheGrowingDeveloper]

Thanks 😊

[@raghav042]

You taught it in very simple way :)

[@mzeiger100]

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?

[@thotinh-ln4dj]

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

[@thalapathyyugamofficial1970]

Thank you so much for this tutorial

[@TheGrowingDeveloper]

Most welcome 😊

[@uxruslan]

Thank u so much for your efforts. Learnt a lot from you

[@TheGrowingDeveloper]

Glad to hear that

[@ryancarloful]

Great tutorial!!! Keep up the good work!

[@TheGrowingDeveloper]

Thank you! Cheers!

[@v.nsudeep7042]

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.

[@domontowicz]

Please, show how to retrieve BLOB image data (not String) from existing SQLite database with sqflite in Flutter, can't find it anywhere

[@TheGrowingDeveloper]

Soon!

[@amansatvilkar2093]

Great explanation.... Thanx ❤❤❤❤❤

[@rishi2220]

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?

[@rizkyfauzi1275]

Really useful, thanks for helped me!

[@TheGrowingDeveloper]

Great

[@AHMADALI-kh5ok]

Simplified explanation , very helpful tutorial thanks

[@TheGrowingDeveloper]

Glad it was helpful!

[@tkhroH2]

i don't follow how with the final table name can the insert, update etc be relevant to all created tables

[@TheGrowingDeveloper]

We are executing all the operations on the same table

[@ktahir000]

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.

[@TheGrowingDeveloper]

Soon !

[@bijendernagar15]

Thank you so much sir your content more better than udemy. again thank you to provide free content. subscribed in first watch

[@TheGrowingDeveloper]

You are most welcome

[@harshitbhargava]

This video helps me a lot and the explanation that you gave in this tutorial is very easy to understand

[@TheGrowingDeveloper]

Glad it helped 😊♥️

[@imaadthouheed7694]

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

[@codewa7605]

best video of the month, still valid as of today

[@TheGrowingDeveloper]

Glad it helped!!

[@dalestewart]

Another Excellent tutorial. Perhaps make a video on stored procedures and triggers. Thanks

[@TheGrowingDeveloper]

Sure 😊

[@RitikJr]

how to display this data on the screen without datatable widget? Can you please make a video on it.

[@TheGrowingDeveloper]

You can watch my Api video where i explained parsing data and showing it on screen

[@keidev7717]

GREAT TUTORIAL! THANK YOU FOR YOUR EXPLANATION. ITS SO CLEAR. SUBSCRIBED, RING BELL!

[@TheGrowingDeveloper]

Thanks for the sub!

[@abhinkrishnaka1206]

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 🔔👍

[@TheGrowingDeveloper]

Thank you so much 😀

[@jijeeshpadmanabhan350]

you made it so simple even though it is difficult to follow.

[@danniarrezafirdausy2538]

Bruh, it is as simple as you said! Really worth while

[@TheGrowingDeveloper]

Thanks!

[@daniels5690]

Damn...thank you. I hope your yt channel will grow!

[@TheGrowingDeveloper]

I hope so too 😊 Keep Supporting

[@shahbazhusain8612]

Even after using db.execute, I am getting no such table error.

[@TheGrowingDeveloper]

Try removing the app from device and reinstall

[@shahbazhusain8612]

@@TheGrowingDeveloper it worked.. Thanks!

[@TheGrowingDeveloper]

Great 😊

[@ashishrao3069]

@@TheGrowingDeveloper I am using emulator and this still did not work for me any suggestions?

[@TheGrowingDeveloper]

Any changes in create table command requires complete app reinstallation

[@saisreekarsesham5912]

One of the best and clearest explanation 🙏 keep it up thank you Subscribed😉

[@TheGrowingDeveloper]

Thankyou so much 😊

[@MdSiam-kw5ox]

WOW!! Thanks a lot, man. Many Many Many Thaks for the video. 😀

[@TheGrowingDeveloper]

Glad it helped!

[@melozzoreacts]

Amazing. Thank you so much.

[@TheGrowingDeveloper]

😊😊

[@waqasashraf1984]

Easily implemented as explained. Great work.

[@TheGrowingDeveloper]

Glad it was helpful!

[@adventureshop]

really good tutorial! Thanks :)

[@TheGrowingDeveloper]

✌️❤️

[@jpvSoccer]

thank you so much :)

[@anja8082]

Thank you so much fot this video. This helped me a lot.

[@TheGrowingDeveloper]

Glad it helped!

[@ziadismail5952]

Awesome , Great Tutorial with Simple Explanation ,,,, Thanks

[@TheGrowingDeveloper]

Glad it was helpful!

[@BrYarDJ]

thanks my brother, thanks for support.

[@TheGrowingDeveloper]

😊♥️

[@mettaman9169]

Very good tutorial! I'm happy to find it. My only issue now is that with Null Safety, I'm having trouble with database initialization within the class. Any updates for Null Safety?

[@TheGrowingDeveloper]

Yes I'll cover the Null safety concept soon so that there are no more doubts ever!!!

[@SinanSade]

Thank you so much.it was a very good explanation.

[@TheGrowingDeveloper]

Glad it was helpful!

[@bonatuamanihuruk5891]

thanks man

[@TheGrowingDeveloper]

You're welcome ☺️

[@daumienebi]

Hi, I'm always getting 'Instance of [insert table name]' instead of the data saved to the specific row in the database

[@MankamalSingh]

What database would you recommend for a match app along with chat, cloud Firebase (being the latest) or any other db such as sqflite?

[@TheGrowingDeveloper]

Firebase

[@rushiprojects4852]

Thank you

[@TheGrowingDeveloper]

Glad to hear that!

[@AbdullahHattab]

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

[@souravmenonvkp7538]

E/SQLiteLog(21804): (1) near "Number": syntax error in "INSERT INTO myTable (Customer, Customer_Name, Contact Number, Empty Barrel, location Empty Barrel) VALUES (?, ?, ?, ?, ?)" sir please help me with this error

[@TheGrowingDeveloper]

Your column name cannot have spaces in between!

[@shrirangab8848]

This helped a lot!! saved my day!!

[@TheGrowingDeveloper]

Glad it helped!

[@supriyomaji3697]

Thank you for such a nice tutorial. Can you explain how to do search operation or in other words filter the query output?

[@TheGrowingDeveloper]

Great suggestion! Noted!

[@abdulrazaqoladapo5237]

how do i insert the query list data in a listview.builder(). and display in the ui

[@TheGrowingDeveloper]

You can wrap it with FutureBuilder!

[@abdulrazaqoladapo5237]

@@TheGrowingDeveloper thanks. already i have implemented it

[@thesomnathsantra]

Great work. So easy to understand video. Please create a tutorial on syncing data from sqlite to server database with api in flutter.

[@TheGrowingDeveloper]

Thanks. Will try to implement that soon 😊

[@MohsinKhan-lu6kc]

Thank you for such quality content ❤

[@TheGrowingDeveloper]

Glad it was helpful!