I am a beginner in this field.
I am working with PostgreSQL, Qgis, and Q-field to collect data on the field.
As you know, I am searching for methods to keep security my database when I open a firewall to connect Qfield database on my phone to the PostgreSQL server.
If we connect the PostgreSQL database to Qgis has SSL, after that package Qgis project by Q-field plugin and send it to mobile. Is it work? Because I don't see any document talk about OpenSSL on mobile.
I see everyone prioritize choosing SSL. I also see other methods as password enhancement and configure settings with specific IP, but as you know, when I go to the field, I use 4g on my phone, this IP always changes every day.
So I want to know are there other methods to help security databases when opening a firewall to connect Q-field and PostgreSQL?