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"
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 🙂
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
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 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 Rabbi Hossen! Follow this link: stackoverflow.com/questions/41369633/how-to-save-to-local-storage-using-flutter 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 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?
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.
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.
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 🙂
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.
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!
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?
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.
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 thanks for replaying. i am looking for solution. i have an existing app in playstore/appstore and both of them using sqflite. and now we want release new app version and in this version we have a new `alter table` or modifying/adding some table or adding initial data to some table. but when we try to install it in existing apps the modify for table/database in new version not working without loosing user existing data. did you have any experience on it ?
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 🙂
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
@@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 😊, Farid Cenreng-1005! Check out this article for better understanding : medium.flutterdevs.com/keys-in-flutter-104fc01db48f?msclkid=87b89248a76911ecbf256fe00a70adf3
Thank You Wooloo! Follow this link: medium.com/flutterdevs/custom-animated-bottomnavigation-bar-in-flutter-65293e231e4a I hope you will get your answer 🙂
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.. :(
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.
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
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
Thank You ParisLeah! Follow this link: stackoverflow.com/questions/68780756/virtual-emulator-freeze-in-android-studio-on-windows-10 I hope you will get your answer 🙂
Thank You shubhanm maurya! Follow this link: stackoverflow.com/questions/74998297/create-model-class-for-list-of-objects-within-an-object I hope you will get your answer 🙂
Hi, can anyone tell me how we can view the database and the table in vs code the way we can see a database in php my admin? I need some visual aid when working with database, thank you.
Thank You super saiyan! Follow this link: stackoverflow.com/questions/62658108/view-sqflite-table-contents-for-debugging I hope you will get your answer 🙂
Thank You Martin Kalewa! Follow this link: stackoverflow.com/questions/65385803/how-to-upload-image-using-flutter-and-php-in-the-mysql I hope you will get your answer 🙂
Hello, Naushil! Follow this link: stackoverflow.com/questions/51384175/sqlite-in-flutter-how-database-assets-work/51387985#51387985, I hope you will find your answer. Thank You 🙂
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.
Hello Johannes, great video, i wanted to ask a question about this video which is i am getting a late initialisation error for late Note note in view_note_detail.dart page and i tried solving it by looking it up on stack overflow and other website but it is not working and if i make a null check to late Note note then the late initialisation error goes away but wherever i use note to access title and other details it gives error that says null check operator used on a null value (clearly the title value is not null as it shows up on the note_list page) can you please guide me on how to solve this issue? Thank you very much.
Hello, super saiyan! Follow this link: stackoverflow.com/questions/69373859/late-initialization-error-in-flutter-because-of-startdate I hope it will solve your problem. Thank You 🙂
![Flutter Tutorial - How To Stack Widgets With Overlapping [2021] Overlay Widget On Top Widget](http://i.ytimg.com/vi/ut9CeTQRax0/mqdefault.jpg)
![Flutter Tutorial - How To Stack Widgets With Overlapping [2021] Overlay Widget On Top Widget](/img/tr.png)
👉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
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!
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
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 🙂
Wonderful tutorial and covered everything in so details i managed to implement same into my project in no time, kudo to you :)
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 got Started with flutter and these are good quality content keep up the good work!!
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?
Thank you SO MUCH for this tutorial!!! It is extremely helpful, with clear and easy steps to follow. Please continue posting such tutorials!! :)
I really like your channel, it's the best I've ever seen so far
Glad to hear that, Thank you omar attia! 😊
Best flutter tutorial! This is the basis of all apps
Thank you, John! 🙂
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],
);
}
It all looks so easy when you do it :-D Thanks for another great video.
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!
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 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
hie am total new to flutter ..ur tutorial is he best i found out there...
My flutter teacher is you sir
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 🙂
you deserve a reward. Thanks
You are amazing! best video and explained in the best way ever possible!
2:30 Since MOOR is built on top of SQLite , isn’t MOOR still a SQL database?
Thank You Valeria Durán Ruiz! Follow this link: blog.codemagic.io/choosing-the-right-database-for-your-flutter-app/
I hope you will get your answer 🙂
did you do this in null safety version ?
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 🙂
Just subscribed your channel ! Loved this video ❤
Thank you for the great content as always! Managed to make an app with sqflite.
What a clear explanation sir!! Thank you so much.
Thank you very much, everything you teach is very helpful to me.
Another great Tutorial. Nice job Man.
A very beautiful and excellent tutorial. Thank you @Johannes
You’re most welcome, Arthur D. Mugume! 🙂
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
@@HeyFlutter that article saved me was stuck at db. query() i just changed it to db?.query()
Thank You Tech2Program! Follow this link: medium.com/@thinkdigitalsoftware/null-aware-operators-in-dart-53ffb8ae80bb
I hope you will get your answer 🙂
Best video on sqflite!🔥
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 🙂
outstanding explanation man,thanks
hello dear,
Can you explain in video how use search on data with sqf 🌻
@@HeyFlutter thanks 💜
Your videos are awesome
[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! 🙂
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
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 🙂
Thank you for your efforts, can i ask where can i find the file notes.db in my folder's app?
Amazing!! Thanks Johannes
when i open app just loading and when i select add save not work >>please correct me
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.
Your sound is very easy to understand
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 🙂
Really helpful explanation. Thank you very much !!
thank you very much, very easy to understand, hope you will make more videos
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.
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
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 can all methods(create, delete, etc.) insert in Note type class? I have more one table
@@HeyFlutter I need 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.
Thank you, Johannes! 👍
do u av a video on getting data from a to external server via http calls?
Thank You PCoder Ajap! Follow this link: docs.flutter.dev/cookbook/networking/fetch-data
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!
Extremely helpful! Thank you!
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?
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.
can you pleasemake a video on how to add and use excel in flutter .
how to check if some error happend and the note didnt added for example if i decided not to add identical notes if it exist ?
Thank You Bareq Raad! Follow this link: medium.com/flutter-community/error-handling-in-flutter-98fce88a34f0
I hope you will get your answer 🙂
You are best ! Thanks a lot for the awesome tutorial!
Thank you so much for the effort. This really helped me in my project.
Glad I could be of help, You are welcome Maqquse! 😊
Such a nice content !!!
Thanks for the tutorial.
You'll have to write a lot of code in flutter for SQL than C#.
Yeah, @achieverstv8244 🙂
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 😕
Reading his code shows his experience
Thanks, Ali Gohar! 🙂
How to add new attribute or some table to an existing app without losing our existing data ?
@@HeyFlutter thanks for replaying. i am looking for solution. i have an existing app in playstore/appstore and both of them using sqflite. and now we want release new app version and in this version we have a new `alter table` or modifying/adding some table or adding initial data to some table. but when we try to install it in existing apps the modify for table/database in new version not working without loosing user existing data. did you have any experience on it ?
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 🙂
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
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 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 🙂
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
Hi, I want to ask how to make the database work when turn to different pages using the bottom navigation bar?
Thank You Wooloo! Follow this link: medium.com/flutterdevs/custom-animated-bottomnavigation-bar-in-flutter-65293e231e4a
I hope you will get your answer 🙂
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.. :(
How to add favorite in flutter with Sqlite . Thanks
Thank you, huynh Nguyễn! 🙂 you simply need to create a table of items you want to add in favorite and then read it as shown in video
Another great video 👍thank you so much
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.
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 🙂
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 ...
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
Why my second Table can't query all data and Emulator is freezed?
Thank You ParisLeah! Follow this link: stackoverflow.com/questions/68780756/virtual-emulator-freeze-in-android-studio-on-windows-10
I hope you will get your answer 🙂
how to define if i have list object inside my modal class?
Thank You shubhanm maurya! Follow this link: stackoverflow.com/questions/74998297/create-model-class-for-list-of-objects-within-an-object
I hope you will get your answer 🙂
Hi, can anyone tell me how we can view the database and the table in vs code the way we can see a database in php my admin?
I need some visual aid when working with database, thank you.
Thank You super saiyan! Follow this link: stackoverflow.com/questions/62658108/view-sqflite-table-contents-for-debugging
I hope you will get your answer 🙂
hi mike, can i use a sqflite with windows app in flutter?
Thank you, Ahmad Ashraf! 🙂. Yes you can.
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 would like to buy your course but it's no detail information on it T^T
How do you sync storage to sql server?
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
nice tutorial, what if i want to upload image and text..... please can you help me?
Thank You Martin Kalewa! Follow this link: stackoverflow.com/questions/65385803/how-to-upload-image-using-flutter-and-php-in-the-mysql
I hope you will get your answer 🙂
When I close the app and reopen it in the emulator, the previous inserted stuff isn't saved. Is it because it's on an emulator?
Thank You MegaAlexc123! Follow this link: medium.com/flutter-community/using-sqlite-in-flutter-187c1a82e8b
I hope you will get your answer 🙂
Great tutorial, thank you
Heyy Sir, Where can we find this database in our mobile phone? As we have not specified any path for the data storage
Hello, Naushil! Follow this link: stackoverflow.com/questions/51384175/sqlite-in-flutter-how-database-assets-work/51387985#51387985, I hope you will find your answer. Thank You 🙂
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.
Hello Johannes, great video, i wanted to ask a question about this video which is i am getting a late initialisation error for late Note note in view_note_detail.dart page and i tried solving it by looking it up on stack overflow and other website but it is not working and if i make a null check to late Note note then the late initialisation error goes away but wherever i use note to access title and other details it gives error that says null check operator used on a null value (clearly the title value is not null as it shows up on the note_list page) can you please guide me on how to solve this issue?
Thank you very much.
Hello, super saiyan! Follow this link: stackoverflow.com/questions/69373859/late-initialization-error-in-flutter-because-of-startdate
I hope it will solve your problem. Thank You 🙂
@@HeyFlutter Thanks