Re: [geogig-dev] mapdb

[Gabriel Roldan <groldan@xxxxxxxxxxxxxxxx>]

Hi there,

The plan is to make sqlite the default storage format for local/single repos. There's also work in progress on a PostgreSQL backend to hold multitenant repos where the object database is shared between repos, hence making cloning an almost instant operation (i.e. just need to duplicate the refs and other smaller things).

As for the storage format in the case of PostgreSQL, we'd be using geogig's own binary serialization, at least to start with. Given the serialization format is pluggable, a JSONB one is feasible, though haven't put any thought on it yet.

The current mongo and sqlite backend implementations are functional though both seem to be lacking on the performance department. Haven't had time to really optimize the mongo one, but been working on optimizing the sqlite one in order to make it a feasible replacement for the default storage backend.

Hope that helps.

Gabriel 

On Thu, Aug 20, 2015 at 10:10 AM, <Schmidt.Sebastian2@xxxxxx> wrote:

Hi everyone,

while doing some research into a Berkley DB substitute last month, I've found mapdb
as well - and independently - there seems to be some coincidence. The project is currently quite active, but a one-man-show as it seems. I don't
have experience with it either, but I agree it sounds promising.

Another candidate might be orientDB (http://orientdb.com/why-orientdb/).
Seems to have an embeddable part as well, but at first glance I didn't
find out if the "embeddable" part is Open Source as well (the "community
edition" Server part is Apache2 Licensed).

We could also think about a PostgreSQL backend storage (many will have one on their systems anyhow), PostgreSQL has moved a bit in directions of NoSQL-Storages (key/value Storage) with its JSONB Datatype new in 9.4

In the geogig's github repo I found drivers to store inside MongoDB and
Sqlite - are these ready and working or still some work-in-progress?
Could they help us out on the locationtech incubation issue when making
sqlite the default storage format?

Kind regards, Sebastian
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
http://www.locationtech.org/mailman/listinfo/geogig-dev

--

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