How to use Postgresql or MySQL database offline on Android?

Question

I am looking for a way to use either PostgreSQL or MySQL (I am using the former, but I could just find a way to export it to MySQL and use that one) database offline.

I need to be able to query a database offline on an Android device.

Is it possible? Using JDBC it should be possible, isn't it?

What do you mean by "offline"? Do you mean that the DBMS resides locally on your Android device? — mbeckish
– mbeckish, Commented Feb 22, 2012 at 18:28
I am producing an application. I want some information to be available offline (without internet connection). The simplest way to use the same queries but being offline. — N3sh
– N3sh, Commented Feb 22, 2012 at 18:32
And what process will be executing those queries? Are you proposing installing a MySQL server on your Android device? — mbeckish
– mbeckish, Commented Feb 22, 2012 at 18:34
That's the problem. I want to release this application, what would you suggest to use? I need something that resembles the use of a DBMS, in terms of speed and ease of use. — N3sh
– N3sh, Commented Feb 22, 2012 at 18:37
In that case, I believe the standard solution for Android is SQLite databases: developer.android.com/guide/topics/data/data-storage.html#db — mbeckish
– mbeckish, Commented Feb 22, 2012 at 18:48

maniek · Accepted Answer · 2012-02-22 18:50:56Z

5

use SQLite . It is available out-of-the-box, and supported since version 1.

answered Feb 22, 2012 at 18:50

maniek

7,3252 gold badges24 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

How to use Postgresql or MySQL database offline on Android?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related