[Qgis-user] Remote Access by Multiple Users

[Greg Troxel]

Andreas Neumann via QGIS-User <qgis-user at lists.osgeo.org> writes:

> For Multi-User data editing I definitely recommend using PostgreSQL
> (the server should be in the same LAN than the clients
> editing).

By 'same LAN', do you mean "same Ethernet, meaning no IP routing" or
just "on the same premises so you have Gigabit speed and only a few
milliseconds of latency"?   I would expect that it is only performance
that matters, and several-ms gigabit-speed is fine.

I am also curious how well it works if say the pgsql server is 80 ms RTT
away, with a link such that one can get 2 MB/s usually.   I realize it's
going to be slower, but I'm interested in hearing experience.

> Geopackage isn't designed for multi-user editing. Two users using
> Geopackage "read only" should work though.

Even worse, access to files across SMB, when the programs expect to do
locking, is asking for trouble.

> The QGIS project can be stored in Geopackage or PostgreSQL, but is
> normally a separate file (.qgz or .qgs). The project file doesn't
> store the geodata but only the references to the files, databases or
> web services as well as any configuration and styling.

When you do this, is it basically storing a blob with what would have
been written to qgs in a table of projects?

What happens if multiple people try to use the same project?  Are
changes by one person propagated back to others as they are opened?
How are write-write conflicts handled?

Or is the norm that projects are opened readonly by most people, and
rarely changed?

(Or the question I should have asked; I haven't tried to do multiuser
qgis.)