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

[@HeyFlutter]

👉Join 12 Week Flutter Training: heyflutter.com 👉Join the WhatsApp Channel to get the latest news about Flutter & HeyFlutter: whatsapp.com/channel/0029VaDNCZtC1Fu8nL2vmw3f Source Code: github.com/JohannesMilke/sqflite_database_example Shared Preferences Load & Store Data Tutorial: kzbin.info/www/bejne/qauynZ9-iZaGbbs Shared Preferences II Persist JSON Data Tutorial: kzbin.info/www/bejne/Y2SVeXyph8tlbNE Todo App From Scratch Tutorial: kzbin.info/www/bejne/oX-cipmaacuoZpY Firebase CRUD Tutorial: kzbin.info/www/bejne/e4eVdayogLSkqLs Secure Storage Tutorial: kzbin.info/www/bejne/haLLo6uhlMtkiKc Search App Bar & Search Delegate Tutorial: kzbin.info/www/bejne/iJKkdHStq79pZ6c Crop & Save Images Tutorial: kzbin.info/www/bejne/ponFc4eAqZyZqK8 Store Image Tutorial: kzbin.info/www/bejne/gHWnoIFoia2qq8k Selectable DataTable Tutorial: kzbin.info/www/bejne/founXmOwnNWol80 Deploy Flutter Web App Tutorial: kzbin.info/www/bejne/rnvSaICnqMpsbJI Create Invoice PDF Document Tutorial: kzbin.info/www/bejne/sJCYqZ6eetCWa7s Google SignIn Tutorial: kzbin.info/www/bejne/pZi6aWaufLZ6isk Email Sign In Tutorial: kzbin.info/www/bejne/qJ-rcnyko892o68 App Internationalization Tutorial: kzbin.info/www/bejne/kKiXfKKlp7urnck Migrate App To Null Safety Tutorial: kzbin.info/www/bejne/fX3RgqOefc5keLs Null Safety In 5 Minutes Tutorial: kzbin.info/www/bejne/h5C6naKDg7CCobc Autofill Services Tutorial: kzbin.info/www/bejne/rGm3ZZmkp7Z2nJI

[@shivlochawala2562]

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

[@network911timba]

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!

[@dhillonj75]

@@HeyFlutter can you pleasemake a video on how to add and use excel in flutter . For Eg a Drop down where we select first name of user and Last name is retreived from data in excel

[@erenkaraboga8570]

Best flutter tutorial channel in English

[@d-apps2699]

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 _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"

[@d-apps2699]

@@HeyFlutter You are welcome, sexy voice.

[@anupamshukla8799]

how we find the our db path where is this located

[@danishshaikh1790]

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

[@maxr1112]

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

[@HeyFlutter]

Thanks, Max R! 🙂

[@maxr1112]

@@HeyFlutter You got yourself a new subscriber!

[@SoulssWeaver]

Best flutter tutorial! This is the basis of all apps

[@HeyFlutter]

Thank you, John! 🙂

[@satishraizada2850]

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

[@nimacode]

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

[@omarattiaelserafy2090]

I really like your channel, it's the best I've ever seen so far

[@HeyFlutter]

Glad to hear that, Thank you omar attia! 😊

[@snaxman]

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

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

[@TechyChung]

@@HeyFlutter always here for your support!

[@suniltimilsina7425]

Can you please me explain why there is exclamation mark in the end of the database name in: if(_database != null) return _database!; 03:52

[@TechyChung]

@@suniltimilsina7425 if you want detail explanation i explain you on chat, LOL I DON'T WANT TO SPAM COMMENT SECTION Maybe text me on ig: @hanishajainn

[@suniltimilsina7425]

@@TechyChung I can't find you on Instagram... is that your account which have only 17 following and about 11 followers?

[@chyo003]

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

[@HeyFlutter]

Glad it was helpful, @codinglife-ii1vr 😀

[@pcoderajap2913]

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

[@amgedgamer1827]

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

[@amgedgamer1827]

@@HeyFlutter Good,I am waiting make it soon please

[@mugume]

A very beautiful and excellent tutorial. Thank you @Johannes

[@HeyFlutter]

You’re most welcome, Arthur D. Mugume! 🙂

[@pranthonyaquino]

Great video, complete explanation of using sqlite and Flutter. Thanks! I'm subscribed now!

[@tharukerajapaksha3652]

My flutter teacher is you sir

[@heroliper6493]

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

[@turtleyoda7703]

Your channel is amazing. Keep up

[@Dichill]

Thank you for the great content as always! Managed to make an app with sqflite.

[@drooner]

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

[@snowball5407]

Your sound is very easy to understand

[@achinhchin]

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

[@feutioclide7345]

you deserve a reward. Thanks

[@TechyChung]

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

[@nhannguyenvanthanh8604]

thank you very much, very easy to understand, hope you will make more videos

[@pierremarais7669]

Johannes again what a NICE video this, just love it, thanks

[@md.ruhulamin7963]

What a clear explanation sir!! Thank you so much.

[@jonathanmunday9210]

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

[@HeyFlutter]

Thank You Jonathan Munday! Follow this link: stackoverflow.com/questions/63347032/how-do-you-upgrade-a-flutter-app-with-sqlite-database I hope you will get your answer 🙂

[@somethingwithit9768]

Really helpful explanation. Thank you very much !!

[@uditmishra5583]

outstanding explanation man,thanks

[@rameshkrishnan6754]

Best video on sqflite!🔥

[@mahanshiran5037]

Thank you for the perfect tutorial. I have a question, what if I want to have a list of initial data, so that anyone who download this app will have these data already stored in the app?

[@ntandotshongweni5240]

Don't know if it's the correct approach. But I just called create method inside the _CreateDB after creating the table.

[@achieverstv8244]

Thanks for the tutorial. You'll have to write a lot of code in flutter for SQL than C#.

[@HeyFlutter]

Yeah, @achieverstv8244 🙂

[@maqquse5967]

Thank you so much for the effort. This really helped me in my project.

[@HeyFlutter]

Glad I could be of help, You are welcome Maqquse! 😊

[@anantsinghal2586]

Just subscribed your channel ! Loved this video ❤

[@Bootngoals]

Another great Tutorial. Nice job Man.

[@ekoprasetyo3999]

Your videos are awesome

[@edwardjo9064]

Thank you, Johannes! 👍

[@aligohar1708]

Reading his code shows his experience

[@HeyFlutter]

Thanks, Ali Gohar! 🙂

[@coolnanel]

Amazing!! Thanks Johannes

[@mohammedasha98]

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

[@mohammedasha98]

@@HeyFlutter thanks 💜

[@hotrodhunk7389]

This is why I can't stand class-based programming. 100 lines of code just to create a database. I'm sure there's a good reason for it but it seems asinine to somebody just starting coding. If I create the database why wouldn't it just initialize right away without me having to explicitly call it?

[@HeyFlutter]

Thanks for your feedback, @hotrodhunk7389! 🙂

[@vicenterusso]

Great video! I'm curious, whats your recording process? how can you paste multiple contents with apparently no video editing? Also, have you tried floor? Any pros vs cons?

[@d-apps2699]

Johannes one thing that I'd like to know is how do you organize your code when you will have lots of different tables with different coluns and data, like storing lots of different models, using one db for it, I think we would need a helper to class that could do a CRUD in multiple tables/colums, maybe different db's too.

[@richequan5115]

very helpful content

[@HeyFlutter]

Thank you, Riche Quan! 🙂

[@terenceflowers9159]

Extremely helpful! Thank you!

[@priyadarshinichettiar6750]

You are best ! Thanks a lot for the awesome tutorial!

[@JuanDavid-hl9gy]

Great video man! . Can you make a video about how to retrieve data from firestore and save it in a CSV file?

[@HeyFlutter]

Thanks, Juan David! 🙂 Check out my videos about Firestore here. Instead of CSV File you could also use JSON files 0. Load JSON Tutorial: kzbin.info/www/bejne/iJ3JZqRoeqx7sMU 1. Store JSON Tutorial: kzbin.info/www/bejne/Y2SVeXyph8tlbNE 2. Firebase CRUD Tutorial: kzbin.info/www/bejne/e4eVdayogLSkqLs 3. Todo App With Firebase Tutorial: kzbin.info/www/bejne/e4eVdayogLSkqLs 4. Pagination With Firebase Tutorial: kzbin.info/www/bejne/f6PYpq2GrsmDsJY 5. ChatApp With Firebase Tutorial: kzbin.info/www/bejne/rXmslH16hsd1fNU

[@niamatnaz]

Thank you so much Mr. J. Milke for uploading such a wonderful video in a fabulous manner. i found it very helpful. Could u please share the code in pdf or word.

[@parisleah4567]

[Problem] SqfliteDatabaseException (DatabaseException(no such table: shop I added more await db.execute('''CREATE TABLE ") below the table first one and this Exception appeared, Like my new 'shop' table is not on created

[@parisleah4567]

[Solved] I solved this

[@HeyFlutter]

Thank you, ParisLeah! 🙂

[@IzLightG]

Ty, it really help me so much! Following the note model, how can add ManyToMany relationship with other table?

[@HeyFlutter]

Thank You Alan Gómez! Follow this link: www.back4app.com/docs/flutter/parse-sdk/data-objects/flutter-many-to-many-relationship I hope you will get your answer 🙂

[@pipepi4888]

Thank you so much. So beautiful

[@tyleraung538]

Hi, thanks for the code and the very clear walkthrough. Very well created. However I have a question for the insert statement. from 11:20 to 12:20. I understand that id is not generated from dart, so the id is auto-generated from db side. But why do we have to collect id after inserting to db?

[@morrigan_ghost]

We need to read, delete, edit, etc. items. How you will identificate single item to operate with it? We have probability to have items with same title. Future delete(int id) async { final db = await instance.database; return db.delete( _tableName, where: '${TaskFields.id} = ?', whereArgs: [id], ); }

[@Hello-eq5rm]

Such a nice content !!!

[@SunGkd123]

Another great video 👍thank you so much

[@kamrulibnzaman]

Thank you very much for the video and also providing the code for free.

[@HeyFlutter]

You’re most welcome, Kamrul Ibn Zaman! 🙂

[@clefeducationforum7726]

Great Tutorial excellent.

[@HeyFlutter]

Thanks, @clefeducationforum7726! 🙂

[@kucingmalaya1177]

Hye, im new to SQflite, Firebase database has console in their website, but where is the database for SQflite? I want to see the structure, table and so on.

[@HeyFlutter]

Thank You Kucing Malaya! Follow this link: medium.com/flutter-community/using-sqlite-in-flutter-187c1a82e8b I hope you will get your answer 🙂

[@Nguyenabcd1]

I love your video. I downloaded it and opened it by visual studio code. I get a lot of errors, such as "Use 'const' for final variables initialized to a constant value. Try replacing 'final' with 'const'." or " Convert 'key' to a super parameter. ". Please tell me why. I am a beginner and therefore it is very difficult for me to fix them.

[@HeyFlutter]

Hey, @Nguyenabcd1 🙂 This is happening because flutter keeps on updating their stuff to make more reliable and efficient. The errors that you are facing are nothing but warnings that will help you write better and efficient code.

[@smartapps8770]

Cool, subscribed. Do we have paging?

[@smartapps8770]

@@HeyFlutter Thanks, I'll look into it.

[@smartapps8770]

How can we get 20 notes per page, we should not call readAllNotes() right? For example, I want to just get 20 notes, and when there is new page, get next 20 notes, and so on.

[@ashishrana5773]

Thank you so much for the great tutorial. i have a question, if i want to create a user registration form, how would i achieve it ?

[@HeyFlutter]

Thank You ashish rana! Follow this link: kzbin.info/www/bejne/fV63gqyNn9B2g6c&ab_channel=EasyCodingwithAmmara I hope you will get your answer 🙂

[@ashishrana5773]

@@HeyFlutter that’s so kind of you. Really appreciated.

[@rabbihossen9734]

Thank you. I need to know how to add bookmark in local device storage.

[@HeyFlutter]

Thank You Rabbi Hossen! Follow this link: stackoverflow.com/questions/41369633/how-to-save-to-local-storage-using-flutter I hope you will get your answer 🙂

[@justindelarapa1551]

Hi, I am currently learning flutter and Dart, Just have a little question. Why do we need to pass the value of "id" from INSERT method into the "Note" object using the COPY method?

[@HeyFlutter]

Thank You Justin Dela Rapa! Follow this link: stackoverflow.com/questions/59967096/add-id-or-name-property-or-other-means-of-identification-for-flutter-web-applica I hope you will get your answer 🙂

[@morrigan_ghost]

I have the same question actually

[@raffazain]

Great tutorial, thank you

[@MK-qo9or]

Hi, Thanks for the video . I followed your whole tutorial and did some side projects, but am having problems with update function , it is not updating from my database , I check your github project and couldn`t solve the problem . am getting error null type Null isn't supported .

[@MK-qo9or]

You had to delete my comment , you could have just said I can’t answer you sorry 😕

[@AbdullahHattab]

Thank you for your efforts, can i ask where can i find the file notes.db in my folder's app?

[@dinhtrongle1532]

thanks for the great video!!

[@TrikNgonlen]

Awesome! As always... Hi, @Johannes Milke I wonder how to implement "saving data from internet/web-service to this kind of local database" to work like WhatsApp or Telegram. Any idea? or Do you plan to make tutorial about that thing?

[@TrikNgonlen]

Terima kasih atas balasannya, @@HeyFlutter... That was great answer! But, it will be hard for me, since I'm still newbie... anyway, thanks a lot

[@HeyFlutter]

Thanks, Trik! 🙂 Simply download the files / data first and then store it your database such as learned in this of this tutorial. Learn more about loading data from the internet here: kzbin.info/www/bejne/iJ3JZqRoeqx7sMU

[@innocentphilbert717]

thank you Johannes also are need explanation on how to connect flutter app with firebase

[@HeyFlutter]

Thank you 😊, innocent philbert! Check out this playlist on flutter and firebase : kzbin.info/www/bejne/kGHNd56GZaZmeJI

[@batuhankrbb]

It's a pretty simple and straightforward tutorial. Thanks!

[@srunrathaes128]

Thanks for sharing.

[@HeyFlutter]

You are welcome, @srunrathaes128!

[@Glasya]

I followed your instructions for my own use case, but was wondering how you would go about with multiple tables, i assume you would create a separate db.dart in which you initialise the connection, and create the tables from, but i can't figure out how to make that work.

[@brenholli]

Great project.. I have an issue and I need assistance. After following all the steps the app ain't working, it keeps showing the circular progress rotation. What did I do wrong? But I'm not getting any error messages

[@HeyFlutter]

Thank You bren holli! Follow this link: stackoverflow.com/questions/57890083/circular-progress-keeps-on-rotating I hope you will get your answer 🙂

[@NithinKumar.P]

is it possible using sqflite to create database such as for example we have user form with dropdown menu animals and birds. If user selects animals, all input textfields only related to animals should display and store the animals related info in animals table separately and viceversa for birds..input textfields only related to birds should store in separate table. but both the birds and animals list should be accesible from home screen.

[@dargwa1046]

thank you very much for the video, I wanted to know if it is possible to send an icon to the database and then display it in a widget for example, if so how to do?

[@HeyFlutter]

Thank You DARGWA! Follow this link: stackoverflow.com/questions/59369988/save-icondata-and-restore-in-flutter I hope you will get your answer 🙂

[@polyarts3d]

Awesome Video. But there is no implementation of the create method , in creating the notes. I believe its the same as Read.... i guess. Thanks great content.

[@HeyFlutter]

Thank you, BruseL33! 🙂. Inserting data is basically creating data.

[@AboEyadwagih]

when i open app just loading and when i select add save not work >>please correct me

[@enricoantonio3282]

Hey Johannes. Thank you for making this video. This is a perfect tutorial for sqlite. But I'm still confused what is the used of isImportant and number in the database?

[@d-apps2699]

Enrico you mean why was used number instead of the bool value? If so its because sql cannot handle bool values so we can control it by using number, false = 0 and true = 1, like on/off

[@mattihna]

nice work thank you 👏

[@pranjaldubey5345]

Wonderful tutorial but I am getting an error - E/SQLiteLog( 5554): (1) no such table: notes E/flutter ( 5554): [ERROR:flutter/lib/ui/ui_dart_state.cc(198)] Unhandled Exception: DatabaseException(no such table: notes (code 1): , while compiling: SELECT * FROM notes ORDER BY createdTime ASC) sql 'SELECT * FROM notes ORDER BY createdTime ASC' args [] please help me to solve the issue

[@HeyFlutter]

Hello, Pranjal Dubey! Follow this link: stackoverflow.com/questions/63103065/flutter-sqflite-databaseexceptionno-such-table-project I hope it will solve your problem. Thank You 🙂

[@Lost.In.Spacetime]

Thank you! Is the updating for "isImportant" working? When I try to update the "isImportant" of an already created note, it doesn't update.. I can't figure out how to fix it.. :(

[@shahohabib8439]

Thanks a lot for the great video ..would you please share the source code I checked provided link in the description but could not find it ...

[@HeyFlutter]

Thanks, Shaho Habib! 🙂 The source code is available. Learn more about it here: github.com/JohannesMilke/sponsorware#1-why-is-the-source-code-not-available-on-github

[@Fathin-no9hc]

thanks a lot for the video sir. I want to ask if the Copy function is really needed in the Create function? can I change the return type of the Create function from Note to just void?

[@HeyFlutter]

Thank you, Fathin Al Ghifari! 🙂. Then it will not work.

[@morrigan_ghost]

@@HeyFlutter what if replace the copy method with setter for ID field ? Idk why we need to copy all fields if we change only one. Thanks, Johannes, for your work!

[@001Debjeet]

this is gold

[@nikhilkukreja8498]

Thank you Johannes :)

[@dhillonj75]

can you pleasemake a video on how to add and use excel in flutter .

[@namnguyenanh5170]

Thank you very much!

[@HeyFlutter]

Glad you liked it, @namnguyenanh5170 😀

[@AbdullahAbdullah-vz4nk]

very helpful tnx.

[@adilahusin]

Hi do you have tutorials flutter dart using sqlite for email login page? In which for login they read data from database

[@HeyFlutter]

Hey 😊, @adilahusin! Check out this video: kzbin.info/www/bejne/Y2SVeXyph8tlbNE I hope it may help you

[@md.nayeemhasanadil5938]

Hello,, Sir I've followed as per your instruction on this video to make the app but it is showing an error like The argument type 'Map' can't be assigned to the parameter type 'Map' because 'Object?' is nullable and 'Object' isn't. It is showing on the notes_database dart page. It is showing error on "return Note.fromJson(maps.first);" . the maps.first is showing error. can you please help.

[@HeyFlutter]

Thank You Md. Nayeem Hasan Adil! Follow this link: stackoverflow.com/questions/63597313/the-argument-type-mapstring-dynamic-function-cant-be-assigned-to-the-par I hope you will get your answer 🙂

[@snowball5407]

I would like to buy your course but it's no detail information on it T^T

[@muniralmeslaty9602]

Thank you very Much

[@pierremarais7669]

Hi Johannes, I wrote an App using and sqflite: +2.00+3, path_provider: ^0.5.12+4 & shared_preference: ^2.0.5, I do get error exit code 1 because of path_provider and shared_preference not working together, do you know the reason, please, I Googled this morning for a result with no success, thanks Pierre

[@HeyFlutter]

Thank you, Pierre Marais! 🙂 please remove the version numbers and run flutter clean and then pub get. your problem will be solved

[@cassidy318]

Im stuck. How do I retrieve the id when im reading one of the databases. I'm using this with Bloc pattern to emit the values form the database

[@HeyFlutter]

Thank You Mathew! Follow this link: stackoverflow.com/questions/58796154/how-to-retrieve-particular-data-using-sqlflite-in-flutter I hope you will get your answer 🙂

[@Zegger]

Cool tutorial but I haven't been able to use double for type, any ideas?

[@HeyFlutter]

Thank You Zegger! Follow this link: api.flutter.dev/flutter/dart-core/double-class.html I hope you will get your answer 🙂

[@4dovescreative2023]

Hi Johannes, thank you for another great tutorial. I have managed to write all the code for the db with all my relevant fields but I don't want to use it for a 'note app' I need to make my db work for a 'medications list'. I want the user to be able to list all their meds etc and then retrieve/update/delete from more of a form field type UI. Could you please give me some ideas on how to develop the screen so this would work with my newly created db? I hope this makes sense, I am very new to coding and this is my first app! Kind regards Jane

[@HeyFlutter]

Thanks, Jane Maddison! 🙂 Simply start with something more simple as your first app. This should be your first app: kzbin.info/www/bejne/i4G2pKt9hrd8sNU

[@user-xe8vl9eh9l]

hi johannes ,how to delete the automatically without the user interface after certain time like 1 day or if the jobs done

[@HeyFlutter]

Thank You s! Follow this link: stackoverflow.com/questions/64819550/how-to-automatically-remove-data-from-firestore-after-a-specific-time I hope you will get your answer 🙂

[@user-xe8vl9eh9l]

@@HeyFlutter hi johannes how to bloc third party keyboard in flutter app