Android OS and postgreSQL

Question

We are implementing an Android project, but you need to connect to the postgreSQL server, which we use in our other projects. Any suggestions on a starting point for this? Is there anything (paid or unpaid) that will allow us to achieve this?

I understand that this is a fairly general question, and although we have a lot of experience writing desktop client-server applications, we have little experience programming on mobile devices.

Answer 1

I would write a RestFUL API or WebService interface that will be used as an interface for an Android device to connect to your PostgreSQL server.

I don’t think you can directly connect your Android application to the PostgreSQL database.

Answer 2

I would go with a lightweight REST interface that will talk to PostgreSQL in the backend. Take a look at Simple .

Answer 3

I would apply this by implementing a mediation web service. The Android application sends requests for a web service that will serve as a gatekeeper to isolate the PostgreSQL server from the Internet as a whole.