Questions tagged [rethinkdb]

RethinkDB is a scalable, open-source, distributed database system built to store JSON documents. It features a query language that has useful queries like table joins and group by, a highly parallelized architecture, and web tools for managing clusters.

RethinkDB is a scalable, open-source, distributed database system built to store JSON documents. It features a query language that has useful queries like table joins and group by, a highly parallelized architecture, and web tools for managing clusters.

Programming model:

  • JSON data model and immediate consistency
  • Distributed joins, subqueries, aggregation, atomic updates
  • Hadoop-style map/reduce
  • Secondary, compound, and arbitrarily computed indexes.

Administration:

  • Web and command-line adminstration tools
  • Tools to handle machine failure and network interrupts
  • Multi-datacenter replication and failover

Scalability:

  • Sharding and replication to multiple nodes
  • Automatically parallelized and distributed queries
  • Lock-free operation via MVCC concurrency

Useful Links:

Books:

1436 questions
4
votes
1 answer

How to apply filter on array in ReQL in ReThinkDB using JavaScript

In the following JSON, I want to pick the records that have sales > 12500. How do I do that in ReThinkDB and ReQL? JSON is: { "address": { "address_line1": "Address Line 1" , "address_line2": "Address Line 2" , "city": "Kochin" , …
KAdditude
  • 83
  • 1
  • 3
4
votes
2 answers

How to rename a field in rethink while doing a join

I'm trying to do a join on 2 tables in rethinkdb with the following query: r.db('testdb') .table('eco') .eqJoin('project_id', r.db('testdb').table('projects')) .map( function(){ r.row.merge(function(){ r.expr({'right':…
Korbin
  • 1,788
  • 2
  • 18
  • 29
4
votes
3 answers

RethinkDB hierarchical data

I'm trying to see if there is a way to transform a flat list into a hierarchical tree in rethinkdb. Given this table: nodes ------ -id -name -parent I can query all with r.db('app').table('nodes') and get a flat list: [ {name: "one", id: "1"} …
geddski
  • 738
  • 7
  • 13
4
votes
1 answer

Haskell: GHC cannot deduce type. Rigid type variable bound by the type signature error

I'v seen a couple of posts with a similar subject but they don't really help me to solve my problem. So I dare to repeat. Now I have a functions with signature: run' :: Expr query => RethinkDBHandle -> query -> IO [JSON] this is a database query…
r.sendecky
  • 9,933
  • 9
  • 34
  • 62
4
votes
3 answers

rethinkdb: "RqlRuntimeError: Array over size limit" even when using limit()

I'm trying to access a constant number of the latest documents of a table ordered by a "date" key. Note that the date, unfortunately, was implemented (not by me...) such that the value is set as a string, e.g "2014-01-14", or sometimes "2014-01-14…
Kludge
  • 2,653
  • 4
  • 20
  • 42
4
votes
2 answers

How to atomically replace document when it doesn't exists in Rethinkdb >= 1.11

I've updated rethinkdb to 1.11.2 and found backward incompatibility in update/replace commands. In 1.10 both commands command returns proper response r.db('test').table('user').get("notFound").update({a: 1}) // {"skipped": 1…
Robert Zaremba
  • 8,081
  • 7
  • 47
  • 78
4
votes
1 answer

RethinkDB: conditional upsert (only if particular fields are matched)?

I know rethinkDB's insert() has an upsert option. Eg, from the docs: rethinkdb.table('marvel').insert( { superhero: 'Iron Man', superpower: 'Arc Reactor' }, {upsert: true, return_vals: true} ).run(conn, callback) But say there might be existing…
mikemaccana
  • 110,530
  • 99
  • 389
  • 494
4
votes
2 answers

Can RethinkDB hold more than a few hundred embedded arrays?

At http://www.rethinkdb.com/docs/data-modeling/, states: Because of the previous limitation, it's best to keep the size of the posts array to no more than a few hundred documents. If I intend on keeping 90 days (3 months) of statistics, and its…
Christian Fazzini
  • 19,613
  • 21
  • 110
  • 215
3
votes
1 answer

Retrieve list of table names

I want to get the list of tables in a database. The documentation of the tableList command says this method returns a list of strings, but that is not exactly the case. It actually returns a TableList object. And when I…
Johannes
  • 828
  • 12
  • 29
3
votes
2 answers

how can i solve npm ERR! error:0909006C:PEM in Node.js?

I'm new to Node.js. I tried to add RethinkDB module to my project, but I got: npm error:0909006C:PEM routines:get_name:no start line error. I don't use a proxy, tried uninstalling/reinstalling Node.js, and changing the registry from the solutions…
serdar
  • 41
  • 1
  • 1
  • 6
3
votes
1 answer

RethinkDB: Javascript - How to deleted nested objects

I'm having a rather large amount of difficulty with trying to remove nested objects from my table, without accidentally deleting all my data in the process (happened three times now, thank god I made copies). My Object: { "value1": thing, …
Laz
  • 63
  • 1
  • 5
3
votes
0 answers

RethinkDB startup error

After I fixed some weird HD problems at my server I noticed that all the rethinkdb data had been lost, that wasn't a problem because the data wasn't important, but now when I start the rethinkdb service using sudo /etc/init.d/rethinkdb restart it…
Checkium
  • 98
  • 1
  • 11
3
votes
1 answer

Rethinkdb on Heroku

I tried searching on the web for a tutorial to install rethinkdb on heroku but was not satisfied with the tutorial provided. Can anyone suggest a step by guide to install rethinkdb via compose or dockerhero as a database for heroku nodejs app? I…
Subrata Banerjee
  • 299
  • 1
  • 5
  • 21
3
votes
2 answers

Open port on Google Cloud Shell

Update: The problem described in this question is no longer relevant as the limitation that caused this problem has been lifted. Feel free to create a new question may you encounter similiar issues but as far as I know, the problem I faced was…
3
votes
1 answer

Angular2: removeAll() in RethinkDB with Horizon API

I'm pretty new with Angular2, RethinkDB and Horizon API and I'm building a small webapp. In this app I'm trying to delete all objects in a specific table, and therefore I use the fetch() and removeAll() functions from Horizon API. The problem is the…
Wouter Vanherck
  • 2,070
  • 3
  • 27
  • 41