[Qgis-user] Remote Access by Multiple Users

[Bo Victor Thomsen]

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
> 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/20250319/939901ad/attachment.htm>