atom feed37 messages in org.apache.lucene.solr-devRe: Can we use Berkley DB java in Solr
FromSent OnAttachments
Noble Paul നോബിള്‍ नोब्ळ्Dec 1, 2008 1:42 am 
Ian HolsmanDec 1, 2008 3:05 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 1, 2008 3:14 am 
Grant IngersollDec 1, 2008 2:21 pm 
Noble Paul നോബിള്‍ नोब्ळ्Dec 1, 2008 8:20 pm 
Chris HostetterDec 1, 2008 9:24 pm 
Noble Paul നോബിള്‍ नोब्ळ्Dec 1, 2008 10:02 pm 
Yonik SeeleyDec 2, 2008 6:29 am 
Andrzej BialeckiDec 2, 2008 7:11 am 
Yonik SeeleyDec 2, 2008 7:45 am 
Jason RutherglenDec 2, 2008 8:05 am 
Andrzej BialeckiDec 2, 2008 8:41 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 2, 2008 8:44 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 2, 2008 8:46 am 
Yonik SeeleyDec 2, 2008 9:02 am 
Dawid WeissDec 2, 2008 9:03 am 
Shalin Shekhar MangarDec 2, 2008 9:08 am 
Yonik SeeleyDec 2, 2008 9:25 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 2, 2008 10:12 am 
Ryan McKinleyDec 2, 2008 9:00 pm 
Noble Paul നോബിള്‍ नोब्ळ्Dec 2, 2008 10:28 pm 
Andrzej BialeckiDec 3, 2008 2:59 am 
Grant IngersollDec 3, 2008 4:22 am 
Ryan McKinleyDec 3, 2008 5:43 am 
Mark MillerDec 3, 2008 5:47 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 3, 2008 7:19 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 4, 2008 12:43 am 
Sami SirenDec 4, 2008 7:20 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 4, 2008 7:29 am 
Ryan McKinleyDec 4, 2008 8:22 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 4, 2008 8:32 am 
Yonik SeeleyDec 4, 2008 8:37 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 4, 2008 8:47 am 
Yonik SeeleyDec 4, 2008 11:26 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 4, 2008 8:49 pm 
Yonik SeeleyDec 5, 2008 6:16 am 
Noble Paul നോബിള്‍ नोब्ळ्Dec 5, 2008 8:45 am 
Subject:Re: Can we use Berkley DB java in Solr
From:Grant Ingersoll (gsin@apache.org)
Date:Dec 3, 2008 4:22:07 am
List:org.apache.lucene.solr-dev

On Dec 3, 2008, at 1:28 AM, Noble Paul നോബിള്‍ नोब्ळ् wrote:

The code can be written against JDBC. But we need to test the DDL and data types on al the supported DBs

But , which one would we like to ship with Solr as a default option?

Why do we need a default option? Is this something that is intended to be on by default? Or, do you mean just to have one for unit tests to work?

I don't know if it is still the case, but I often find embedded dbs to be quite annoying since you often can't connect to them from other clients outside of the JVM which makes debugging harder. Of course, maybe I just don't know the tricks to do it. Derby is one DB that you can still connect to even when it is embedded.

Also, whatever is chosen needs to scale to millions of documents, and I wonder about an embedded DB doing that. I also have a hard time believing that both a DB w/ millions of docs and Solr can live on the same machine, which is presumably what an embedded DB must do. Presumably, it also needs to be able to be replicated, right?

H2 looks impressive. the jar (small) is just 667KB and the memory footprint is small too --Noble

On Wed, Dec 3, 2008 at 10:30 AM, Ryan McKinley <ryan@gmail.com> wrote:

check http://www.h2database.com/ in my view the best embedded DB out there.

from the maker of HSQLDB... is second round.

However, from anything solr, I would hope it would just rely on JDBC.

On Dec 2, 2008, at 12:08 PM, Shalin Shekhar Mangar wrote:

HSQLDB has a limit of upto 8GB of data. In Solr, you might want to go beyond that without a commit.

On Tue, Dec 2, 2008 at 10:33 PM, Dawid Weiss <dawi@cs.put.poznan.pl>wrote:

Isn't HSQLDB an option? Its performance ranges a lot depending on the volume of data and queries, but otherwise the license looks BSDish.

http://hsqldb.org/web/hsqlLicense.html

Lucene Helpful Hints: http://wiki.apache.org/lucene-java/BasicsOfPerformance http://wiki.apache.org/lucene-java/LuceneFAQ