From users-return-13286-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Thu Nov 12 08:58:15 2009
Return-Path:
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 8788 invoked from network); 12 Nov 2009 08:58:15 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
by minotaur.apache.org with SMTP; 12 Nov 2009 08:58:15 -0000
Received: (qmail 11901 invoked by uid 500); 12 Nov 2009 08:58:15 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 11860 invoked by uid 500); 12 Nov 2009 08:58:14 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help:
List-Unsubscribe:
List-Post:
List-Id:
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 11844 invoked by uid 99); 12 Nov 2009 08:58:14 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 08:58:14 +0000
X-ASF-Spam-Status: No, hits=-2.6 required=5.0
tests=BAYES_00
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of ianboston@googlemail.com designates 74.125.78.26 as permitted sender)
Received: from [74.125.78.26] (HELO ey-out-2122.google.com) (74.125.78.26)
by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 08:58:11 +0000
Received: by ey-out-2122.google.com with SMTP id 25so540836eya.3
for ; Thu, 12 Nov 2009 00:57:50 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=googlemail.com; s=gamma;
h=domainkey-signature:received:received:sender:message-id:from:to
:in-reply-to:content-type:content-transfer-encoding:mime-version
:subject:date:references:x-mailer;
bh=ji31OUydZQllN/gg59vjNj/Y13mlgd/5HCUs/1IJils=;
b=FPwEnv5a4EC/fhlbbwV1EqGUWR4HzRjsvtIexIyciSPw7IvUp1NUvQEQSd/MaK0anE
PVv3awI8eT9+UEAZnHUVC9IkuZNY+deTeljho93VTG7d59W7MwbXsKV+0xgX5oyj9Mc2
w3XHO85oAu2e9YJZ2661a1XGAtUsBTVNPQHko=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=googlemail.com; s=gamma;
h=sender:message-id:from:to:in-reply-to:content-type
:content-transfer-encoding:mime-version:subject:date:references
:x-mailer;
b=R5Qx9f34YU7L6QUc7HuEj1JjnJg3rWLEnLBoGT7GPG6BLJYltp1giCY33TmYEQllEO
crtxoREzrgmZtpCTWfNr/Vb03EHRrLfkdKFE77GHLBMstUK+IkHoik6yZFqHYRDg/Hvc
iZE3EYqAs5eIgT3pmLaXvEeaMHzxLQOs9eeWc=
Received: by 10.213.2.71 with SMTP id 7mr7235057ebi.88.1258016269897;
Thu, 12 Nov 2009 00:57:49 -0800 (PST)
Received: from ?192.168.1.69? (78-105-202-108.zone3.bethere.co.uk [78.105.202.108])
by mx.google.com with ESMTPS id 7sm2809123eyg.1.2009.11.12.00.57.48
(version=TLSv1/SSLv3 cipher=RC4-MD5);
Thu, 12 Nov 2009 00:57:48 -0800 (PST)
Sender: Ian Boston
Message-Id: <5DF43020-AD7E-43AA-9E2E-926704596FA5@tfd.co.uk>
From: Ian Boston
To: users@jackrabbit.apache.org
In-Reply-To: <4edfbae60911120038g515efb57ra09ad89bf66e85a6@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v936)
Subject: Re: JCR vs relational database + Hibernate
Date: Thu, 12 Nov 2009 08:57:47 +0000
References: <4edfbae60911120038g515efb57ra09ad89bf66e85a6@mail.gmail.com>
X-Mailer: Apple Mail (2.936)
On 12 Nov 2009, at 08:38, danisevsky wrote:
> Hallo, I am thinking about learning and using Jackrabbit instead of
> (or
> with) relational database (+ Hibernate) in my new web application. I
> would
> like to store some data to JCR (on filesystem) and some data to
> database.
> But question is for which kind of data si better JCR. My opinion is
> that
> data like photos, blogs, comments is better storage JCR and data
> like users,
> roles, classifiers is better database.
> What do you think, is it right?
Yes, right :)
I/We have been following a similar route, put everything in JCR and
build relational indexes via JPA where necessary. (we use Eclipse Link
since it works on its own on OSGi, we also use Apache Sling since it
already does 90% of what we need from a webapp).
So we have event listeners in JCR that trigger the indexing of items
into relational tables via JPA. We can then query using JPA and
retrieve sorted ordered list of pointers to items in JCR. I say we
have this, but in fact we haven used it yet. Development has been
going 6 months, we have close to 80% of the code us cases for the back
end covered and all our query needs so far have been served by JCR
queries. I am going to leave the functionality in place since who
knows when someone might come up with a massive relational join that
cant be answered in JCR.
Looking back, I think the reason we haven't used it is we have taken
time over modeling the structure of the content in JCR so that access
is either direct, or there is sufficient metadata to allow JCR queries
to work. The one massive benefit in all of this has been the
assumption that we have no SQL schema and don't need to maintain all
the code base that that entails. Everything is much more direct.
HTH (all IMHO)
Ian
> Thanks