The database that developers are using for ANDROID?

Question

I need some information about the database that I can use in android please guide me.

Joe Wilson · Answer

Hi, Thank you very much for your answer, I will check these links.

Francis · Answer

I have experience in using SQL SERVER in C# programming, but I didn't use it in Android programming, Mostly the Android Platform uses "SQLite" DB. Because as per SQLite.org : "SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private" If you need more information refer the below url: https://www.sqlite.org/about.html Could you please explain about differences using SQL in Android? AFAIK, most of the Android developers uses SQLite. Also, SQL syntax are almost same between SQL Server and SQLite. You can see it in below url: http://www.tutorialspoint.com/sqlite/sqlite_insert_query.htm I guess, you can't run SQL Server in Android. However, your application can interact with SQL Server and pull the data. Hope i answered your question. If not let me know! :)

Joe Wilson · Answer

Hi, Well, Thank you for your answer,by the way, I have experience in using SQL SERVER in C# programming, but I didn't use it in Android programming, Could you please explain about differences using SQL in Android?

Kritika Singh · Answer

http://www.tutorialspoint.com/sqlite/ http://www.tutorialspoint.com/android/android_sqlite_database.htm http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html

Joe Wilson · Answer

Hi, Well, I now understand about this subject, Thank you. Could you please suggest a few website or links about learning SQLite?

Rajeev Punhani · Answer

Hi Joe, Two types of applications are being developed these days.1)Which have a local database .2)Which uses webservice and database is remote .For local database Sqllite is most commonly used.In the case of webservice any database can be used.

Joe Wilson · Answer

Hi, I have always heard that the database I must use for ANDROID application is SQLite , so I am hesitate about this subject, I myself interested in SQL SERVER, so do you mean I can SQL SERVER too in my android applications?

Parth Mehta · Answer

First tell me what " information about the database" you need ?? like How to create database tables or which database is select for application?

Joe Wilson · Answer

Hi, So you mean that I must learn most of the databases ?

Kritika Singh · Answer

The database used depends on the app that you are creating.

Joe Wilson · Answer

Hi, I don't get what you means about " For stand alone application SQLLITE is good. " could you please explain more?

Parth Mehta · Answer

For stand alone application SQLLITE is good. if you want to do any database operation only for that particular appication sqllite is great..

Joe Wilson · Answer

Hi, Do you mean SQLite is not the main database that developers use for ANDROID ? and they use SQL SERVER or other databases .

Parth Mehta · Answer

Basically devloper use the api for getting data that store in database(like sql or etc). but if you want to store small data then you can use SQLLITE. follow below link.. https://www.codeofaninja.com/2013/02/android-sqlite-tutorial.html http://codetheory.in/working-sqlite-database-crud-operations-android/

Sarvesh Chauhan · Answer

There are number of option available for You to database you can choose from the following sqlite json mysql,php volley api