Flutter Tutorial - SQL Database Storage Using Sqlite & Sqflite CRUD | Android & iOS

Persist data with Flutter's Sqflite & Flutter's Sqlite Database locally on your Android or iOS device by using Raw SQL statements and perform Sqflite CRUD Operations Create, Read, Update and Delete.

SUBSCRIBE HERE

SUPPORT & SPONSOR ME

RESOURCES

TIMELINE
0:00 Introduction Database Storage Sqlite & Sqflite
0:39 When To Use Database?
1:04 Which To Use Database? SQL VS NoSQL
1:24 Sqflite CRUD Operations
1:56 Setup Sqflite
2:10 Open Sqflite Database & Initialize Database
4:34 Create Database Table
8:22 Add Sqflite Multiple Tables
8:34 Insert SQL Statement / Sqflite Create Operation
13:21 Query SQL Statement / Sqflite Read Operation
18:39 Query All SQL Statement / Sqflite Read All Operation
20:11 Update SQL Statement / Sqflite Update Operation
21:26 Delete SQL Statement / Sqflite Delete Operation
21:54 Create Notes App UI With Sqflite CRUD

SHARE | SUBSCRIBE | LIKE FOR MORE VIDEOS LIKE THIS

*********

SOCIAL MEDIA: Follow Us :-)

LEARN MORE

PLAYLISTS

CREDITS

#Flutter #Tutorial #JohannesMilke

LIKE & SHARE & ACTIVATE THE BELL
Thanks For Watching :-)

[shivlochawala]

Clear voice with slow and perfect explanation. Keep it up. Thank you for such a nice and awesome video.

[networktimba]

So glad I came across your content, well delivered and well executed delivery. Best intro to sqlfite I have found. Please know that your efforts are appreciated!

[satishraizada]

Wonderful tutorial and covered everything in so details i managed to implement same into my project in no time, kudo to you :)

[maxr]

6:13 A very elegant way of parametrizing your SQL typing and variables. Never seen that before but really enjoying it!

[d-apps]

Just a tip, inside the _initDB method you can just use:

Insted of:
final dbPath = await getDatabasesPath();
final path = join(dbPath, filePath);

You can put:
Future<Database> _initDB(String filePath) async {
return await openDatabase(filePath, version: 1);
}

because openDatabase first parameter now gets the defaul database path automatically, just pass the database name "notes.db"

[TechyChung]

Thank you so much! You explained so perfectly! Can't find this perfect content explanation with slides anywhere!!
Hat's off to you for your efforts!

[danishshaikh]

It's a really helpful video and literally, I support you in my country with my friends and colleagues you taught with clear and easy steps.
Love From PAKISTAN

[snaxman]

Thank you SO MUCH for this tutorial!!! It is extremely helpful, with clear and easy steps to follow. Please continue posting such tutorials!! :)

[jonathanmunday]

At 8:19 what must you put after onUpgrade: ? (after the colon: ) if you add new fields to your Create Table

[nimacode]

Just got Started with flutter and these are good quality content keep up the good work!!

[SoulssWeaver]

Best flutter tutorial! This is the basis of all apps

[amgedgamer]

thanks @Johannes for your efforts
Please give us tutorial sqflit with multiple tables with foreign key

[mohammedasha]

hello dear,
Can you explain in video how use search on data with sqf 🌻

[heroliper]

Thank you so much! :)
This tutorial was reaally helpful and easy to follow,
have a great day!

[pcoderajap]

hie am total new to flutter ..ur tutorial is he best i found out there...

[drooner]

It all looks so easy when you do it :-D Thanks for another great video.

[chyo]

thank you so much !
I learned how to build my app with sqflite from this tutorial

[achinhchin]

Thank you very much, everything you teach is very helpful to me.

[TechyChung]

You are amazing! best video and explained in the best way ever possible!

[mugume]

A very beautiful and excellent tutorial. Thank you @Johannes