Hi Greg, On Wed, 19 Mar 2025 at 13:33, Greg Troxel via QGIS-User < qgis-user@lists.osgeo.org> wrote:
> Andreas Neumann via QGIS-User <qgis-user@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. > It is mainly an issue of "latency", but also bandwidth. There are a lot of SQL queries between QGIS and PostgreSQL. Every zoom and pan means several SQL queries. If the latency is bad, then it isn't a lot of fun to work with a remote PostgreSQL server. In a case where the PostgreSQL server is at another company location with a high latency in between than it should be considered to use more than one PostgreSQL server and replication between the servers, in order to offer a low latency to all QGIS clients. > > 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? > yes > > 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? > There is no conflict handling. The one that writes last wins. > > Or is the norm that projects are opened readonly by most people, and > rarely changed? > This depends of course on the workflow and situation. I don't think one can make a general statement here. Andreas
_______________________________________________ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
