<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Bruno,</p>
<p>Unfortunately it is a known issue that Geopackages and QGIS are
bad at handling simultaneous write and even read requests and
developers are working on finding solutions (hopefully soon). In
single user scenarios Geopackages are fine. But Multiuser must be
avoided, even for reading only, unfortunately.<br>
</p>
<p>As to PostgreSQL vs. Postgis: Postgis is the spatial extension of
PostgreSQL. If you need geometries (which I assume) than you will
need Postgis.</p>
<p>Andreas<br>
</p>
<div class="moz-cite-prefix">Am 06.05.20 um 08:58 schrieb
<a class="moz-txt-link-abbreviated" href="mailto:brunos@mailbox.org">brunos@mailbox.org</a>:<br>
</div>
<blockquote type="cite"
cite="mid:1016461748.112620.1588748323413@office.mailbox.org">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="UTF-8">
<div class="io-ox-signature">
<p>Hi<br>
</p>
<p>In my company we are five people who sometimes work with GIS,
and we are moving from ArcGIS to QGIS (how cool is QGIS and
SLYR!) and in this context from ESRI file geodatabase to
geopackage. Today we run into serious issues when two people
worked with the same geopackage. I was aware, that it is
dangerous and unwise to edit the same geopackage from two
different computers at the same time. But I did not expect
both QGIS applications to crash immediately and the geopackage
to get corrupted. I hoped to get a warning or simply not be
able to enter edit mode (We later found out, that the
corrupted geopackage could be recoveredby by adding a new
table, this somehow fixed it. Whew!). <br>
</p>
<p>Worse, I found that the same thing happens, when I open a
QGIS project with a layer from a geopackage for display only
(no edit mode), which is being edited by an other user on an
other computer. Again, both QGIS application crashed
immediately with data loss. Again, the non-responsive QGIS
tasks could not be killed by windows taskmanager, only by
restarting of the computers.</p>
<p>We are using QGIS 3.12.2 on Windows 10. The Geopackages are
located on a samba network share.<br>
</p>
<p>My questions:</p>
<p>1. Is this setup that bad? Do you experience the same fatal
consequences if someone loads a layer from a geopackage which
is being edited by someone else? Is there something I do wrong
or I that can do to improve the situation?<br>
</p>
<p>2. I realize, that we should probably move from geopackage to
a database. Do we need PostGIS or can we use PostgreSQL? We
don't need more functinality than a geopackage offers (exept
multi user read/edit possibility and stability).<br>
</p>
<p>Many thanks for some hints that put me in the right
direction!<br>
</p>
<p>Bruno</p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</body>
</html>