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!
@@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
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"
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
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?
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.
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 🙂
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.
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 🙂
Thanks, Juan David! 🙂 Check out my videos about Firestore here. Instead of CSV File you could also use JSON files 0. Load JSON Tutorial: ruclips.net/video/Rlf5q2EGHzc/видео.html 1. Store JSON Tutorial: ruclips.net/video/-32HIsRf26o/видео.html 2. Firebase CRUD Tutorial: ruclips.net/video/EV2DyrKOqrY/видео.html 3. Todo App With Firebase Tutorial: ruclips.net/video/EV2DyrKOqrY/видео.html 4. Pagination With Firebase Tutorial: ruclips.net/video/IruuzPydPz4/видео.html 5. ChatApp With Firebase Tutorial: ruclips.net/video/wHIcJDQbBFs/видео.html
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.
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.. :(
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?
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 🙂
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?
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], ); }
[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
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.
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.
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?
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 🙂
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.
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.
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 .
@@HeyFlutter you can't believe i have listened to this video for more than 7 times, it's very interesting and has helped me a lot in my final year project, thank you man
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?
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.
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
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?
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: ruclips.net/video/Rlf5q2EGHzc/видео.html
👉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: ruclips.net/video/szOllHT1S7Y/видео.html
Shared Preferences II Persist JSON Data Tutorial: ruclips.net/video/-32HIsRf26o/видео.html
Todo App From Scratch Tutorial: ruclips.net/video/kN9Yfd4fu04/видео.html
Firebase CRUD Tutorial: ruclips.net/video/EV2DyrKOqrY/видео.html
Secure Storage Tutorial: ruclips.net/video/Oqhrxk_f1RE/видео.html
Search App Bar & Search Delegate Tutorial: ruclips.net/video/RaACAwvZ61E/видео.html
Crop & Save Images Tutorial: ruclips.net/video/pXbBTJt7frM/видео.html
Store Image Tutorial: ruclips.net/video/JDDoN2THwug/видео.html
Selectable DataTable Tutorial: ruclips.net/video/HZD-0zgpuak/видео.html
Deploy Flutter Web App Tutorial: ruclips.net/video/xJo7Mqse960/видео.html
Create Invoice PDF Document Tutorial: ruclips.net/video/z_5xkhEkc5Y/видео.html
Google SignIn Tutorial: ruclips.net/video/ogW83xGQGTg/видео.html
Email Sign In Tutorial: ruclips.net/video/rnHAInnjCmM/видео.html
App Internationalization Tutorial: ruclips.net/video/Zw4KoorVxgg/видео.html
Migrate App To Null Safety Tutorial: ruclips.net/video/GLnQphHi1BY/видео.html
Null Safety In 5 Minutes Tutorial: ruclips.net/video/Q_WloMNKOkU/видео.html
Autofill Services Tutorial: ruclips.net/video/v8T4fnrQCf0/видео.html
Clear voice with slow and perfect explanation. Keep it up. Thank you for such a nice and awesome video.
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!
@@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
Best flutter tutorial channel in English
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"
@@HeyFlutter You are welcome, sexy voice.
how we find the our db path where is this located
6:13 A very elegant way of parametrizing your SQL typing and variables. Never seen that before but really enjoying it!
Thanks, Max R! 🙂
@@HeyFlutter You got yourself a new subscriber!
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
Wonderful tutorial and covered everything in so details i managed to implement same into my project in no time, kudo to you :)
Best flutter tutorial! This is the basis of all apps
Thank you, John! 🙂
Just got Started with flutter and these are good quality content keep up the good work!!
Thank you SO MUCH for this tutorial!!! It is extremely helpful, with clear and easy steps to follow. Please continue posting such tutorials!! :)
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!
@@HeyFlutter always here for your support!
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
@@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
@@TechyChung I can't find you on Instagram... is that your account which have only 17 following and about 11 followers?
I really like your channel, it's the best I've ever seen so far
Glad to hear that, Thank you omar attia! 😊
hie am total new to flutter ..ur tutorial is he best i found out there...
My flutter teacher is you sir
thank you so much !
I learned how to build my app with sqflite from this tutorial
Glad it was helpful, @codinglife-ii1vr 😀
thanks @Johannes for your efforts
Please give us tutorial sqflit with multiple tables with foreign key
@@HeyFlutter
Good,I am waiting make it soon please
Great video, complete explanation of using sqlite and Flutter. Thanks! I'm subscribed now!
Your sound is very easy to understand
It all looks so easy when you do it :-D Thanks for another great video.
Your channel is amazing. Keep up
Thank you so much! :)
This tutorial was reaally helpful and easy to follow,
have a great day!
Johannes again what a NICE video this, just love it, thanks
A very beautiful and excellent tutorial. Thank you @Johannes
You’re most welcome, Arthur D. Mugume! 🙂
Best video on sqflite!🔥
Thank you for the great content as always! Managed to make an app with sqflite.
you deserve a reward. Thanks
You are amazing! best video and explained in the best way ever possible!
Thank you very much, everything you teach is very helpful to me.
thank you very much, very easy to understand, hope you will make more videos
Another great Tutorial. Nice job Man.
Thanks for the tutorial.
You'll have to write a lot of code in flutter for SQL than C#.
Yeah, @achieverstv8244 🙂
What a clear explanation sir!! Thank you so much.
outstanding explanation man,thanks
Reading his code shows his experience
Thanks, Ali Gohar! 🙂
Really helpful explanation. Thank you very much !!
Your videos are awesome
Just subscribed your channel ! Loved this video ❤
Amazing!! Thanks Johannes
Thank you, Johannes! 👍
Thank you so much for the effort. This really helped me in my project.
Glad I could be of help, You are welcome Maqquse! 😊
Extremely helpful! Thank you!
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?
Don't know if it's the correct approach. But I just called create method inside the _CreateDB after creating the table.
Such a nice content !!!
You are best ! Thanks a lot for the awesome tutorial!
very helpful content
Thank you, Riche Quan! 🙂
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.
Thank you so much. So beautiful
Thank you very much for the video and also providing the code for free.
You’re most welcome, Kamrul Ibn Zaman! 🙂
Great Tutorial excellent.
Thanks, @clefeducationforum7726! 🙂
At 8:19 what must you put after onUpgrade: ? (after the colon: ) if you add new fields to your Create Table
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 🙂
Another great video 👍thank you so much
Great tutorial, thank you
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.
this is gold
thanks for the great video!!
Thank you very Much
Thanks for sharing.
You are welcome, @srunrathaes128!
thank you Johannes
also are need explanation on how to connect flutter app with firebase
Thank you 😊, innocent philbert! Check out this playlist on flutter and firebase : ruclips.net/video/Z0jFkP0A3B0/видео.html
Ty, it really help me so much!
Following the note model, how can add ManyToMany relationship with other table?
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 🙂
nice work thank you 👏
very helpful tnx.
It's a pretty simple and straightforward tutorial. Thanks!
Great video man! . Can you make a video about how to retrieve data from firestore and save it in a CSV file?
Thanks, Juan David! 🙂 Check out my videos about Firestore here. Instead of CSV File you could also use JSON files
0. Load JSON Tutorial: ruclips.net/video/Rlf5q2EGHzc/видео.html
1. Store JSON Tutorial: ruclips.net/video/-32HIsRf26o/видео.html
2. Firebase CRUD Tutorial: ruclips.net/video/EV2DyrKOqrY/видео.html
3. Todo App With Firebase Tutorial: ruclips.net/video/EV2DyrKOqrY/видео.html
4. Pagination With Firebase Tutorial: ruclips.net/video/IruuzPydPz4/видео.html
5. ChatApp With Firebase Tutorial: ruclips.net/video/wHIcJDQbBFs/видео.html
Thank you Johannes :)
Thank you very much!
Glad you liked it, @namnguyenanh5170 😀
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.
Thank You Kucing Malaya! Follow this link: medium.com/flutter-community/using-sqlite-in-flutter-187c1a82e8b
I hope you will get your answer 🙂
hello dear,
Can you explain in video how use search on data with sqf 🌻
@@HeyFlutter thanks 💜
I like it when you don't use background songs for your videos so I can play my own music.
thank you
great job
Thank you for your efforts, can i ask where can i find the file notes.db in my folder's app?
Thanks ❤
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.. :(
hey vry nice
tnk for the video
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?
Thank you. I need to know how to add bookmark in local device storage.
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 🙂
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?
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],
);
}
Thank you for your effort but I don't know why your tutorial is somehow difficult to me !
Thank you, salahadin dinsafa! 🙂. If you find them difficult you can still ask me questions, I will try my best to help you.
[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
[Solved] I solved this
Thank you, ParisLeah! 🙂
Thank you, you are god!
thank bro
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.
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.
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?
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 🙂
I have the same question actually
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.
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.
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 .
You had to delete my comment , you could have just said I can’t answer you sorry 😕
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 ?
Thank You ashish rana! Follow this link: ruclips.net/video/G-TQyWjkCME/видео.html&ab_channel=EasyCodingwithAmmara
I hope you will get your answer 🙂
@@HeyFlutter that’s so kind of you. Really appreciated.
can you pleasemake a video on how to add and use excel in flutter .
thanks a lot
You are welcome, @roninspect4357 😊
nice one
@@HeyFlutter you can't believe i have listened to this video for more than 7 times, it's very interesting and has helped me a lot in my final year project, thank you man
when i open app just loading and when i select add save not work >>please correct me
did you do this in null safety version ?
Thanks.
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?
Thank You DARGWA! Follow this link: stackoverflow.com/questions/59369988/save-icondata-and-restore-in-flutter
I hope you will get your answer 🙂
I would like to buy your course but it's no detail information on it T^T
Cool, subscribed. Do we have paging?
@@HeyFlutter Thanks, I'll look into it.
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.
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
Thank You bren holli! Follow this link: stackoverflow.com/questions/57890083/circular-progress-keeps-on-rotating
I hope you will get your answer 🙂
Maa syaa allah tabaarakallah
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?
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
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: ruclips.net/video/Rlf5q2EGHzc/видео.html