Unsolved Build Postgresql plugin android Version 10
-
Hi, How to build PSQL android plugin to version 10 of PSQL and use CLang or GCC, i tried compile follwing the Qt Wiki page but doesn,t work. Only work with de PSQL versions 9.X.
-
Postgre on Android? Will you connect to some remote database? For local DBs better stick with SQLite, much less hassle.
-
@sierdzio yes, i will connect to remote database, for Desktop applications i not found problems.
-
@Wesley_Morais So, you're going to expose PostgreSQL server to the internet?!
This is not a good idea. Usually a web interface is provided by the server to access the database indirectly in a controlled way without exposing the database server to the internet. -
@jsulm for now i,m using only LAN to connect my Andriod App and the Database Server.
i follow this wiki page: https://wiki.qt.io/Build_Qt_5_PostgreSQL_Plugin_for_Android
to compile the driver, but to version 10 of postgresql doesn't work.When i put the Database on internet, i will put him behind to firewall.
-
@Wesley_Morais said in Build Postgresql plugin android Version 10:
i will put him behind to firewall
How is this going to help? You still have to open the port to be able to connect.
"doesn't work" - this is not enough information. Please specify exactly what does not work.
-
@jsulm Good morning, let me explain better what i want to do.
Actualy my problem is "How to build build a plugin at version 10 of Postresql", because on this version of Postgresql (10 and UP) was implemented a new mechanism of security called SCRAM-SHA-256 and i want compile on this version too,because when this versions 9.X are obsolete, i can able to use another version more recent.
In my search on the internet, i found this wikipage: https://wiki.qt.io/Build_Qt_5_PostgreSQL_Plugin_for_Android but is not aplicable to version 10 and up of PSQL, because on this page is showed how to compile on versions 9.X and using android NDK 10e that works with GCC toolchain and the most recent versions of Qt works with the CLang toolchains. -
Hi, i found a solution.
During the compile process, was necessary add a follow flag: "--disable-strong-random", and the compile process works fine.
-
Hello.
I tried too many ways to build Qt 5.14.2 Android with QPSQL unfortunately didnt succeded. The famous page https://wiki.qt.io/Build_Qt_5_PostgreSQL_Plugin_for_Android is fully outdated since the NDK has version of 21 and above. I dont understand why QPSQL is not supplied by the Qt guys.
Any guide will be good for me to build Qt 5.14.2 with Postgresql 9 or 10 and also QPSQL plugin building.
If there is no way to do that or is the Xamarin good alternative?
-
@Hjunior I can only offer educated guesses:
- Android being mainly a Mobile operating system, trying to connect a phone to such a backend usually means exposing your database to the internet which is always a bad idea.
- There's no official pre-built binaries for Androïd which would mean additional work to maintain the build, fix the bugs, follow security updates, etc.
-
@SGaist Thanks for response.
Exposing the database is bad for you and good for some customers case, and this is not our issue with Qt. That is users' decision i think.
I see that there is no pre-built binaries but why there is no guide how to do that. Just search the internet and you will see there is no working guide. I like Qt since its the performant at any scale and want to use it with PostgreSql.
As you Qt guys, please write a guide for PostgreSql 9/10 with Ndk 21 and above if there is a way. Is it too difficult or not worthy?
-
@Hjunior said in Build Postgresql plugin android Version 10:
As you Qt guys, please write a guide for PostgreSql 9/10 with Ndk 21 and above if there is a way. Is it too difficult or not worthy?
If by that you are saying I am working for the Qt Company, then you are wrong.
As for the original guide, it was provided by a user.
@Hjunior said in Build Postgresql plugin android Version 10:
Exposing the database is bad for you and good for some customers case, and this is not our issue with Qt. That is users' decision i think.
The customer might not be aware of all the security implications of exposing a database openly. Easy VS secure, do not chose easy. Your database will get broken into and pilfered.
-
@SGaist Thanks.
Unfortunately we are at the starting point again. Where should i ask for this guide for the official Qt support.
-
@Hjunior Do you have a commercial Qt license? If you have, then you can ask Qt Company directly for support.
Change requests can be filed here: https://bugreports.qt.io/secure/Dashboard.jspa