[Qgis-user] Editing GPKG from network drive

[jhubbslist at att.net]

I was just going to say, I think it's situations like this why PostGIS 
exists.


On 8/13/24 3:41 AM, Francesco Pelullo via QGIS-User wrote:
> Hi Simon,
>
> We're usually store data in .gpkg on network drive.
>
> Data access in read mode is very nice, also with dozen concurrent users.
>
> Instead, writing data in .gpkg on network drive can cause errors, 
> specially if from two or more concurrent users.
>
> This is because of limits of SQLite format. In past, there was 
> suggestions about a "semaphore" file that prevents to edit .gpkg file, 
> if another user is editing.
>
> My suggestion is: split .gpkg in smallest parts, assign every area (or 
> part) to a user, merge parts at the end.
>
> Or, use PostGIS.
>
> Regards
>
> Francesco
>
>
> Il mar 13 ago 2024, 09:30 Simon Gröchenig via QGIS-User 
> <qgis-user at lists.osgeo.org> ha scritto:
>
>     Hi list,
>
>     a project partner "sometimes" struggles to edit GPKGs that are
>     saved on a network drive. Trying to modify the GPKG in QGIS
>     results in the following error:
>
>>     Provider errors: OGR error committing transaction:
>>     sqlite3_exec(COMMIT) failed: disk I/O error
>>
>     No problems occur modifying the same GPKG when it is located on a
>     local drive.
>
>     I found the following 8-year-old qgis-user thread:
>     https://qgis-user.osgeo.narkive.com/bjrGqIjn/something-to-think-about-geopackage-and-wal
>
>     Is this thread related to the disk I/O error?
>
>     I would also like to ask if GPKGs or SQLite-DBs are still unsave
>     to use from network drives!? Is there any current information
>     about this somewhere?
>
>     Best regards
>     Simon
>
>
>     _______________________________________________
>     QGIS-User mailing list
>     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
>
>
> _______________________________________________
> QGIS-User mailing list
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240813/f1decbb5/attachment.htm>