Menu
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.
572
Install and configure PostgreSQL on Termux Once you have successfully installed this set of scripts, you can use your Android tablet or smartphone as a PostgreSQL clone database server.
PostgreSQL is available for the following operating systems: Linux (all recent distributions), 64-bit x86 installers available and tested for macOS (OS X) version 10.6 and newer – Windows (with installers available and tested for 64-bit Windows Server 2019 and 2016; some older PostgreSQL versions are tested back to ...
PostgreSQL Unlike other SQL databases, PostgreSQL is also compatible with JSON, so it accommodates more data types than just structured data. PostgreSQL is commonly used when developing a database for mobile apps that are more simple and straightforward in their design and data schema.
Can you run PostgreSQL on Raspberry Pi? The PostgreSQL can easily be installed on the Raspberry Pi just like in any other Debian-based distribution. In this write-up, PostgreSQL installation has been explained in detail.
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.
170
I'd go with a lightweight REST interface that would talk to PostgreSQL in the backend. Have a look at Simple.
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
