Flutter SQLite Tutorial With Null Safety || Notes App in Hindi/Urdu with CRUD Operations
HTML-код
- Опубликовано: 26 сен 2021
- In this video i will teach you how to we can use sqlite database in out flutter app to create the notes app. In this video i will also teach you how we can add the data to database, how we can fetch the list of data we store in database. How to delete and update the data in sql database.
How to capture image from camera in flutter:
Link : • How to capture Image f...
My Card App Flutter :
User Circular Avatar Part 1 : • My Card App || Flutter...
Use fonts in flutter Part 2 : • My Card App || Flutter...
Final Part 3 : • My Card App || Flutter...
Hire me on Fiverr : www.fiverr.com/rnsolution
Covid-19 Tracker App using Rest API's : • Create Coronavirus (CO...
Firebase Blog App Android Java: • Firebase Blog App - Ho...
C++ Tutorials : • C++ Programming Tutori... .
_____________/Connect On Social Media\____________
► Instagram:➜ / axif_taj
► Facebook:➜ / aaxiftaj
► Twitter:➜ / axiftaj
► GitHub:➜ github.com/axiftaj
=========================================
For business queries : axiftaj@gmail.com
Thank you for watching my channel do give feedback about this video.
#flutter #fluttertutorial #sqlite #sql #sqflite #expandedwidget #listview builder #firebasetutorial #asiftaj - Наука
thank you so much sir .. i was struggling for two days to learn it but you made it halwa .... Allah taala apko jazai khair dy
glad to hear this
When I saw your post here, then blindly hit like button.
Thankyou sir🙏
Thank you so much do share with your friends.
One of the best sqlite flutter vedio in RUclips
thank you
Jabh bhi aapki videos dekhta hun toh muje aapki khaansi yaad aajati h :)
Heheheheh
Thank You Sir❤
Most welcome
Many many thanks, its working
Enjoy
That's really amazing Bro
Thank you so much 😀
@@thetechbrotherss u welcome sir😄...
I attended your all sessions in DS4KP and when ever you explain any complex concept I understand it like English alphabet really sir,
I wish you are my mentor sir
Thank you so much for your kind. Keep watching keep sharing.
@@abdurrehman6203 aslam o alikum sir how to read data from external file sqlite
Can you please show, how to keep the last item at the top? I tried shrinkWrap and reverse. It works when the list items are inside the page. But when the list grows, the newly created item stays behind the appBar.
you can reverse your array list not the listview builder and then it will sort the data. Or you can add time stamp and then fetch the data in ascending order using time stamp. Beside this set reverse == true in listview builder and wrap children with container and give it height like your card height is 20 then give it a height * your list length. I won't recommend this last method.
Future getNotesList() async {
var dbClient = await db;
final List queryResult = await dbClient!.query('notes');
return queryResult.map((e) => NotesModel.fromMap(e)).toList().reversed.toList();
}
Change the code in db_handler.dart file
Basically humne phle list bnaya fir usko reverse kr diya
There is a glitch in your code,let me explain
you declare id as nullable,so if somebody doesnot provide value of model class during insert method the id will be auto generated and when we will view there will be error 'String is not a subtype of null',So we have to check if any value is empty the id should not be auto generated,I dont know how to this at this time
I'm assuming you will not let user pass null values, this is just to make you understand concepts rest you can play with this
Everything is going above my head, I don't understand the Map thing, you could have explained this while creating map and db_ as I'm beginner and not understand a single word. But I really appreciate your effort and skill sharing brother
.
I agree sir I haven’t share the knowledge i was supposed to share. I am making this video private and will create new video
thank you very much sir this app is complete or have a part two that have a data from user
This is complete
pls provide github link of project in description, which you explain on youtube , so that is more use full for new learner of flutter.
Ok
Salam, have you make tutorial on Rest API model class data with sqflite? i wanna make my app( which one getting data from API) offline, which one get data from API, store in sqflite and app get data from data base, in short offline app, please hep
You can can use these concepts for api you can watch my api playlist.
is source code available?
I m failing due to an error
I have taken 3 fields only
error "incomplete input in "CREATE TABLE contacts (id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT NOT NULL,detail TEXT NOT NULL""
yes github.com/axiftaj do leave a star
conflictAlgorithm: ConflictAlgorithm.replace
use this in insert function
Sir can u plz help me? I m getting null safety error in each and every place of database can u plz help me?
Please uninstall the app and re run it after adding package else see the source
code github.com/axiftaj
THANK YOU SO MUCH.
I tried more than 20 methods but it didn't work.
But it worked with the code you wrote. Thanks .
I have a few questions.
How do I access this database file from outside with VSCode.
Can you elaborate your question, "outside with VSCode" ?
@@thetechbrotherss i have done a web and desktop project with c# and mssql. i also did a mobile project with flutter. I dec to make a connection between them.
@@thetechbrotherss i tried using mssql in flutter, but I got errors.
bhai kiya hum notes ko store kar sakte hai in mobile app yes than how ?
Jaise is lectured ma kia hain waise kr skty ha
In software houses ai calling and firebase is more demanded
Yes, you can say that. But this was just a simple tutorials to teach some basic concepts of SQL in flutter with example so you can use them according to your requirements like creating cart etc.
Assalam o Alikum ! when you make the notesModel.from contructer you decleared the Map.............but in body when you assighn the value to id it gives error because id is not type of string it is integer so brother make it correct and declear the type of map to object and dynamic
Thank you for sharing your knowledge sir
@@thetechbrotherss No prob Brother .........and Please call me Brother because i am also Student 😛
I have an error on list view.
Please always state your issue in first comment. Any ways you can check the source code on my github account github.com/axiftaj
Sir write kis tarah karengay data dynamically.
take values from user and write insert query like we did in this course
Can you please explain , how you have removed null safe after refreshing dependencies? I have tried your method but null check error is still there.
you cna take the source code from github.com/axiftaj
@@thetechbrotherss I have checked the source code but the Model class is missing there. Can you please share the repository which has model class ?
@@thetechbrotherss Sir github me notes.dart screen nhi hain sir mian bi is main stuck hoya ho
@@machodge2021 same problem
@@thetechbrotherss home screen bi nhi hain our notes screen bhi nhi hain
bhai Sqflite database ke upar ak new video La do basic to advanced how to store , fetch , delete data . Ye video me thora samajh nahi a raha dhang se .please aap isi video ke code ko reuse karke ak baar dhang se new tareke samjha do . Thank you
Ok bro
I faced an error which is "unexpected null value"what i do and in your vedio you also faced the error of nullable value and you said that you guys referesh the project i did many time but the error still
what i do
take code from my github.com/axiftaj
Plz name of directory
Sir one video is create image store in SQLite database
ok
Bro.... Your Efforts are Appreciatable No Doubt, But Please Do Mention & Eloborate What are your doing in the Tutorial...Don't Do It Like Procedure ..Yess its Going to be Super Easy but at your Level Not for Begginers.
I appreciate your feedback and agree with you, this was an old tutorial and this is the only tutorial where i didn't explain very well. I am sorry
bhaiya isme rest api bhi include h kya
ni, rest api ki alag playlist ha
Sir vedio ki length ziada hu jaye koi issue nhi h but explain zrur krain jasy is vedio m thanks sir 👍
ok
Kindly tell me how to Show the data table in DB browser.
bhai used table widget if you want to show data in tables and map the data.
@@thetechbrotherss G shukrya bhai
Bhai kindly 1 or chez bta dain k agr hm user sy Database update krwa rhen hain to update k bad usy save kesy kren gy??
Okay
Hello
easiest ...
Subscribe and share
Great video sir. Is there any way that I can contact you as I am a beginner and I was hoping that you can assist me?
Linked in or insta or you can join my facebook community.
Sir this is very lengthy code for me i m a new student how can i learn this 😢
you should start from my bootcamp
Sir comment thora lengthy ho gya ha but complete parhiy ga. shukriya !
sir app ya btaty hai k kia krna ha or ksy krna ha but ya ni smjhaty k yahi q krna ha or ya krny sy hoga kia. to pleas why pr bhi focus kia kry.
for example 7:08 pr ap ny ya to bta diya k NoteModel.fromMap .............. but ya ni btaya k ya hum use q kr rahy ha.
ya sirf example thi isi tarha hota ha baqio me bhi taqreeban. sir kindly naraz ni hona ya ak feedback ha. because jab hum is tarha learn kry gy smjh to lgy gi ni or ratty wala system ho jay ga but programing ratta ni hoti. ma sha allah ap parhany ka treeqa acha ha, jo coding methedology ya strategy use krty ha wo bhi sae hota ha . bus teaching ko improve krny k liy why pr bhi focus zarur kia kry. is sy humry learningme bhi izafa ha ga.
Ma ap ki bat sy agree krta hu, yeah mere pehle playlist this jb mainy tutorials bnana start kia tha
muje itna idea ni tha k kiss level par ja k smjhana ha r kya explain krna
main is playlist ko down krta hu, is playlist ma muje same feedback mila ha
lkn jo new content ha it's of next level, i received really good feedback
@@thetechbrotherss to sir yahi cheezy agr smjhni ho sae sy details me to ap ny is playlist ko update kia ho ya krny ka plan ho. Q k ap jia sequence me lekr gay hai chezo ko it really appreciative.
Late initialisation error notesList😢
Please help me
take the source code from my github
Table notes has no column named I'd in insert into notes
Error ❎
Spelling Mistake ✅
Thank you for feedback ❤️
Source code
Do subscribe and share with your friends.
github.com/axiftaj/SQL-Notes-App
source code?
check my github.com/axiftaj
@@thetechbrotherss Bhai Source code ka link rukh do description ma github pr to nhi mila
Sir AAP kitna mistake kyu karte hai😢
I agree, This was my first video i wont recommend you watching this
Watch my latest playlist