Live data from Hacker News

Crate: Distributed SQL Database for the Age of Docker

crate.io

1–10 of 45 posts

Re: Crate: Distributed SQL Database for the Age of Docker

#4

Thought that name was familiar: https://github.com/crateio/crate.io

Hi, Spanky from Crate.io here. We still maintain the PyPI portion of the site at https://crate.io/packages

As for crates.io, I guess their entitled to choose their own name & domain, but I admit it is confusing.

Re: Crate: Distributed SQL Database for the Age of Docker

#5
post #4

Thought that name was familiar: https://github.com/crateio/crate.io

Hi, Spanky from Crate.io here. We still maintain the PyPI portion of the site at https://crate.io/packages As for crates.io, I guess their entitled to choose their own name & domain, but I admit it is confusing.

Might end up being a source of confusion for you guys, as the package manager for a major language will have much more mindshare than a database.

Re: Crate: Distributed SQL Database for the Age of Docker

#6
post #4

Thought that name was familiar: https://github.com/crateio/crate.io

Hi, Spanky from Crate.io here. We still maintain the PyPI portion of the site at https://crate.io/packages As for crates.io, I guess their entitled to choose their own name & domain, but I admit it is confusing.

I should have mentioned, the Crate.io (database) codebase is on GitHub: https://github.com/crate and this is what we're building: https://crate.io/overview/

Re: Crate: Distributed SQL Database for the Age of Docker

#7
I spent a bunch of time reading the website and I can't tell what this product does: Is it a database engine or an abstraction on top of other products?

If it's a database engine, then here are my thoughts: How is this database engine built to replace SQL and No-SQL? If it doesn't support JOINS why would I replace my SQL with it? Are transactions ACID? Why would anyone use this if there are no built-in user / group security mechanisms to protect data?

Re: Crate: Distributed SQL Database for the Age of Docker

#9

I spent a bunch of time reading the website and I can't tell what this product does: Is it a database engine or an abstraction on top of other products? If it's a database engine, then here are my thoughts: How is this database engine built to replace SQL and No-SQL? If it doesn't support JOINS why would I replace my SQL with it? Are transactions ACID? Why would anyone use this if there are no built-in user / group s…

Crate is a database engine that uses Lucene for storage and leverages portions of Elastic for cluster management. It is a NoSQL storage engine that gives you an SQL API (via REST). It does not support JOINs yet but this work is well underway and we expect a release with JOINs soon. We have several customers migrating from MySQL without JOINs (either handling joins in the application layer, using arrays in columns, or denormalizing data). Transactions are not ACID, we fall into the eventually consistent realm. And finally, not all use cases require user/group security, in fact much of the current SQL usage falls into the single user category.

I also agree that our site is not as clear as it needs to be and we're working on it already.

Re: Crate: Distributed SQL Database for the Age of Docker

#10

I spent a bunch of time reading the website and I can't tell what this product does: Is it a database engine or an abstraction on top of other products? If it's a database engine, then here are my thoughts: How is this database engine built to replace SQL and No-SQL? If it doesn't support JOINS why would I replace my SQL with it? Are transactions ACID? Why would anyone use this if there are no built-in user / group s…

Seems like it's an layer over ElasticSearch using Presto SQL parser. SQL queries are translated into ES queries.
Post reply on HN