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
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
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"
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 🙂
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?
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.
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?
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], ); }
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.
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 🙂
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 🙂
[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
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.
Thanks, Juan David! 🙂 Check out my videos about Firestore here. Instead of CSV File you could also use JSON files 0. Load JSON Tutorial: th-cam.com/video/Rlf5q2EGHzc/w-d-xo.html 1. Store JSON Tutorial: th-cam.com/video/-32HIsRf26o/w-d-xo.html 2. Firebase CRUD Tutorial: th-cam.com/video/EV2DyrKOqrY/w-d-xo.html 3. Todo App With Firebase Tutorial: th-cam.com/video/EV2DyrKOqrY/w-d-xo.html 4. Pagination With Firebase Tutorial: th-cam.com/video/IruuzPydPz4/w-d-xo.html 5. ChatApp With Firebase Tutorial: th-cam.com/video/wHIcJDQbBFs/w-d-xo.html
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.
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 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 .
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.
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.. :(
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.
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?
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
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?
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 Hello! The issue was I had some extra commas I forgot to take out. I have another question though. Is it okay for me to use and transform this code for a school project? I would properly cite you of course! Thanks!
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 🙂
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.
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
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 🙂
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 🙂
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 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!
Thank you 😊, Farid Cenreng-1005! Check out this article for better understanding : medium.flutterdevs.com/keys-in-flutter-104fc01db48f?msclkid=87b89248a76911ecbf256fe00a70adf3
![Flutter Tutorial - How To Publish Flutter App On Play Store [2024] Build, Release & Deploy App](/img/n.gif)
👉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: th-cam.com/video/szOllHT1S7Y/w-d-xo.html
Shared Preferences II Persist JSON Data Tutorial: th-cam.com/video/-32HIsRf26o/w-d-xo.html
Todo App From Scratch Tutorial: th-cam.com/video/kN9Yfd4fu04/w-d-xo.html
Firebase CRUD Tutorial: th-cam.com/video/EV2DyrKOqrY/w-d-xo.html
Secure Storage Tutorial: th-cam.com/video/Oqhrxk_f1RE/w-d-xo.html
Search App Bar & Search Delegate Tutorial: th-cam.com/video/RaACAwvZ61E/w-d-xo.html
Crop & Save Images Tutorial: th-cam.com/video/pXbBTJt7frM/w-d-xo.html
Store Image Tutorial: th-cam.com/video/JDDoN2THwug/w-d-xo.html
Selectable DataTable Tutorial: th-cam.com/video/HZD-0zgpuak/w-d-xo.html
Deploy Flutter Web App Tutorial: th-cam.com/video/xJo7Mqse960/w-d-xo.html
Create Invoice PDF Document Tutorial: th-cam.com/video/z_5xkhEkc5Y/w-d-xo.html
Google SignIn Tutorial: th-cam.com/video/ogW83xGQGTg/w-d-xo.html
Email Sign In Tutorial: th-cam.com/video/rnHAInnjCmM/w-d-xo.html
App Internationalization Tutorial: th-cam.com/video/Zw4KoorVxgg/w-d-xo.html
Migrate App To Null Safety Tutorial: th-cam.com/video/GLnQphHi1BY/w-d-xo.html
Null Safety In 5 Minutes Tutorial: th-cam.com/video/Q_WloMNKOkU/w-d-xo.html
Autofill Services Tutorial: th-cam.com/video/v8T4fnrQCf0/w-d-xo.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
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
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!
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
Best flutter tutorial! This is the basis of all apps
Thank you, John! 🙂
Wonderful tutorial and covered everything in so details i managed to implement same into my project in no time, kudo to you :)
I really like your channel, it's the best I've ever seen so far
Glad to hear that, Thank you omar attia! 😊
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?
Just got Started with flutter and these are good quality content keep up the good work!!
thank you so much !
I learned how to build my app with sqflite from this tutorial
Glad it was helpful, @codinglife-ii1vr 😀
Thank you SO MUCH for this tutorial!!! It is extremely helpful, with clear and easy steps to follow. Please continue posting such tutorials!! :)
hie am total new to flutter ..ur tutorial is he best i found out there...
My flutter teacher is you sir
Your sound is very easy to understand
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!
A very beautiful and excellent tutorial. Thank you @Johannes
You’re most welcome, Arthur D. Mugume! 🙂
It all looks so easy when you do it :-D Thanks for another great video.
Thank you very much, everything you teach is very helpful to me.
Thank you so much! :)
This tutorial was reaally helpful and easy to follow,
have a great day!
Your channel is amazing. Keep up
Thank you for the great content as always! Managed to make an app with sqflite.
What a clear explanation sir!! Thank you so much.
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 🙂
you deserve a reward. Thanks
thank you very much, very easy to understand, hope you will make more videos
outstanding explanation man,thanks
You are amazing! best video and explained in the best way ever possible!
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.
Johannes again what a NICE video this, just love it, thanks
Really helpful explanation. Thank you very much !!
Your videos are awesome
Reading his code shows his experience
Thanks, Ali Gohar! 🙂
Best video on sqflite!🔥
Thank you so much for the effort. This really helped me in my project.
Glad I could be of help, You are welcome Maqquse! 😊
Thanks for the tutorial.
You'll have to write a lot of code in flutter for SQL than C#.
Yeah, @achieverstv8244 🙂
Thank you, Johannes! 👍
Amazing!! Thanks Johannes
Just subscribed your channel ! Loved this video ❤
Another great Tutorial. Nice job Man.
very helpful content
Thank you, Riche Quan! 🙂
Great Tutorial excellent.
Thanks, @clefeducationforum7726! 🙂
It's a pretty simple and straightforward tutorial. Thanks!
You are best ! Thanks a lot for the awesome tutorial!
Extremely helpful! Thank you!
Thank you very much for the video and also providing the code for free.
You’re most welcome, Kamrul Ibn Zaman! 🙂
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.
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?
Such a nice content !!!
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 so much. So beautiful
hello dear,
Can you explain in video how use search on data with sqf 🌻
@@HeyFlutter thanks 💜
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 🙂
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
Great tutorial, thank you
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 🙂
[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! 🙂
Another great video 👍thank you so much
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.
Thanks for sharing.
You are welcome, @srunrathaes128!
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: th-cam.com/video/Rlf5q2EGHzc/w-d-xo.html
1. Store JSON Tutorial: th-cam.com/video/-32HIsRf26o/w-d-xo.html
2. Firebase CRUD Tutorial: th-cam.com/video/EV2DyrKOqrY/w-d-xo.html
3. Todo App With Firebase Tutorial: th-cam.com/video/EV2DyrKOqrY/w-d-xo.html
4. Pagination With Firebase Tutorial: th-cam.com/video/IruuzPydPz4/w-d-xo.html
5. ChatApp With Firebase Tutorial: th-cam.com/video/wHIcJDQbBFs/w-d-xo.html
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.
thanks for the great video!!
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 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 😕
nice work thank you 👏
Thank you very much!
Glad you liked it, @namnguyenanh5170 😀
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.
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.. :(
very helpful tnx.
Thank you very Much
Thank you for your efforts, can i ask where can i find the file notes.db in my folder's app?
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: th-cam.com/video/G-TQyWjkCME/w-d-xo.html&ab_channel=EasyCodingwithAmmara
I hope you will get your answer 🙂
@@HeyFlutter that’s so kind of you. Really appreciated.
Thank you Johannes :)
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.
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?
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
this is gold
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 : th-cam.com/video/Z0jFkP0A3B0/w-d-xo.html
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 🙂
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 🙂
hey vry nice
tnk for the video
great job
did you do this in null safety version ?
when i open app just loading and when i select add save not work >>please correct me
Hi do you have tutorials flutter dart using sqlite for email login page? In which for login they read data from database
Hey 😊, @adilahusin! Check out this video: th-cam.com/video/-32HIsRf26o/w-d-xo.html I hope it may help you
Hello, I am having an issue where it says I have duplicate column names. Any idea on what that is?
@@HeyFlutter Hello! The issue was I had some extra commas I forgot to take out. I have another question though. Is it okay for me to use and transform this code for a school project? I would properly cite you of course! Thanks!
I can all methods(create, delete, etc.) insert in Note type class? I have more one table
@@HeyFlutter I need answer))
Cool tutorial but I haven't been able to use double for type, any ideas?
Thank You Zegger! Follow this link: api.flutter.dev/flutter/dart-core/double-class.html
I hope you will get your answer 🙂
I want to use local database in my flutter desktop app. So which database is best for flutter desktop app??????
Thank You Shayan! Follow this link: blog.logrocket.com/choosing-right-database-flutter-application/
I hope you will get your answer 🙂
Thanks ❤
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
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 🙂
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.
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
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 🙂
hi johannes ,how to delete the automatically without the user interface after certain time like 1 day or if the jobs done
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 🙂
@@HeyFlutter hi johannes how to bloc third party keyboard in flutter app
Where you create StaggeredGridView and StaggeredTile???
Thank You @vadymkon! Follow this link: pub.dev/packages/flutter_staggered_grid_view
I hope you will get your answer 🙂
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?
Thank you, Fathin Al Ghifari! 🙂. Then it will not work.
@@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!
I still don't understand about key, what is _formkey in your edit_note_page ?
Thank you 😊, Farid Cenreng-1005! Check out this article for better understanding : medium.flutterdevs.com/keys-in-flutter-104fc01db48f?msclkid=87b89248a76911ecbf256fe00a70adf3