From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham
	autolearn_force=no version=3.4.4
X-Google-Thread: 103376,9e81fa53486a4934
X-Google-NewGroupId: yes
X-Google-Attributes: gida07f3367d7,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder2-2.proxad.net!newsfeed.arcor.de!newsspool4.arcor-online.net!news.arcor.de.POSTED!not-for-mail
Date: Fri, 30 Jul 2010 09:32:13 +0200
From: Georg Bauhaus <rm-host.bauhaus@maps.futureapps.de>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.2.7) Gecko/20100713 Thunderbird/3.1.1
MIME-Version: 1.0
Newsgroups: comp.lang.ada
Subject: Re: What is your preferred VCS?
References: 
 <24890919-000d-4b75-8556-0585e8a2f59d@g21g2000prn.googlegroups.com>
 <a1bca3fc-c324-4385-87db-d3b3d626aee4@i18g2000pro.googlegroups.com>
In-Reply-To: 
 <a1bca3fc-c324-4385-87db-d3b3d626aee4@i18g2000pro.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <4c527ffd$0$6766$9b4e6d93@newsspool3.arcor-online.net>
Organization: Arcor
NNTP-Posting-Date: 30 Jul 2010 09:32:13 CEST
NNTP-Posting-Host: eb9dcce0.newsspool3.arcor-online.net
X-Trace: 
 DXC=Eh8V1UU8lTF78PK[oJ2ng@McF=Q^Z^V3H4Fo<]lROoRA8kF<OcfhCOKb]0=LcU[4[APCY\c7>ejVHaBLPQ78TOeMg0Je?jUh0JB
X-Complaints-To: usenet-abuse@arcor.de
Xref: g2news1.google.com comp.lang.ada:12699
Date: 2010-07-30T09:32:13+02:00
List-Id: <comp.lang.ada>

On 7/30/10 4:27 AM, deadlyhead wrote:

> For those who like Monotone: is using a "real database" really that
> much of advantage?  I'm a bit leery of such an opaque system being
> used to save my patches.  Having physical file-system access to
> changes makes _me_ feel a bit more secure,

I find dumping and importing of Monotone's sqlite databases reassuring.
(It never felt equally promising when something went wrong in darcs's file
system storage area...)

Output of the .dump command is SQL text.  Example first lines of
a repository, copied from a real repository:

BEGIN TRANSACTION;
CREATE TABLE files
         (
         id primary key,   -- strong hash of file contents
         data not null     -- compressed contents of a file
         );
INSERT INTO "files" VALUES(X'8C9C5E5179290FF93F3024391C1FAACB1BD393EE',X'1F8B08000000000000FFAD595B6F134B127EE757B
4FCB0198BC4109ECEC231524808EBDD00511C402B8446ED71C79E3D76B777A6872452B4BF7...

Easy backup; 7bit network transport works; file system independence;
explicit relations;...
An email, secured as necessary, stuffed with a dumped repository
will serve as permanent file storage for smaller projects...

I guess that everything to be had via SQL from Monotone's ER model
is not that easily had from a journalling file system. Even when
the hand full of tools like ls, awk, and some VC specific programs
can be used to create an RDMS, will it be simpler or more secure
than some industry standard data base?