Flutter Local Database Using sqfLite

Hey Guys, in this Flutter video I will show you how to create a local database in Flutter using sqflite library which uses SQLite database and use it to save and retrieve data in addition to deletion of data. You will also learn how to retrieve data as models and a list of models.
Learn how to use local database storage step by step in Flutter.
For more Flutter content be sure to subscribe to the channel and turn on your notifications.
Check out Flutter how-to videos:
• Flutter Google Ads
Check out my Flutter tutorial to become a Flutter hero: • Flutter Tutorial for B...
Links:
Don't click this: bit.ly/3dkJUNB
sqfLite library: pub.dev/packag...
------------ Content of this video ------------
00:00 Demo of the finished app
00:59 Setting up our project
01:31 Adding the model
04:05 Creating the database helper
07:44 Implementing Insert
09:20 Implementing update
10:50 Implementing delete
11:16 Implementing retrieve list of models
13:14 Editing the UI
19:35 Testing the app
#flutter #flutter_local_database #flutter_local_storage #flutter_sqflite #flutter_sqlite

[@codingorbit]

Hey guys, The source code of this video can be found on GitHub here github.com/yehya-qassim/local_database.git

[@BCmodo]

thank you, great tutorial.......have you got some paid tutorials?

[@moorthikin7907]

I'm searching lots of tutorials. most of the tutorials are time consuming and I never understanding anything from those videos. Finally I found You. Simple and Great!🙌😶‍🌫

[@codingorbit]

Happy to hear that!

[@kamalsayyid6866]

This is very nice and easy to follow. Also Providing the github link was thoughtful of you. Keep up the Good work

[@codingorbit]

Thank you! Glad you liked it

[@adoubydurand6710]

simple and clear, thank you

[@codingorbit]

My pleasure!

[@lucascamelo3079]

I'm with a problem in my app: When i try to open a database in any folder other than the documents folder, it's gives me error 14. I already gave read/write permission in the android manifest.

[@SafaaBoucherit]

Very helpful tutorial, thank you

[@Grinwa]

That's really good man 😮 keep it up

[@codingorbit]

Thank you!

[@Sathya_Yadav]

wow its amazing explanation bro super tq

[@codingorbit]

Welcome 😊

[@bigjoe766]

Amazing. Thank you 🙏

[@mohandidrees7463]

اول ما فتت على الفيديوا قلت هاد عربي any way thank you for this lecture

[@codingorbit]

Haha you're right, most welcome!

[@kopijava237]

thank for sharing ,, i will download your repo ,,,,

[@codingorbit]

Most welcome!

[@warka9494]

Keep going with the good content brother 👍👍

[@codingorbit]

Thank you!

[@safeerhussain7371]

keep it up bro, very good explaination.

[@codingorbit]

Thank you

[@alaahasan847]

thanx, so clear

[@codingorbit]

Most welcome!

[@NirdeshPokhrel]

Awesome, man.

[@codingorbit]

Thank you!

[@GabrielTorresTakahashi]

What if I need to retrieve data from multiple tables?

[@codingorbit]

I haven't tried that but I believe you can write sql query yourself try writing one and let me know if it works!

[@rabbihossen9023]

thank you 🧡please! add Image Picker & Color Picker here. Please ❤️

[@codingorbit]

I do have a video for picking images! Spoiler alert it also has quality compression lol 😅

[@saadibnrouf7941]

Very helpful

[@user-ic6js9dh2u]

thank you

[@codingorbit]

You're welcome

[@Bharath_koli]

Tq bro 💙

[@codingorbit]

You are very welcome!

[@wenews5147]

As soon as possible thanks

[@codingorbit]

Soon hopefully

[@wenews5147]

@@codingorbit when sir any Gus

[@wenews5147]

@@codingorbit I need sir

[@devaref2461]

Sir can you mack video to provider state management

[@codingorbit]

Yeah hopefully soon :)

[@BrYarDJ]

you can make video to how use database sqflite in asessts?

[@codingorbit]

What do you mean using sqflite in assets?

[@BrYarDJ]

@@codingorbit yes, i mean if have database how use in flutter

[@codingorbit]

Sqflite is a local database. Watch the video it will help you to create a local database

[@wenews5147]

Sir please upload the video of audio recorder and audio player in flutter

[@codingorbit]

Yeah maybe soon.

[@subrotobasak]

Great

[@codingorbit]

Thank you

[@subrotobasak]

@@codingorbit Please Upload the Source Code. I'm getting some issues.

[@codingorbit]

I will very soon.

[@subrotobasak]

@@codingorbit ok 🙂

[@codingorbit]

@@subrotobasak Its pinned now :)

[@pyaesonehan19]

[@chenlong7607]

Hello, I am a new flutter learner through your video and I encounter error the text is disappear after key in and the RenderFlex overflowed. Please help me, appreciate your help, thank you. ════════ Exception caught by rendering library ═════════════════════════════════ The following assertion was thrown during layout: A RenderFlex overflowed by 37 pixels on the bottom. W/RemoteInputConnectionImpl(10655):getSurroundingText on inactive InputConnection W/RemoteInputConnectionImpl(10655): getTextBeforeCursor on inactive InputConnection W/RemoteInputConnectionImpl(10655): getSurroundingText on inactive InputConnection

[@codingorbit]

That is a render file error which is thrown when a widget needs more space but there is none available. this can be solved using different ways based on the widget you are facing this error with.