Mailing-List: contact jackrabbit-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jackrabbit-dev@incubator.apache.org
Received-SPF: pass (asf.osuosl.org: domain of stefan.guggisberg@gmail.com
 designates 64.233.162.203 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=LgOyYig4dRulSaxqTb5ebrBPG9eyyB/RqnFysSJronIIAW7H3AzJouj9cp1/l1EZwmS5GKoQYxgAEFF7T+jHyS7oYcL0TXPPSCMOQ/ZIEHOzYBCBpv2t2vRgIZdwRPuuynwmonEftpUdEpJVNUYCuAKWM+Fz5/eW6/klgKBQXtg=
Message-ID: <90a8d1c00601060340r69cf5843m70b58070521a601f@mail.gmail.com>
Date: Fri, 6 Jan 2006 12:40:36 +0100
From: Stefan Guggisberg <stefan.guggisberg@gmail.com>
To: jackrabbit-dev@incubator.apache.org
Subject: Re: svn commit: r366207 - in
 /incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core:
 fs/db/ state/db/
In-Reply-To: <90a8d1c00601060327m14267a17i1c15495a0cea6c23@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20060105154824.66997.qmail@minotaur.apache.org>
	 <43BD6944.6070508@mvdb.net>
	 <90a8d1c00601060327m14267a17i1c15495a0cea6c23@mail.gmail.com>

oops, sorry, i hit the 'send' button too soon ;)

On 1/6/06, Stefan Guggisberg <stefan.guggisberg@gmail.com> wrote:
> hi martin
>
> On 1/5/06, Martin van den Bemt <mllist@mvdb.net> wrote:
> > Hi Stefan (and others),
> >
> > I am not yet using jackrabbit (little expirements though), but when I d=
o, I like to get "rid" of the
> > ddl and use ddlutils [*] for that, so there is one schema, from which d=
dl can be generated (saves a
> > lot of maintenance)
> > DDLUtils isn't yet released and support for daffodil is not yet there, =
so we need to finish that first.
> > Are you willing to consider such a patch ?
>
> generally i think that ddlutils is a very good and usefull and well
> documented tool.
> the "supported databases" section i found particularly helpful.
>
> i have to admit though that i am rather sceptic regarding the benefit
> of replacing
> the .ddl files with ddlutils. the current mechanism is IMO very simple
> yet efficient.
> does ddlutils support placeholders in schema object names, e.g.
> "create table ${schemaObjectPrefix}NODE ..."? another issue: the schema u=
sed
> is extremely simple. i prefer to 'tune' the schema for specific
> backends rather than
> restricting myself to the least common denominator. an example:

mysql:
 ... FSENTRY_PATH text not null, FSENTRY_NAME varchar(255) not null, ...

db2:
 ... FSENTRY_PATH varchar(745) not null, FSENTRY_NAME varchar(255) not null

both columns are indexed but db2 restricts the size of an index entry
to approx. 1k.

conclusion: if using ddlutils doesn't add complexity and a lot of new
dependencies
but still supports the current flexibility i wouldn't be against using it.

cheers
stefan

>
> >
> > Mvgr,
> > Martin
> > [*] http://db.apache.org/ddlutils
> >
> > stefan@apache.org wrote:
> > > Author: stefan
> > > Date: Thu Jan  5 07:48:07 2006
> > > New Revision: 366207
> > >
> > > URL: http://svn.apache.org/viewcvs?rev=3D366207&view=3Drev
> > > Log:
> > > fixed svn:eol-style properties for .ddl files
> > >
> > > Modified:
> > >     incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/ja=
ckrabbit/core/fs/db/daffodil.ddl   (contents, props changed)
> >
>