MySQL Database in Android

Question

Is it possible to make MySQL Database in an Android Device to store data locally? Like we do in computers by setting up apache server and accessing database through phpMyAdmin.

I know that I can use a MySQL database stored on a remote server through php to fetch data from it. But since an internet connection is not always guaranteed, I would like to save the database locally.

Any type of database will do, but since I have some experience with MySQL therefore it is preferred.

Thanks! Any help is appreciated!

I haven't heard of this being possible, but SQLite is a database which can run embedded in your Android device. Try looking into SQLite. — Tim Biegeleisen
– Tim Biegeleisen, Commented Jun 13, 2017 at 6:25
Try sqlite. It has similar syntax as that of MySQL, or you can use Realm. — Suresh Prajapati
– Suresh Prajapati, Commented Jun 13, 2017 at 6:26
There is SQLite that you can start using right away in your android device. I do not think you would see any difference in terms of select/insert/delete statements. I assume so far that you want to approach the whole thing as a developer and not as a user.. — user2399432
– user2399432, Commented Jun 13, 2017 at 6:27

Erez · Accepted Answer · 2017-06-13 06:29:00Z

2

I think the closest thing you can have is to use sqlite3.
Sqlite is a decent SQL engine that stores data in a file (or ram)
Note that its syntax is not exactly as in mysql but it is useful.
You can choose to put the database file(s) in a private folder or on the sdcard, depending on the privacy policy you want for the database.
Note that you can open multiple sqlite instances on the same database file.

To access it, i would suggest a Tcp listener which reads line and passes them to sqlite.

answered Jun 13, 2017 at 6:29

Erez

853 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ankur Over a year ago

How to use a Tcp listener to access Sqlite. I have never worked with either of them, so I have no idea

Erez Over a year ago

Take a look at tcp listener question here

Collectives™ on Stack Overflow

MySQL Database in Android

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related