[QGIS-Developer] Plugin [1305] Calidad-CAR approval notification.

[noreply]

Plugin Calidad-CAR approval by pcav.
The plugin version "[1305] Calidad-CAR 1.1.0.p3" is now approved
Link: http://plugins.qgis.org/plugins/CalidadCAR/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] gpkg syncing issue

[Paolo Cavallini]

nothing to do with multiwrite, but with backupping and syncing.
I have a dir of shp that I sync with a couple of servers, and I
incrementally backup the dir. All fine and efficient. With gpkg the
packages will be saved over and over again even if unchanged.
this is a very serious limitation in professional contests, IMHO.
Cheers.

On 13/03/19 18:01, Daniele Viganò wrote:
> That comes from the fact that a GeoPackage is essentially an SQLite DB,
> and SQLite 3 uses WAL by default [1]
> 
> See Even reply for workarounds. Anyway SQLite is not meant to be used
> with multiple writing processes.
> 
> Cheers,
> Daniele
> 
> [1] https://www.sqlite.org/wal.html
> 
> On Wed, Mar 13, 2019 at 5:44 PM Paolo Cavallini  > wrote:
> 
> Hi all,
> when a geopackage is opened in QGIS, even if no change is made, the file
> is marked as changed. This can cause nightmares when syncing data,
> because if two users open a gpkg without editing, it is hard to decide
> what to do. Same for backups.
> Is there a way to avoid this?
> Thanks.
> -- 
> Paolo Cavallini - www.faunalia.eu 
> QGIS.ORG  Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org 
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> 
> 
> -- 
> *Daniele Viganò*
> http://daniele.vigano.me
> 
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Gpkg: raster slowdown

[Paolo Cavallini]

yes, the raster goes well. Is when you drop it in a gpkg that slows
down, at least here.
thanks.

On 13/03/19 18:05, Daniele Viganò wrote:
> Hi Paolo,
> 
> the raster you provided is working very well on my setup (QGIS 3.6 on
> Fedora 29);
> even without pyramids the rendering takes milliseconds, including when
> zooming and/or panning.
> 
> Daniele
> 
> 
> On Wed, Mar 13, 2019 at 4:37 PM Paolo Cavallini  > wrote:
> 
> Hi all,
> if I drag6drop this raster:
> https://www.faunalia.eu/~paolo/250010.tif
> (no projection, it is indeed 3003) into a gpkg, loading it from there
> slows down horribly QGIS, even if I reassign the proper projection
> afterwards. Any clue? Could somebody confirm?
> qgis 3.6, debian sid here.
> Thanking in advance.
> Regards.
> -- 
> Paolo Cavallini - www.faunalia.eu 
> QGIS.ORG  Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org 
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> 
> 
> -- 
> *Daniele Viganò*
> http://daniele.vigano.me

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Gpkg: raster slowdown

[Daniele Viganò]

Hi Paolo,

the raster you provided is working very well on my setup (QGIS 3.6 on
Fedora 29);
even without pyramids the rendering takes milliseconds, including when
zooming and/or panning.

Daniele


On Wed, Mar 13, 2019 at 4:37 PM Paolo Cavallini 
wrote:

> Hi all,
> if I drag6drop this raster:
> https://www.faunalia.eu/~paolo/250010.tif
> (no projection, it is indeed 3003) into a gpkg, loading it from there
> slows down horribly QGIS, even if I reassign the proper projection
> afterwards. Any clue? Could somebody confirm?
> qgis 3.6, debian sid here.
> Thanking in advance.
> Regards.
> --
> Paolo Cavallini - www.faunalia.eu
> QGIS.ORG Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer



-- 
*Daniele Viganò*
http://daniele.vigano.me
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] gpkg syncing issue

[Daniele Viganò]

That comes from the fact that a GeoPackage is essentially an SQLite DB, and
SQLite 3 uses WAL by default [1]

See Even reply for workarounds. Anyway SQLite is not meant to be used with
multiple writing processes.

Cheers,
Daniele

[1] https://www.sqlite.org/wal.html

On Wed, Mar 13, 2019 at 5:44 PM Paolo Cavallini 
wrote:

> Hi all,
> when a geopackage is opened in QGIS, even if no change is made, the file
> is marked as changed. This can cause nightmares when syncing data,
> because if two users open a gpkg without editing, it is hard to decide
> what to do. Same for backups.
> Is there a way to avoid this?
> Thanks.
> --
> Paolo Cavallini - www.faunalia.eu
> QGIS.ORG Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer



-- 
*Daniele Viganò*
http://daniele.vigano.me
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Gpkg: raster slowdown

[Paolo Cavallini]

Hi Even,

On 13/03/19 17:47, Even Rouault wrote:

> did you try to generate pyramids ? I assume the slowness you see is for zoom 
> out views.

I didn't try, as the problem seems entirely different: even opening the
properties by double clicking on the legend takes several tens of
seconds, and the cpu stays at 100% forever.
Cheers.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] gpkg syncing issue

[Paolo Cavallini]

Hi Even,

On 13/03/19 17:53, Even Rouault wrote:
> Yes this is a known inconvenience (pretty sure there might be bugs open on 
> this) due to opening GPKG files in write-ahead mode, so as to avoid issues in 
> case of concurrent editing (probably helps also in situations of single 
> editing where one thread does writing, and others are reading)
> 
> You can set the OGR_SQLITE_JOURNAL = DELETE environment variable, or the qgis/
> walForSqlite3 = false setting to avoid that (but run in the possible above 
> mentionned issues)

thanks for the detailed and prompt explanation. So, the old shp strikes
back, far more convenient in this situation, unfortunately.
Regards.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] gpkg syncing issue

[Even Rouault]

On mercredi 13 mars 2019 17:44:11 CET Paolo Cavallini wrote:
> Hi all,
> when a geopackage is opened in QGIS, even if no change is made, the file
> is marked as changed. This can cause nightmares when syncing data,
> because if two users open a gpkg without editing, it is hard to decide
> what to do. Same for backups.
> Is there a way to avoid this?

Yes this is a known inconvenience (pretty sure there might be bugs open on 
this) due to opening GPKG files in write-ahead mode, so as to avoid issues in 
case of concurrent editing (probably helps also in situations of single 
editing where one thread does writing, and others are reading)

You can set the OGR_SQLITE_JOURNAL = DELETE environment variable, or the qgis/
walForSqlite3 = false setting to avoid that (but run in the possible above 
mentionned issues)

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Gpkg: raster slowdown

[Even Rouault]

On mercredi 13 mars 2019 16:37:01 CET Paolo Cavallini wrote:
> Hi all,
> if I drag6drop this raster:
> https://www.faunalia.eu/~paolo/250010.tif
> (no projection, it is indeed 3003) into a gpkg, loading it from there
> slows down horribly QGIS, even if I reassign the proper projection
> afterwards. Any clue? Could somebody confirm?
> qgis 3.6, debian sid here.
> Thanking in advance.
> Regards.

Paolo,

did you try to generate pyramids ? I assume the slowness you see is for zoom 
out views.

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] gpkg syncing issue

[Paolo Cavallini]

Hi all,
when a geopackage is opened in QGIS, even if no change is made, the file
is marked as changed. This can cause nightmares when syncing data,
because if two users open a gpkg without editing, it is hard to decide
what to do. Same for backups.
Is there a way to avoid this?
Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Gpkg: raster slowdown

[Paolo Cavallini]

Hi all,
if I drag6drop this raster:
https://www.faunalia.eu/~paolo/250010.tif
(no projection, it is indeed 3003) into a gpkg, loading it from there
slows down horribly QGIS, even if I reassign the proper projection
afterwards. Any clue? Could somebody confirm?
qgis 3.6, debian sid here.
Thanking in advance.
Regards.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [1616] Hqgis approval notification.

[noreply]

Plugin Hqgis approval by pcav.
The plugin version "[1616] Hqgis 0.4.2 Experimental" is now approved
Link: http://plugins.qgis.org/plugins/Hqgis/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [1587] Instituto Canario de Estadística (ISTAC) approval notification.

[noreply]

Plugin Instituto Canario de Estadística (ISTAC) approval by pcav.
The plugin version "[1587] Instituto Canario de Estadística (ISTAC) 0.2" is now 
approved
Link: http://plugins.qgis.org/plugins/istacqgis/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [1650] Navtable approval notification.

[noreply]

Plugin Navtable approval by pcav.
The plugin version "[1650] Navtable 0.1.1" is now approved
Link: http://plugins.qgis.org/plugins/NavTable/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [925] GBIF Occurrences approval notification.

[noreply]

Plugin GBIF Occurrences approval by pcav.
The plugin version "[925] GBIF Occurrences 0.3.2" is now approved
Link: http://plugins.qgis.org/plugins/qgisgbifapi/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [925] GBIF Occurrences approval notification.

[noreply]

Plugin GBIF Occurrences approval by pcav.
The plugin version "[925] GBIF Occurrences 0.3.1" is now approved
Link: http://plugins.qgis.org/plugins/qgisgbifapi/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [784] MongoConnector approval notification.

[noreply]

Plugin MongoConnector approval by pcav.
The plugin version "[784] MongoConnector 1.2.1" is now approved
Link: http://plugins.qgis.org/plugins/MongoConnector/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [1391] Asistente LADM_COL approval notification.

[noreply]

Plugin Asistente LADM_COL approval by pcav.
The plugin version "[1391] Asistente LADM_COL 1.5.0" is now approved
Link: http://plugins.qgis.org/plugins/asistente_ladm_col/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Plugin [1491] GIS4WRF approval notification.

[noreply]

Plugin GIS4WRF approval by pcav.
The plugin version "[1491] GIS4WRF 0.14.0" is now approved
Link: http://plugins.qgis.org/plugins/gis4wrf/
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer