<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html lang="en">
<head><meta http-equiv="Content-Type" content="text/html;">
<title>Scalix message content</title>
<style type="text/css">
<!--
.Normal { text-align: left; text-indent:0pt; margin-top:0pt; margin-bottom:0pt; font-family: Arial; font-size: 12pt; }
.Default_Paragraph_Font {font-family: Arial; color: Black; background-color: white ; font-size: 12pt; font-weight: normal; font-style: normal; font-variant: normal; vertical-align: normal; text-decoration: none;}
div.ltTOCtitle { font-family: Verdana; font-size: 8pt; font-weight: bold; text-align: center;}
div.ltTOCl1 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:32pt; text-indent:-32pt;}
div.ltTOCl2 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:40pt; text-indent:-32pt;}
div.ltTOCl3 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:48pt; text-indent:-32pt;}
div.ltTOCl4 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:56pt; text-indent:-32pt;}
div.ltTOCl5 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:64pt; text-indent:-32pt;}
div.ltTOCl6 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:72pt; text-indent:-32pt;}
-->
</style>
</head>
<body>
<div class="Normal"><span style='font-size: 10pt; '>Ivan</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>As I understand your
approach correct your aim is to historize table records. But that's not the aim
of the pgversion approach. pgversion supports concurrent editing like SVN. To
keep all non committed records it is neccessary to log them in a seperate table
via materialized views. </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>>One more question, how
is the view '<tablename>_version'
performing</span><br><span style='font-size: 10pt; '>>in case of huge tables
?</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>What is a huge table. We use
pgversion with tables containing more than 100'000 records and it works
fine.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Of course it is possible to
combine pgversion with the different historisation approaches. </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Regards</span><br><span style='font-size: 10pt; '>Horst</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>------------------------------------------------</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Dr. Horst
Düster</span><br><span style='font-size: 10pt; '>Stv. Amtschef / kantonaler
GIS-Koordinator </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Kanton
Solothurn</span><br><span style='font-size: 10pt; '>Bau- und
Justizdepartement</span><br><span style='font-size: 10pt; '>Amt für
Geoinformation</span><br><span style='font-size: 10pt; '>SO!GIS
Koordination</span><br><span style='font-size: 10pt; '>Rötistrasse
4</span><br><span style='font-size: 10pt; '>CH-4501 Solothurn</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Telefon ++41(0)32 627 25
32</span><br><span style='font-size: 10pt; '>Mobil ++41(0)79 511 54
12</span><br><span style='font-size: 10pt; '>Telefax ++41(0)32 627 22
14</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>mailto:horst.duester@bd.so.ch</span><br><span style='font-size: 10pt; '>http://www.agi.so.ch</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>-----Ursprüngliche
Nachricht-----</span><br><span style='font-size: 10pt; '>Von: Ivan Mincik
[mailto:ivan.mincik@gmail.com]</span><br><span style='font-size: 10pt; '>Gesendet
am: Sonntag, 7. November 2010
23:28</span><br><span style='font-size: 10pt; '>An: Horst
Düster</span><br><span style='font-size: 10pt; '>Cc:
qgis-developer@lists.osgeo.org</span><br><span style='font-size: 10pt; '>Betreff:
Re: [Qgis-developer] Announcement: PostGIS Versioning
System</span><br><span style='font-size: 10pt; '>pgversion and QGIS
Plugin</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>On Sun, Nov 7, 2010 at 3:44
PM, Horst Düster <horst.duester@kappasys.ch>
wrote:</span><br><span style='font-size: 10pt; '>> I just finished the first
beta version of my newly released pgvs
support</span><br><span style='font-size: 10pt; '>> system. The idea of this
system is to enable the editing of a
single</span><br><span style='font-size: 10pt; '>> PostGIS layer concurrently
by more than one user at the same
time,</span><br><span style='font-size: 10pt; '>> similar to source code
versioning systems like CVS or Subversion.
You</span><br><span style='font-size: 10pt; '>> will find further
informations at:</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Congratulations, this is
much needed stuff. I wonder why such
tools</span><br><span style='font-size: 10pt; '>are not discussed at PostGIS
list.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>I really admire Your work
with one exception, which pushed me
to</span><br><span style='font-size: 10pt; '>develop my own tools (based on Your
ideas) [1].</span><br><span style='font-size: 10pt; '>What I do not like is,
that after enabling version support,
all</span><br><span style='font-size: 10pt; '>editing is done against newly
created view '<tablename>_version'
(and</span><br><span style='font-size: 10pt; '>set of belonging RULES). This
works well in all software which
doesn't</span><br><span style='font-size: 10pt; '>care if You are loading pure
TABLE or VIEW. In my work, we are
trying</span><br><span style='font-size: 10pt; '>to support as many GIS client
as possible.</span><br><span style='font-size: 10pt; '>For example Manifold GIS
is setting read only mode by default,
when</span><br><span style='font-size: 10pt; '>loading VIEW (What about ESRI ?
or CadCorp SIS ?). In this case,
such</span><br><span style='font-size: 10pt; '>tools are unusable. You never
knows, when somebody implements
similar</span><br><span style='font-size: 10pt; '>behavior in new version of
Your software.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>One more question, how is
the view '<tablename>_version'
performing</span><br><span style='font-size: 10pt; '>in case of huge tables
?</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>For somebody interested in
my work, look here [1] (published
source</span><br><span style='font-size: 10pt; '>code is quite
outdated)</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>[1]
http://www.mail-archive.com/postgis-users@postgis.refractions.net/msg11834.html</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Ivan</span><br><span style='font-size: 10pt; '>_______________________________________________</span><br><span style='font-size: 10pt; '>Qgis-developer
mailing
list</span><br><span style='font-size: 10pt; '>Qgis-developer@lists.osgeo.org</span><br><span style='font-size: 10pt; '>http://lists.osgeo.org/mailman/listinfo/qgis-developer</span></div>
</body>
</html>