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
3
votes
1 answer

Rethinkdb Performance with multi-value eqJoin on compound index

UPDATE: Looking at this more, I'm thinking that I just need to denormalize the data more, and simply add the relevant location information (city/state/etc.) to each row of the referrals table, rather than doing a join on a large set of ZIP codes. Am…
3
votes
1 answer

How to find value of nested Value only field data in rethinkDB?

My first concatMap return something like following. I would like to get the value of "d" so the value will be "Rethinkdb" [ { "a":{ "b":{ "c":"NoSQL", "d":"Rethinkdb" …
Prakash Thapa
  • 1,285
  • 14
  • 27
3
votes
1 answer

RethinkDB: how many connections?

I'm starting out with rethinkdb in python, and taking a look at the different approaches: Blocking approach with threads Non-blocking, callback-based approach with Tornado Greenlet-based approach with gevent In the first case, the natural thing to…
salezica
  • 74,081
  • 25
  • 105
  • 166
3
votes
4 answers

Order by random in RethinkDB

I want to order documents randomly in RethinkDB. The reason for this is that I return n groups of documents and each group must appear in order in the results (so all documents belonging to a group should be placed together); and I need to randomly…
linkyndy
  • 17,038
  • 20
  • 114
  • 194
3
votes
2 answers

RethinkDB: Determine if there is a next document in result set

With the RethinkDB JavaScript driver, is there a way to determine if there is another document available while within a "cursor.each" or a "cursor.on('data')" event? Via each cursor.each(function(err, doc) { if (err) throw err; //…
Dustin Brownell
  • 817
  • 7
  • 10
3
votes
2 answers

Does Rethinkdb support thousands of tables?

Does RethinkDb support creating/managing thousands of tables? Usecase: Tenant managed tables, without preknown schema. EDIT For future ref: https://github.com/rethinkdb/rethinkdb/issues/1861
Geert-Jan
  • 18,623
  • 16
  • 75
  • 137
3
votes
1 answer

How to replace multiple documents in one DB call

I have an array of existing documents in Rethink. They all have an ID field. What I want to do is basically this (in javascript): r.table('my_table').replace(myArrayOfDocuments); When I try that I get an error saying: Inserted value must be an…
haggy
  • 733
  • 6
  • 11
3
votes
1 answer

RethinkDB - Convert Imported MySQL Timestamp String to Time Object

I have imported a table from MySQL into RethinkDB, and it worked well. Now I am trying to figure out how to update my previous MySQL timestamp fields into Time objects in RethinkDB, with no success. Using the query…
Dustin Brownell
  • 817
  • 7
  • 10
3
votes
1 answer

RethinkDB: RqlRuntimeError: Cannot perform bracket on a sequence of sequences

Given the following documents in a table: [ { "id": "d30aa369-99d6-4a40-9547-2cbdf0bb069a", "locations": [ { "alerts": [ {"person": 200}, {"person": 300} ], "name": "home" }, { …
Samuel Goldenbaum
  • 18,391
  • 17
  • 66
  • 104
3
votes
1 answer

In RethinkDB using multi indexes for tags, how to get items that match more than one tag?

Suppose I have a story table (with example data): story {id: 1, name: 'First Story', tags: ['plants', 'flowers', 'dog']} {id: 2, name: 'Second Story', tags: ['flowers', 'wedding']} {id: 3, name: 'Third Story', tags: ['plants', 'wedding']} The…
Chanon
  • 383
  • 3
  • 8
3
votes
1 answer

Storing images with RethinkDB

I'm designing an application based on RethinkDB, which involves storing images. Each entity that I wish to store involves a number of fields of text, numeric data and an image of several hundred kilobytes. Would it be best to store the images in…
Lloyd R. Prentice
  • 4,329
  • 3
  • 21
  • 31
3
votes
1 answer

Is RethinkDB useful on partial updating json documents according rfc6902?

Please share your experience with partial updating of JSON document.At now I'm storing my JSON documents in MongoDB which looks like the following: { id: ObjectId(507f191e810c19729de860ea), title: 'Sterling Archer', comments: [ {text:…
Erik
  • 14,060
  • 49
  • 132
  • 218
3
votes
1 answer

Testing an ORM for RethinkDB

I am close to finishing an ORM for RethinkDB in Python and I got stuck at writing tests. Particularly at those involving save(), get() and delete() operations. What's the recommended way to test whether my ORM does what it is supposed to do when…
linkyndy
  • 17,038
  • 20
  • 114
  • 194
3
votes
2 answers

Rethinkdb - filtering by value in another table

In our RethinkDB database, we have a table for orders, and a separate table that stores all the order items. Each entry in the OrderItems table has the orderId of the corresponding order. I want to write a query that gets all SHIPPED order items…
isaachess
  • 739
  • 1
  • 7
  • 15
3
votes
1 answer

RethinkDB: Equivalent for "select where field not in (items)"

I have a table that looks like this: [ …
spiffytech
  • 6,161
  • 7
  • 41
  • 57