4 ms·

Is there any open-source/free newsql db ?

mathnode 12y ago
Slide 27. VoltDB. Or use posgres-xc, or mariadb 10 with galera and maxscale. Postgres has JSON storage. MariaDBB has dynamic and virtual columns, and the CONNECT engine which can now directly create new or edit existing JSON files using the SQL interface, instead of dedicated functions for JSON manipulation. https://mariadb.com/kb/en/mariadb/connect-json-table-type/ https://mariadb.com/kb/en/mariadb/connect-json-table-type/
- ddorian43 12y ago
  voltdb free has no HA postgres-xc/xl has no HA Maxscale looks like it doesn't yet offer sharding
alexandre_m 12y ago
CockroachDB is promising. https://github.com/cockroachdb/cockroach https://github.com/cockroachdb/cockroach Inspired by Google Spanner.
jrullmann 12y ago
Take a look at the Overview slide of the presentation, where this information is listed for each database the author discussed: http://image.slidesharecdn.com/newsql-2015-150213024325-conversion-gate01/95/newsql-overview-feb-2015-48-638.jpg?cb=1423817736 http://image.slidesharecdn.com/newsql-2015-150213024325-conv...
anonetal 12y ago
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.
- codeordie 12y ago
  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.
  - pkolaczk 12y ago
    This is because the top priority for Cassandra is being scalable and always-on in the first place. New features are added only if they meet these goals. Therefore you have guarantee it will always scale and it has no single point of failure, not even a temporary one, regardless of which feature you use. Some other new database engines do it in different order - first adding as many RDBMS features as possible and then making some of them kinda scalable (in some circumstances, if the phase of the moon is right, etc.). Sure, that might feel less cumbersome at the beginning on a single laptop (feels like good old RDBMS), but once you scale it out, it is far from being all roses. BTW, duplicating (denormalizing) data is the way to go if you really need scalability. In general case, joins or traditional indexes with references from the index leaves to the original data do not scale on distributed data sets.
    - ddorian43 12y ago
      You can do joins on the same partition-key + indexes(with references) only inside the partition-key.
jeremysmyth 12y ago
MySQL Cluster. http://www.mysql.com/products/cluster/features.html http://www.mysql.com/products/cluster/features.html
deleted 12y ago
[deleted]
- ddorian43 12y ago
  that's for olap, while I was talking for oltp
gliush 12y ago
As a short answer - not yet, but it looks like in 2-3 years there will be at least one.

Slide 27. VoltDB. Or use posgres-xc, or mariadb 10 with galera and maxscale. Postgres has JSON storage. MariaDBB has dynamic and virtual columns, and the CONNECT engine which can now directly create new or edit existing JSON files using the SQL interface, instead of dedicated functions for JSON manipulation. https://mariadb.com/kb/en/mariadb/connect-json-table-type/ https://mariadb.com/kb/en/mariadb/connect-json-table-type/

ddorian43 12y ago
voltdb free has no HA postgres-xc/xl has no HA Maxscale looks like it doesn't yet offer sharding

alexandre_m 12y ago

CockroachDB is promising. https://github.com/cockroachdb/cockroach https://github.com/cockroachdb/cockroach Inspired by Google Spanner.

jrullmann 12y ago

Take a look at the Overview slide of the presentation, where this information is listed for each database the author discussed: http://image.slidesharecdn.com/newsql-2015-150213024325-conversion-gate01/95/newsql-overview-feb-2015-48-638.jpg?cb=1423817736 http://image.slidesharecdn.com/newsql-2015-150213024325-conv...

anonetal 12y ago

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.

codeordie 12y ago
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.
- pkolaczk 12y ago
  This is because the top priority for Cassandra is being scalable and always-on in the first place. New features are added only if they meet these goals. Therefore you have guarantee it will always scale and it has no single point of failure, not even a temporary one, regardless of which feature you use. Some other new database engines do it in different order - first adding as many RDBMS features as possible and then making some of them kinda scalable (in some circumstances, if the phase of the moon is right, etc.). Sure, that might feel less cumbersome at the beginning on a single laptop (feels like good old RDBMS), but once you scale it out, it is far from being all roses. BTW, duplicating (denormalizing) data is the way to go if you really need scalability. In general case, joins or traditional indexes with references from the index leaves to the original data do not scale on distributed data sets.
  - ddorian43 12y ago
    You can do joins on the same partition-key + indexes(with references) only inside the partition-key.

jeremysmyth 12y ago

MySQL Cluster. http://www.mysql.com/products/cluster/features.html http://www.mysql.com/products/cluster/features.html

deleted 12y ago

[deleted]

ddorian43 12y ago
that's for olap, while I was talking for oltp

gliush 12y ago

As a short answer - not yet, but it looks like in 2-3 years there will be at least one.