search

Artelia / Mascaret

Pre and Post Processing for Mascaret
GNU General Public License v3.0
3 stars 3 forks source link

Use a remote PostGIS server #7

Open lucduron opened 6 years ago

lucduron commented 6 years ago

Dear developers,

I tried to configure Mascaret plugin to a remote PostGIS server (server and client are not on the same machine). I managed to connect it to QGIS but I am facing this error at the creation of the database tables with Mascaret: error_mascaret

Moreover is there a specific reason why the username has to be to postgres? It would be interesting to determine it from the authentication input parameters instead of being hardcoded.

Could it be possible to support spatialite, which is lighter and easier to use on a PC? The database consists indeed in a portable standalone file and it does not rely on a client-server principle. SQL queries and python bindings are probably similar between both RDBMS.

Thank you in advance for your help. Luc

lucduron commented 6 years ago

Is there a document/file describing the database structure and which tools is modifying what that you could provide us? I generated quickly an entity–relationship model of the database and I attached it here, if it can be usefull for other users.

mascaret_dbb

ccoulet commented 3 years ago

Dear developers,

I tried to configure Mascaret plugin to a remote PostGIS server (server and client are not on the same machine). I managed to connect it to QGIS but I am facing this error at the creation of the database tables with Mascaret: error_mascaret

Moreover is there a specific reason why the username has to be to postgres? It would be interesting to determine it from the authentication input parameters instead of being hardcoded.

Could it be possible to support spatialite, which is lighter and easier to use on a PC? The database consists indeed in a portable standalone file and it does not rely on a client-server principle. SQL queries and python bindings are probably similar between both RDBMS.

Thank you in advance for your help. Luc

Hi Luc On this specific point we worked recently on this subject for another purpose and we solved some issues which are probably related to the encountered problem. Maybe you could try again with latest version 3.1.0

Regards

ccoulet commented 3 years ago

On the documentation of the data structure, there is nothing existing for the moment. We will think to add such information on the wiki (at least a view of the model like you shown )