Thank you! I am doing a paid android app development course but it covers very basic SQLite, then I am doing some researchs to go deep in the topic. Your course is helping a lot!
I watched the complete tutorial of yours about sqlite databases. I had difficulties understanding it in school, however thanks to you I now know how to make use of databases in android. Thank you and Keep going! :D
Excellent example which is simple for beginners but has all the CRUD functionality for manipulating the database. I request you to give a simple tutorial on using the latest Room persistance library also for working on SQLite databases. I have searched and am not able to find a simple plain English tutorial like this for Room Persistance Library.
Thanks, man. Maybe change uppercase "ID" to "_id". It has to be like this when working with simple cursor adapters, I think.
7 лет назад+4
Just curious, I'm looking at Android tutorials on RUclips and most of them seems to be out-dated. Their codes don't work. Has there been any changes to SQLite Database since you uploaded these series?
hey brother , you are indian and your show its on 6:47 second you said AUR ( it was means here and) the last name is Marks.., you should said that and but you said "Aur" , its shows that we just get our mother tongue influence...., please don't be mind bro..thanks for teach us so good..please bro keep it up, i am also indian my brother
i appreciate these videos tremendously ...following the steps you shared, please how can i retrieve information from database and display on a new activity, pls kindly respond. thanks.
sir I am unable to fetch data that is submitted by the user in signup activity and want to store it in a string variable please make a video on this I'll be very happy to see that video of the most
In my opinion your SQLite tutorials are excellent, THANK YOU !!! Do you have a tutorial on how to search a column, and display the row results of a SQLite db file? Thanks Keep up the good work ;-))
its great tutorial i m folowing it step by step but when i checkd aftr secnd tutorial its not showing my table which i created as created in tutorial..dnt know y
thanks for the video! do you know a good solutiuon for saving the sql database to a textfile so i can easy export the data and read / print it on other platforms?
thanks .helpfull videos .i have a question about creation databases.when i finish to create a database on android studio i don't find this database in tools>android device.please help me
What dB should I select for making diet planner app . I mean in my app after BMi is displayed it's ask for what food you take in breakfast , lunch etc suggest me some thing I have stuck here
how can I execute the query String proQuery = "SELECT * FROM " + DATABASE_TABLE + " WHERE " + KEY_NAME + " LIKE '%" + keyword +"%'"; do you have any answer ?
ok. thanks thats all understood. but I need to create a database only once, not every time someone opens the app. because I want to store registers users. so How do i do it?
I have a question... If I deleted a entire row from a database. I want all the data below it to change it id accordingly. Suppose if the id columns have: 1,2,3,4,5 And if i deleted the 3 id row. I want the 4 to become 3 and the 5 to become 4 and so on. What is the code to do such. Please help me!!
Why would you that? The id represents a unique number for each row. If you change it after you've deleted a specific row, it is not unique anymore. If you just want to show a nubmer for each row in ascending order you can create a loop and iterate through each row.
if I want to create two, three or more tables.. What can I do for coding for sqlite and android studio.. Please reply me asap because Im doing this for my project.
Hi! im trying to create a database. im using android studio. after i run the app. i check in 'ANDROID DEVICE MONITOR" data\data but there is no package name there (com.android.****.****) the only folder i can see is "con" folders. any ideas?
hello sir, I m trying to add fifth attribute into my sqlite database but doing so makes the database completely empty. I am using a listview to display the db elements but it shows completely empty after adding fifth attribute. it works fine with 4 .plz help.
how to use google drive api to backup and restore db file in android application. to get back all app data when we reinstall app.. ...........pls help i search a lot on google and youtube which explain that..... there is some code on stackoverflow but but without any explanation cannot do anything .....
I am beginner at Android studio so please be tolerant to my question. I can scan ble devices as a list on my application but I do not know how to automatically store this list. How can I do it ?
Hi...I'm new at android programming and i am currently developing an app on eclipse. May i ask if there is any installation of some sort to use sqlite or eclipse already has one?. Really need help. tnx
+subash khadka chhetri Lol. I'm a beginner and I juzt understud it 2 days. It's easy. Just wanna concentrate though.. Also, Eclipse is going to be stopped as Android software..maybe by next year mid...so...
liwsten I am encountering some problems w. installing the Sqlite Manager. I tried to install it into my Firefox web browser, more than once, but then I couldn't find it in the Settings/Developer menu! Can you please help me with this problem?
9 лет назад
Steve Burrus hey guy, you look in taskbar have tool, you click tool then sqlite crop out
if i to create three tables i should also create three databasehelper or only ONE databasehelper and in onCreate i create three tables there? please help
![[#2024MAMA] BIGBANG (빅뱅) - 뱅뱅뱅 (BANG BANG BANG) + FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/EQsYfiPR9uM/mqdefault.jpg)
I like this guy, 2 years since and he's more detailed than the latest videos!!
This guy have answers for anything questions related to develop
Thank you! I am doing a paid android app development course but it covers very basic SQLite, then I am doing some researchs to go deep in the topic. Your course is helping a lot!
I watched the complete tutorial of yours about sqlite databases. I had difficulties understanding it in school, however thanks to you I now know how to make use of databases in android. Thank you and Keep going! :D
As a newbie to Android Database apps, thanks very much for these videos.
Easy to follow! Renaming my table, column names adding more columns and going well so far. Thank you for your videos!
Simple and easy to understand! Thank you so much! ❤️ From South Africa 🇿🇦
set speed to x1.25 is better, thank me later
I see at 2x
shit man. thanks
Thanks!
lol did this even without checking the comments
lol thanks
Excellent example which is simple for beginners but has all the CRUD functionality for manipulating the database. I request you to give a simple tutorial on using the latest Room persistance library also for working on SQLite databases.
I have searched and am not able to find a simple plain English tutorial like this for Room Persistance Library.
i really love your channel because it's save my time for coding and all this stuff...you provided all material to watch this videos....thanks again
If you're working with two or more tables, would you have to create a database helper for each or can you use the same helper for both?
thanx
thanks man, your tutorial helped me complete my app project I couldnt complete a month ago bcos it needed the use of sqlite
Donald J. Trump Official could you teach me how to connect database sqlite to android studio ?
Thanks, man. Maybe change uppercase "ID" to "_id". It has to be like this when working with simple cursor adapters, I think.
Just curious, I'm looking at Android tutorials on RUclips and most of them seems to be out-dated. Their codes don't work. Has there been any changes to SQLite Database since you uploaded these series?
great tutorials i have been looking for this sort of explanatory tutorials i have really learnt the expected, thanks
hey brother , you are indian and your show its on 6:47 second you said AUR ( it was means here and) the last name is Marks.., you should said that and but you said "Aur" , its shows that we just get our mother tongue influence...., please don't be mind bro..thanks for teach us so good..please bro keep it up, i am also indian my brother
Awesome video , "this is the best tutorial for beginners like me."
This is wonderful. The tutorial is easy to follow.
😁😁
I want to know if I can save the Data of accounts with SQlite!? Or it's for simple data like this table u use
One of the best videos for beginners!
Nice job 🙏🙏🙏
i appreciate these videos tremendously ...following the steps you shared, please how can i retrieve information from database and display on a new activity, pls kindly respond. thanks.
Best tutorials video!! I have ever seen. Please make some video on android multicast app(single or group chat app)
sir I am unable to fetch data that is submitted by the user in signup activity and want to store it in a string variable please make a video on this I'll be very happy to see that video of the most
Excellent tutorials ever sceen...
Very helpful, in-depth video! Thanks!
Hii sir!
How i can add two table in one database and also tell me how we can insert data in second table?
Nice app. Do you mind share your github link, because i try to copy the codes and i got lot of errors. If you have please share it.
Thanks for the Videos but now how do I simulate it from a device(My Android Phone)? Please advice...
veeerryy good video for intoduction of SQlite. keep making videos like this.
Pls tell me where the database will be stored...what to do if we want online storage for database
In my opinion your SQLite tutorials are excellent, THANK YOU !!!
Do you have a tutorial on how to search a column, and display the row results of a SQLite db file?
Thanks
Keep up the good work ;-))
its great tutorial i m folowing it step by step but when i checkd aftr secnd tutorial its not showing my table which i created as created in tutorial..dnt know y
thanks for the video! do you know a good solutiuon for saving the sql database to a textfile so i can easy export the data and read / print it on other platforms?
Great Videos. Well explained. Thanks
Excellent tutorial 👍🏻
Could you make a tutorial where you show how to get data from SQLIte to display in recyclerView?
thanks .helpfull videos .i have a question about creation databases.when i finish to create a database on android studio i don't find this database in tools>android device.please help me
What dB should I select for making diet planner app . I mean in my app after BMi is displayed it's ask for what food you take in breakfast , lunch etc suggest me some thing I have stuck here
how can I execute the query
String proQuery = "SELECT * FROM " + DATABASE_TABLE + " WHERE "
+ KEY_NAME + " LIKE '%" + keyword +"%'";
do you have any answer ?
thanks. it is very helpful .
I am facing gradle build problems man, it takes an hour, or a full day to build, it's so frustrating man, have you faced any gradle build problems?
Thank you so much for your information...
nice one.... but speed x1.5 recommended
Please create video for android tutorials for together example
ok. thanks thats all understood.
but I need to create a database only once, not every time someone opens the app. because I want to store registers users. so How do i do it?
Great video and expression. Thank you.
Which is better to use firebase or SQLite ?
Very nice man thankyou very much.
Thank you. Very informative video and the app works fine.
if we use sqlite and develop andriod app and can we launch in playstore the app , the data will be saved thr or any other database i need to use?
slam sir very helpful your videos.
how to make Quran ERD diagram in SQLITE server. How to save Quran TEXT (Urdu and Arabic) in Sqlite server
I have a question... If I deleted a entire row from a database. I want all the data below it to change it id accordingly.
Suppose if the id columns have: 1,2,3,4,5
And if i deleted the 3 id row. I want the 4 to become 3 and the 5 to become 4 and so on.
What is the code to do such. Please help me!!
Why would you that? The id represents a unique number for each row. If you change it after you've deleted a specific row, it is not unique anymore. If you just want to show a nubmer for each row in ascending order you can create a loop and iterate through each row.
i just created the table but i can't view the database file in ddms under data->data->mypackagename i can't really find database folder what do i do ?
if I want to create two, three or more tables.. What can I do for coding for sqlite and android studio.. Please reply me asap because Im doing this for my project.
Where is this database gets stored inside the file structure of the project and how do I access it remotely without the help of this class.
Awesome Tutorials thank you so much..
Thank you!Saved my day!
Hi!
im trying to create a database. im using android studio. after i run the app. i check in 'ANDROID DEVICE MONITOR" data\data but there is no package name there (com.android.****.****) the only folder i can see is "con" folders.
any ideas?
Appreciated from Pakistan
Easy and understandable thanks
hello sir, I m trying to add fifth attribute into my sqlite database but doing so makes the database completely empty. I am using a listview to display the db elements but it shows completely empty after adding fifth attribute. it works fine with 4
.plz help.
Should I use firebase or sqlite
What did you comment bruh? I can't see anything😑
Excellent Tutorials. Thank you!
agree
nice
You are a great guy!
Love your work bro
Will this still work in 2020. As the video is 5 years old ??
why you have changed constructor parameters to 1, and called super with 4 parameters
Please we need new tutorials about multi threading in sqlite
Hello. can we make a universal table with unknown number of columns or rows?
Hello ProgrammingKnowledge! do you have example for inserting and deleting pictures? i will wait for your reply. thanks!
you can not insert Image into table, you just store the path of that image
Does this database will get stored in mobile if we load and use in mobile. On data entry does apps memory increases.
Perfect video .. perfect voice (y)
Does studying databases contain math? What kind of math? Is it worth studying databases at all?
+Ognjen Krstic set theory...not arithmetic.....you have to take unions and intersections of columns in tables similar to elements in sets
What's a good book for android programming?
how to use google drive api to backup and restore db file in android application. to get back all app data when we reinstall app.. ...........pls help i search a lot on google and youtube which explain that..... there is some code on stackoverflow but but without any explanation cannot do anything .....
Why we wrt public static final ?? What is the meaning of this statement...??
Do u have any search qury from SQLite. or video
can you plz give the tutorial of converting english date into hijre using android plzzz
Is this same SQL ? And is this related with orical ?
upvote if you watched the video at 1.25 speed lol
nope, i watched it at 1.50x
try 2.0x :D
I am beginner at Android studio so please be tolerant to my question. I can scan ble devices as a list on my application but I do not know how to automatically store this list. How can I do it ?
Best And Easiest Way to Create Local (Sqlite) Database In Android - Android Tutorial : ruclips.net/video/JjSk89LMJ_8/видео.html
you are confused between Daaaatabase and Database . it sound so awkward please get used to the actual one .
data add kora jai but show hoy na kno?? show click korle close apps ase..
Hi...I'm new at android programming and i am currently developing an app on eclipse. May i ask if there is any installation of some sort to use sqlite or eclipse already has one?. Really need help. tnx
Why Eclipse man ? !
u dont need to install sqlite u can use its browser only to do your stuffs
Hey dont use eclipse. It's like going back to 19th century! Use Android Studio version 2.1 or above
yaa android studio is better but you may have sync gradle every time tedious as a beginner eclipse is good however
+subash khadka chhetri
Lol. I'm a beginner and I juzt understud it 2 days. It's easy. Just wanna concentrate though.. Also, Eclipse is going to be stopped as Android software..maybe by next year mid...so...
cool video)
liwsten I am encountering some problems w. installing the Sqlite Manager. I tried to install it into my Firefox web browser, more than once, but then I couldn't find it in the Settings/Developer menu! Can you please help me with this problem?
Steve Burrus hey guy, you look in taskbar have tool, you click tool then sqlite crop out
Can u help me table is not being created using ur tutorial??
awesome tutorial !!!
Sir why we use null in between databasename and tablename
if i to create three tables i should also create three databasehelper or only ONE databasehelper and in onCreate i create three tables there? please help
+xodemifan1xo only one databasehelper , in onCreate you create 3 tables :)
alright thanks :)
welcome :)
sir please help i have write the same code database is created but table not create
very good, thank you
how to deploy android studio with sqlite? please .
Thank you! You really helped!
muy bueno ! recomendable !
hi
when change DATABASE_NAME to Password.db & TABLE_NAME to password_TABLE the app message is unfortunately and close
What is the factory field that we put null?
I want to store mathematical equations in database, please help
Thanks a lot !