<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Il 29/07/2016 15:30, David G. Johnston
ha scritto:<br>
</div>
<blockquote
cite="mid:CAKFQuwaD7hyCg-zdMhMF6djfz+XzuM0hOSexXW50k7N4orFU0Q(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr">
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><span
style="font-family:arial,sans-serif">On Fri, Jul 29, 2016 at
7:08 AM, Moreno Andreo </span><span dir="ltr"
style="font-family:arial,sans-serif"><<a
moz-do-not-send="true"
href="mailto:moreno(dot)andreo(at)evolu-s(dot)it" target="_blank">moreno(dot)andreo(at)evolu-s(dot)it</a>></span><span
style="font-family:arial,sans-serif"> wrote:</span><br>
</div>
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><span class="">
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">R</div>
egarding backups I disagree. Files related to
database must be consistent to the database itself,
so backup must be done saving both database and
images. </div>
</span></div>
</blockquote>
<div><br>
</div>
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">I'd
suggest you consider that such binary data be defined as
immutable. Then the only problem you have to worry
about is existence - versioning consistency goes away.
You only need focus on the versioning of associations -
which remains in the database and is very lightweight.
It is then a separate matter to ensure that all
documents you require are accessible given the
identifying information stored in the database and
linked to the primary records via those versioned
associations.</div>
</div>
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline"><br>
</div>
</div>
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">David
J.</div>
</div>
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline"></div>
</div>
</div>
</div>
</div>
</blockquote>
<p>I think you are right on this point, there are only some kind of
bytea that are not immutable, and that's where we store bytea
instead of images (many of these fields have been already
converted to text type, though)</p>
<p>Moreno<br>
</p>
</body>
</html>