Re: [technology-pmc] berkly db alternative

[Jody Garnett <jody.garnett@xxxxxxxxx>]

Thanks Gabriel, perhaps we should move this to the geogig email list - for the details.

Is there any other obvious technology we should be evaluating? It is really a shame about the berklyDB sleepy cat license..

--

Jody Garnett

On 30 July 2015 at 15:20, Gabriel Roldan <groldan@xxxxxxxxxxxxxxxx> wrote:

Hello,

I've used MapDB in the past, specifically in a geogig branch, as a temporary index when building large revision trees.

I'm not particularly impressed by its performance, but that aside, which could be a matter of suboptimal use or configuration, I would rather give a chance to a more consolidated library/db.

Specifically, I think there's a chance the SQLite backend could be improved to achieve higher performance, using similar tricks to the ones I've applied to the postgres backend to the same effect. For instance, I'm under the impression the low performance exhibited by the current SQLite implementation is due to the choice of using a VARCHAR(40) field as primary index, holding the text representation of each object's SHA1 hash, whereas the postgres implementation uses an int field as (non unique but fast) index plus a runtime disambiguation with the whole sha1 hash.

All those provided we find the time to work on it, of course.

Cheers,

Gabriel

On Thu, Jul 30, 2015 at 2:38 PM, Jody Garnett <jody.garnett@xxxxxxxxx> wrote:

Thanks, was evaluating MapDB yesterday (due to reputation and existing CQ).

--

Jody Garnett

On 29 July 2015 at 20:08, James Hughes <jnh5y@xxxxxxxx> wrote:

Jody,

Have you considered MapDB?  http://www.mapdb.org/ (Version 1.0.2's CQ: https://dev.eclipse.org/ipzilla/show_bug.cgi?id=8246)

SQLite seems to have a version through IP review: https://dev.eclipse.org/ipzilla/show_bug.cgi?id=7013  (I didn't read if the CQ covers use of the database or the just the jdbc driver.)

Other than that, Accumulo is a key/value database;)

Jim

----- Original Message -----

From:

"LocationTech Technology project PMC mailing list" <technology-pmc@xxxxxxxxxxxxxxxx>

To:

"Technology PMC" <technology-pmc@xxxxxxxxxxxxxxxx>

Cc:

Sent:

Wed, 29 Jul 2015 14:58:52 -0700

Subject:

[technology-pmc] berkly db alternative

Just a quick question, geogig is held up on the java implementation of berklydb. I think all we need is a key/value database - does anyone have one they would recommend? Or is there a key/value database that is already popular enough to pass IP checks...

--

Jody Garnett

_______________________________________________
technology-pmc mailing list
technology-pmc@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://locationtech.org/mailman/listinfo/technology-pmc

_______________________________________________
technology-pmc mailing list
technology-pmc@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://locationtech.org/mailman/listinfo/technology-pmc

--

Gabriel Roldán
Software Developer | Boundless
groldan@xxxxxxxxxxxxxxxx
@boundlessgeo

_______________________________________________
technology-pmc mailing list
technology-pmc@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://locationtech.org/mailman/listinfo/technology-pmc