<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Stewart -</p>
<p>Postgres is definitely the right choice if several users needs
write access to the same layer at the same time. </p>
<p>(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. </p>
<p>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. <br>
</p>
<p>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.<br>
</p>
<pre class="moz-signature" cols="72">Med venlig hilsen / Best regards
Bo Victor Thomsen</pre>
<div class="moz-cite-prefix">On 18/03/2025 18.05, Stewart Galloway
via QGIS-User wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1855063623.2989335.1742317548413@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="yahoo-style-wrap"
style="font-family:arial;font-size:16px;">
<div dir="ltr" data-setdir="false">
<div>
<div dir="ltr">I have data stored on a municipal server.</div>
<div dir="ltr">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)?</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">Is that what a GeoPackage is for? Or is
Geopackage just for the data and not for the project file
(QGS)?</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">Or do I use PostgreSQL?</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">Thanks.</div>
<div dir="ltr">Stewart</div>
<div dir="ltr"><br
style="font-family: arial; font-size: 16px; letter-spacing: -0.32px;">
</div>
</div>
<br>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
QGIS-User mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</body>
</html>