[Qgis-user] GeoPackage deadlocks (Andrea Peri)

[Paul Wittle]

Hi,

I think my perspective is more related to whether or not the documentation / software is guiding the users to the right conclusion. It is clear that multiple users should not be editing the same file but my original question had two points really:

  *   Does the user/software know someone else is already editing?
  *   Should the software permit it at all?

My current thought is that QGIS probably doesn’t know how many people are reading or writing to the file and so it is unable to give the user any messages that would drive good practice. I’m unclear myself whether the issue is caused by two editors or just one editor and one or more reader. I’d have to do more testing on that but basically it would be great if it just popped up and said you can’t edit this file as someone else has it open for editing.

That hopefully sounds good but the bigger issue appears to be how do you do it?

Paul

P.S. I have heard about the compression issue but I was hoping that will be resolved in the future given the prominence given to the format but the OGC.



From: Luigi Pirelli <luipir at gmail.com>
Sent: 27 September 2019 09:56
To: Tobias Wendorff <tobias.wendorff at tu-dortmund.de>
Cc: Andrea Peri <aperi2007 at gmail.com>; qgis-user <qgis-user at lists.osgeo.org>; Paul Wittle <P.Wittle at dorsetcc.gov.uk>
Subject: 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: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Book: Mastering QGIS3 - 3rd Edition<https://www.packtpub.com/eu/application-development/mastering-geospatial-development-qgis-3x-third-edition>
* Hire a team: http://www.qcooperative.net
**************************************************************************************************


On Fri, 27 Sep 2019 at 10:50, Tobias Wendorff <tobias.wendorff at tu-dortmund.de<mailto:tobias.wendorff at tu-dortmund.de>> wrote:
Am 27.09.2019 um 10:24 schrieb Andrea Peri <aperi2007 at gmail.com<mailto:aperi2007 at gmail.com>>:
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).

The only reason is indexing and this could be forked off GPGK and Spatialite.

To the topic: I think, it‘s always a bad idea to let multiple users work on a single SQLite-based database. It hasn‘t been created for this reason.
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org<mailto:Qgis-user at lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
This e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. It may contain unclassified but sensitive or protectively marked material and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All traffic may be subject to recording and/or monitoring in accordance with relevant legislation. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Dorset Council. Dorset Council does not accept service of documents by fax or other electronic means. Virus checking: Whilst all reasonable steps have been taken to ensure that this electronic communication and its attachments whether encoded, encrypted or otherwise supplied are free from computer viruses, Dorset Council accepts no liability in respect of any loss, cost, damage or expense suffered as a result of accessing this message or any of its attachments. For information on how Dorset Council processes your information, please see www.dorsetcouncil.gov.uk/416433
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190927/6672ac22/attachment.html>