Is it possible create and query a local Postgres database on an Android device?

Question

I want to store some app data in a local Postgres database. I don't need it to be accessible through internet or anything. I could use sqlite but I need Postgres's GIS features for my application.

Is it possible for an app to do this? (without rooting the phone)

or Can you compile the Postgres source code to work on Android?

@mr.incognito this link does not answer my question, as you can see the workaround provided is for sqlite, and it has no information on weather you can compile postgres on android... — Optimus
– Optimus, Commented Dec 17, 2014 at 5:03
PostgreSQL cannot be compiled for Android. And it really would make very little sense: PostgreSQL is particularly suited to large databases and multi-user access. Also, it is unlikely that you need PostGIS's functionality on an Android device. There are multiple database / spatial data apps out there; or develop your own from available toolkits. — Patrick
– Patrick, Commented Dec 17, 2014 at 5:15
@Patrick a little more research shows me that it can be done with a lot of hackery, effectively porting it myself... But I am not sure I am capable of doing that right now... — Optimus
– Optimus, Commented Dec 17, 2014 at 6:05

dericke · Accepted Answer · 2015-01-24 08:51:33Z

2

Are you aware of Spatialite? It's an extension to SQLite very similar to PostGIS. AFAIK it's available for Android and may have the features you require.

answered Jan 24, 2015 at 8:51

dericke

3044 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Is it possible create and query a local Postgres database on an Android device?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related