Crate: Elastic Data Store

[watson]

Have anybody any experience with this DB they would like to share here?

[mping]

I took a spin a few weeks ago, it seemed like it would be a great fit to our needs: - we store alot of metrics for custom KPIs - we don't do joins - we don't need transactions - we're write once read heavy, sometimes re-write - crate's sharding, partitioning and replication, as well as "sql" api is great for our use case

I even implemented some custom aggregation functions to check out the code, and it was easy. But what I liked the most was the responsiveness of the devs, the project seems to be moving at a good pace and the devs were very helpful over github.

I wished the site made clear that it's using ElasticSearch under the hood, though. I don't know a thing about ES so I can't really comment on how the sharding, partitioning and replication are achieved. What I can remember from aphyr's blog (jepsen series) is that it's not recommended as a primary database though.

[otterley]

Previous discussion on HN, 6 months ago: https://news.ycombinator.com/item?id=7609323

[adrusi]

OT: the domain name crate.io confused me into thinking this was about Cargo, rust's package manager, which is documented on crates.io

[forsaken]

This domain used to be Python's new package manager as well.

It's still live under /packages/: https://crate.io/packages/requests/

[Argorak]

crate.io is older then crates.io, though.

[Kequc]

Looks great, really. I'm pretty tired of Postgresql all I want is a simple modern data store that can handle arrays and blobs. Relationships and data validation is all handled at the application level for me. I'm very interested to try this out as soon as there is an implementation for active record.

Thanks for the heads up.

[sanderjd]

> all I want is a simple modern data store that can handle arrays and blobs

I'm curious in what way Postgresql doesn't fit that, for you. Is it not "simple"?