We are undertaking an Android project but need to connect to postgreSQL开发者_高级运维 server which we use throughout our other projects. Any suggestions on a starting point for this? Is there anything out there (paid or unpaid) that will allow us to achieve this?
I realize that this is a pretty general question, and although we have extensive experience with writing desktop client/server apps, we have little experience with programming for mobile devices.
I would write a RestFUL API or WebService to be used as front end for your Android device to connect to your PostgreSQL backend.
I don't think you will be able to connect directly your Android App to a PostgreSQL database.
I'd go with a lightweight REST interface that would talk to PostgreSQL in the backend. Have a look at Simple.
I would approach this by implementing an intermediary web service. The Android application would send requests to the web service, which would serve as a gatekeeper to isolate the PostgreSQL server from the internet at large.
精彩评论