Hi Stewart -
Postgres is definitely the right choice if several users needs write
access to the same layer at the same time.
(I can barely believe I write the next sentence..) If the municipality
already has a MS SQL Server installation, you can create spatial layers
on this server that can be edited by multiple users too.
Mind you, the Postgres solution is - by a million miles - the best
solution. But using MS SQL Server is better than trying to use
GeoPackages in your situation.
As a GIS- and database consultant in Denmark - a very, very
"Microsoft-friendly" country - I've used MS-SQL Server for spatial data
when installation Postgres was an absolute "no-no". MS SQL Server is
less stable and 3 times slower when using it for spatial data than
Postgres. But it kinda works.
Med venlig hilsen / Best regards
Bo Victor Thomsen
On 18/03/2025 18.05, Stewart Galloway via QGIS-User wrote:
I have data stored on a municipal server.
Can I have two users, each on their own computer, access the same .QGS
project file (as well as the same data on the municipal server)?
Is that what a GeoPackage is for? Or is Geopackage just for the data
and not for the project file (QGS)?
Or do I use PostgreSQL?
Thanks.
Stewart
_______________________________________________
QGIS-User mailing list
[email protected]
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
QGIS-User mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
