On Dec 3, 2008, at 7:22 AM, Grant Ingersoll wrote:
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 with h2 (unless you are using the in memory version) Check the
possible connection modes:
http://www.h2database.com/html/features.html#connection_modes
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 can take millions of docs.. but as long as we just rely on JDBC,
the SQL scale/replication becomes a standard/known/solved problem
ryan
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 <[EMAIL PROTECTED]>
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
<[EMAIL PROTECTED]>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
Dawid
--
Regards,
Shalin Shekhar Mangar.
--
--Noble Paul
--------------------------
Grant Ingersoll
Lucene Helpful Hints:
http://wiki.apache.org/lucene-java/BasicsOfPerformance
http://wiki.apache.org/lucene-java/LuceneFAQ
