You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by Martin van den Bemt <ml...@mvdb.net> on 2006/01/05 19:45:24 UTC
Re: svn commit: r366207 - in /incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core:
fs/db/ state/db/
Hi Stefan (and others),
I am not yet using jackrabbit (little expirements though), but when I do, I like to get "rid" of the
ddl and use ddlutils [*] for that, so there is one schema, from which ddl 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 ?
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=366207&view=rev
> Log:
> fixed svn:eol-style properties for .ddl files
>
> Modified:
> incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core/fs/db/daffodil.ddl (contents, props changed)
Re: svn commit: r366207 - in /incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core:
fs/db/ state/db/
Posted by Martin van den Bemt <ml...@mvdb.net>.
Thanx for the detailed info.
I know what to do and I see there is some work to be done :)
I'll come back to the list when I have something working (I need to have it for my system anyway)..
Mvgr,
Martin
Stefan Guggisberg wrote:
> oops, sorry, i hit the 'send' button too soon ;)
>
> On 1/6/06, Stefan Guggisberg <st...@gmail.com> wrote:
>
>>hi martin
>>
>>On 1/5/06, Martin van den Bemt <ml...@mvdb.net> wrote:
>>
>>>Hi Stefan (and others),
>>>
>>>I am not yet using jackrabbit (little expirements though), but when I do, I like to get "rid" of the
>>>ddl and use ddlutils [*] for that, so there is one schema, from which ddl 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 used
>>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=366207&view=rev
>>>>Log:
>>>>fixed svn:eol-style properties for .ddl files
>>>>
>>>>Modified:
>>>> incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core/fs/db/daffodil.ddl (contents, props changed)
>>>
>
>
Re: svn commit: r366207 - in /incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core: fs/db/ state/db/
Posted by Stefan Guggisberg <st...@gmail.com>.
oops, sorry, i hit the 'send' button too soon ;)
On 1/6/06, Stefan Guggisberg <st...@gmail.com> wrote:
> hi martin
>
> On 1/5/06, Martin van den Bemt <ml...@mvdb.net> wrote:
> > Hi Stefan (and others),
> >
> > I am not yet using jackrabbit (little expirements though), but when I do, I like to get "rid" of the
> > ddl and use ddlutils [*] for that, so there is one schema, from which ddl 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 used
> 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=366207&view=rev
> > > Log:
> > > fixed svn:eol-style properties for .ddl files
> > >
> > > Modified:
> > > incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core/fs/db/daffodil.ddl (contents, props changed)
> >
>
Re: svn commit: r366207 - in /incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core: fs/db/ state/db/
Posted by Stefan Guggisberg <st...@gmail.com>.
hi martin
On 1/5/06, Martin van den Bemt <ml...@mvdb.net> wrote:
> Hi Stefan (and others),
>
> I am not yet using jackrabbit (little expirements though), but when I do, I like to get "rid" of the
> ddl and use ddlutils [*] for that, so there is one schema, from which ddl 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 used
is extremely simple. i prefer to 'tune' the schema for specific
backends rather than
restricting myself to the least common denominator. an example:
>
> 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=366207&view=rev
> > Log:
> > fixed svn:eol-style properties for .ddl files
> >
> > Modified:
> > incubator/jackrabbit/trunk/jackrabbit/src/main/java/org/apache/jackrabbit/core/fs/db/daffodil.ddl (contents, props changed)
>