Is there any open-source/free newsql db ?
[deleted]
that's for olap, while I was talking for oltp
NewSQL overview
21–30 of 37 posts
Re: NewSQL overview
#22MySQL/MariaDB/Percona with its different modern db engines and MySQL Cluster should be mentioned.
Re: NewSQL overview
#23It's strange he doesn't mention Google's Spanner, or references a paper ( http://static.googleusercontent.com/media/research.google.co... ).
I'm going to. I just don't want it to be half-done, and this paper requires a lot of time :(
Re: NewSQL overview
#24Is there any open-source/free newsql db ?
With the recent SQL-like query language, I think Cassandra comes pretty close to satisfying the requirements as well, as long as you don't require multi-key transactions.
It's not bad, and Apache Spark adds SQL on top of some other nosql DBs, but they are still hard to use.
Cassandra for example: you can't just put a secondary index on a table to enable sorting on it. There are secondary indexes, but they aren't useful for that (they don't perform well on high cardinality data).
Want a different sort? Make a new table. And duplicate the data, since there are no JOINs.
I find this really cumbersome.
Re: NewSQL overview
#25Is there any open-source/free newsql db ?
As a short answer - not yet, but it looks like in 2-3 years there will be at least one.
Re: NewSQL overview
#26MySQL/MariaDB/Percona with its different modern db engines and MySQL Cluster should be mentioned.
I haven't found any notion about good scalability as a feature. Could you provide a link to a good article about it so that I could mention them
Re: NewSQL overview
#27The first time I ran into the NewSQL terminology was when I checked out CockroachDB: https://github.com/cockroachdb/cockroach 'A Scalable, Geo-Replicated, Transactional Datastore' written in Go, influenced by Google's Spanner.
Thanks, I've missed it, I should definitely take a look.
Re: NewSQL overview
#28We consider ourselves NewSQL http://schemafreedb.com/ . We are looking into using Nuodb as one of our backend storage options when scalability is a concern, default is MySQL with TokuDB.
Take a look also at FoundationDB, very promising DB with a good performance and scalability.
Re: NewSQL overview
#29MySQL/MariaDB/Percona with its different modern db engines and MySQL Cluster should be mentioned.
I haven't found any notion about good scalability as a feature. Could you provide a link to a good article about it so that I could mention them
Re: NewSQL overview
#30It's a shame that most of these aren't open source.
At one point I had great hopes for RethinkDB. It seemed like a great fit when I first heard about it: It's among the newer databases, it's open source, MVCC, distributed, sharded, multi-master, and has a neat query language with some advanced features.
Unfortunately, while RethinkDB does feel very pleasant and modern, performance is pretty terrible, and it's quite lacking in some other areas.