Android SQLite Tutorial - 1 - Create database and tables

How to create a simple database in android and how to add a table to it.

[sanjaydeshpande]

Excellent tutorial Prabeesh. Easy to follow and understand. I could successfully write my first SQLite database app. Thanks so much.

[ehsanset]

Hi PRABEESH R K
your videos are really great. I watched them and learned a lot. especially your sqlite videos were helpful for me. I hope you keep going with making this tutorials and helping people. good luck

[imranshaikh]

This video is very helpful me and my friends...will you please upload another videos?
THANK YOU SIR

[vickman]

Just what I was looking for !!! Thank you :D

[tblanchette]

Knowledgeable, and good info. Just wish it wasn't so monotone, or bland.

[jobardfranck]

A way to download your project code somewhere ? i would like to start sqlite coding but i haven't your starting example.
I saw your blog but no source code...
Very good job you did with your video for us !

[anuragshukla]

HI PRABEESH, first of all thank u for such a tutorial, its really good.
now i  m trying to make an app in which i want to take some input from a user  like his name contact no. and other optional based info.
and then i want to store it into a database. later i want to show that information to only to admin(a new app that connets with this customer info app).
i dont know how to do it, so pls help me if u can.
thank you

[samrusso]

Excellet tut!
Can i get a copy of the eclipse project for this tutorial?

[sheylahilaresramos]

Do u have another tutorial with android studio ? :)

[HyperActive]

hi bro, should i watch it in 2020?
or too many changes?

[pervasyncuser]

Pervasync just released a new version (7.0.0) of its sync framework that supports synchronization of Android SQLite databases with a central PosrgreSQL database. That's in addition to the already supported Oracle, MySQL and SQL Server databases.

Synchronization could be two-way, meaning writes can be done on both local and  central databases. Data being synced can be defined by a sub-setting query.  Change capture, conflict detection and resolution are built in to the core of the sync system.

BTW for central database, you can use one of the Amazon RDS cloud databases.

[baskarboss]

You just read the comments....Everyone want this video in android studio.

[ChintanPatel]

PLease Reupload Video using Android Studio

[xodemifanxo]

sir can we create this table using sqlite manager???

[AntonioDivaira]

Could anybody explain why at 8:00 I can not search for a Superclass Selection. I would appreciate any help. Many thanks. This is great tutorial as far as I can see.

[mobyboy]

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?

[kartiggessan]

Your tutorial was nice. I had tried to change the coding with your coding. It works well in android emulator but it won't works in real android like samsung galaxy grand prime lolipop version. Pls help me immediately.

[rimamasri]

Thank you for the valuable videos; however, I have a small question here, when I tried to modify the database table to have three columns instead of two, I got a run time error when trying to get call getInformation. Any idea why I got this problem. Note that I was able to putInformation successfully. Thanks

[nicoles]

Good day! Do you have any tutorial on how to import an SQLite database to Android Studio? I have created my database using SQLite manager but I can't seem to figure out how to import it on my Android project.

[vanis]

Very Nicely explained tutorial for Beginners in android coding like me. But I have some doubts, I tried to execute this code using eclipse and sqlite exe file installed on my system. what more i need to successfuly execute this code.somebody please help me. Any solutions would be helpful. Thanks a lot in advance.