> Two processes accessing geopackage on a local computer can run into
the same issue. SQlite is designed for a single user.
Interesting. SQlite can most definitely handle multiple users -
certainly reading, and for writing if it's not over the network, I
expect the processes are breaking one (
Il gio 17 ott 2019, 12:54 Patrick Dunford ha
scritto:
> It's not a network issue and neither is it a Windows issue. Two
> processes accessing geopackage on a local computer can run into the same
> issue. SQlite is designed for a single user. It is very reliable when
> used as designed.
>
Maybe i
It's not a network issue and neither is it a Windows issue. Two
processes accessing geopackage on a local computer can run into the same
issue. SQlite is designed for a single user. It is very reliable when
used as designed.
On 27/09/19 7:13 PM, Paul Wittle wrote:
Hi Andrea and Enrico,
Thank
dorff ; Andrea Peri
> Cc: qgis-user ; Paul
> Wittle Subject: Re: [Qgis-user]
> GeoPackage deadlocks (Andrea Peri)
>
>
>
> (A little late).
>
> TL;DR: at least for QGIS, is - never multi-user edit
> SQLite/SpatiaLite/GeoPackages on network file systems.
>
?
greeting from Poland
Jarosław Sadowski
From: Qgis-user On Behalf Of Jonathan Moules
Sent: Monday, October 7, 2019 4:17 PM
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is
he
> functionality above myself using Python.
> >
> > Cheers,
> > Paul
> >
> > From: Jonathan Moules
> > Sent: 07 October 2019 15:17
> > To: Tobias Wendorff ; Andrea Peri <
> aperi2...@gmail.com>
> > Cc: qgis-user ; Paul Wittle <
> p.wit
From: Qgis-user On Behalf Of Jonathan Moules
Sent: Monday, October 7, 2019 4:17 PM
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
SQLi
ality above
myself using Python.
Cheers,
Paul
From: Jonathan Moules
Sent: 07 October 2019 15:17
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
SQLite/SpatiaLite/GeoPackages on network file systems.
SQLite, (and therefore SpatiaLite and
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
SQLite/SpatiaLite/GeoPackages on network file systems.
SQLite, (and therefore SpatiaLite and GeoPackage) has quite a few
caveats when it comes to multiple users trying to edit it at once.
https://www2.sqlite.org/howtocorr
: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
I suppose the question by Andrea was related if using a different qgis provider
continue to generate the deadlock
Luigi Pirelli
**
* LinkedIn
I suppose the question by Andrea was related if using a different qgis
provider continue to generate the deadlock
Luigi Pirelli
**
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange:
> Am 27.09.2019 um 10:24 schrieb Andrea Peri :
>
> Have you tried to use spatialite instead of geopackage. ?
Why not plain SQLite? Nobody needs and uses the spatial functions of
Spatialite, they are even not part of bloatware GPKG (sorry, the created
db-files are huge without any compression).
.com>>;
qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
without resting importance to the issue, reading the bug report, I can read you
moved from oracle spatial to geopackage! w
I hope that provides sufficient background but you can probably see it’s
> not going well really as I’ve had to change my advice three times already.
>
> Paul
>
>
>
> *From:* Luigi Pirelli
> *Sent:* 27 September 2019 08:59
> *To:* Paul Wittle
> *Cc:* Alessandro Pasot
To: Paul Wittle
Cc: Alessandro Pasotti ; qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
without resting importance to the issue, reading the bug report, I can read you
moved from oracle spatial to geopackage! why not postgis?
Luigi Pirelli
y further relevant comments as I’ve not got it as well documented as I’d
> like. Sorry, time constraints in the office.
>
>
>
> Many thanks,
>
> Paul
>
>
>
>
>
> *From:* Alessandro Pasotti
> *Sent:* 27 September 2019 08:20
> *To:* Paul Wittle
> *Cc:* qg
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
On Fri, Sep 27, 2019 at 9:13 AM Paul Wittle
mailto:paul.wit...@dorsetcouncil.gov.uk>>
wrote:
Hi Andrea and Enrico,
Thank you for providing an answer even if it was not what I was hoping to hear;
it was the conclusion I
>In both cases my gut feel is that the best solution might
>be to look into use detection. If GDAL (I assume) can be
>improved to detect that either file type is already open
>then it might be possible to simply ban a second user
>from opening the file at the same time. This might
>frustrate some u
On Fri, Sep 27, 2019 at 9:13 AM Paul Wittle <
paul.wit...@dorsetcouncil.gov.uk> wrote:
> Hi Andrea and Enrico,
>
> Thank you for providing an answer even if it was not what I was hoping to
> hear; it was the conclusion I'd reached myself.
>
> Has this issue been considered given the official move
Hi Andrea and Enrico,
Thank you for providing an answer even if it was not what I was hoping to hear;
it was the conclusion I'd reached myself.
Has this issue been considered given the official move from shapefile to
geopackage as the default format?
My understanding was that shapefiles could
21 matches
Mail list logo
