Flutter SQFLite tutorial: CRUD Operation. Perform Insert, Fetch, Update and Delete Operation #4.7

Learn how to create an SQLite database in Flutter using Raw SQL statement and perform Insert, Fetch, Update and Delete operation.

.
Please donate and support my work
(If you think my free tutorials are better than paid ones :)

Free Programming courses:

Free Flutter course:

Free Android courses:

More free programming courses:

Check out my website:

Let's get in touch! [Sriyank Siddhartha]

---- Thank you for your love and support ----

[adri_eu]

Thanks for your great tutorials.
In your database helper class there is an error. The database directory on a real iPhone cannot be found. To solve this:
- import package:path/path.dart
- define your path as: String path = join(directory.path, 'databasename.db');

[aakashshrestha]

your video is really awesome i am just getting the whole concept from your video, a massive thank-you :)

[juandalisay]

1:18 Create DatabaseHelper class
1:33 Create 'singleton' to store the DatabaseHelper instance
1:51 Define factory constructor to return the value of the DatabaseHelper instance
2:22 Turn DatabaseHelper on if it is off
2:40 Define 'singleton' database object and all columns with table name
3:00 Create the Database
3:30 Initialize the Database and set path for DB for opening
5:03 Set getters
5:30 Summary of method chaining
6:00 Define Fetch to get Note object from DB using rawQuery or query
8:00 Querying the db returns a Future MAP because of SQFlite
8:20 Insert but convert data to MAP first
8:50 Update with where to update
9:15 Delete using rawDelete
9:30 Get count of objects thru firstIntValue(x)

[skysea]

been waiting for this...tnx and more power..

[manuelleonardovargastapia]

Thanks! Yout explanations are very clear and concise. Great work.

I have to ask, could you make a video about managing multiple tables? I mean, how can we manipulate tables that relates each other? For example, what happens if you want to asociate the notes model with the currently logged in user?

[lankahelth]

your tutorials are very good and understandeable, please upload this video again in up to date, thank you.

[ayjahanashirova]

Like man. finally I could solve my issue. thanks.

[mufidrazmin]

Great videos.
It would be great if you guys create a video where multiple tables are used and relations between them are showcased.
Thanks in advance.

[palakurthisriraj-yearb.te]

Wowww..Thats a great vedio..thanks a lot...

[bojidarkamenski]

Hello, thank you for your tutorials they are so good and helpful, thank you for your work.
Can I ask you guys what does this.etc mean, because I can't find it in the previous tutorials and I think this is importnant to know. Thank you and have a nice day!!!

[mrutyunjayagiri]

A great procedural video.
I'm getting an error.

NoSuchMethodError: Class 'MethodChannel' has no instance method 'invokeMethod' with matching arguments.
Tried calling:
E/flutter ( 5924): Found: invokeMethod(String, [dynamic]) => Future<dynamic> .

[Linhcua]

In case there are more than 1 table in the database (>=2), then how we will organize the DatabaseHelper class or!? I mean, if there are many tables, the DatabaseHelper class can be very long file, so any way to organize it !?

[aissoumonder]

in the case I want to create many tables should I create DBHelper file for each table or can I add it in the same file ?

[raul]

-And how strong, dart represents data types?


Future<List<Map<String, dynamic>>> getNoteMapList()


-OMG..

[rikhiljain]

Hello thanks for the great tutorial... as I am new to flutter I got idea about sqlite database....

BUT

I have one query.
I have prepared database with 500+ entries and I have to do CRUD operation.

So where I should put my data in flutter app so it will work on both iOS and Android... and how to set path of database... in my case..

A word of reply will be highly appreciated.

Thanks sir.

[Hasan-vuhn]

Please make a video about how to add backup & restore option n sql app....
I will need. this. please help me

[RajA-mecl]

Settings for horizontal lines between codes like yours?

[lavakumar_techie]

Hi Sir,
How to pass table name from UI to database helper. So that I can create dynamic table name
is it possible to create like that sir.
Please explain how to approach

[VinitDabhi]

Can I use firebase database with flutter? And if yes then which is best?

[PriyanshuRaj-octk]

Why did you create the DatabaseHelper singleton object?