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

Can group have multiple aggregates?

I'd like to do something like this: r.db('research').table('books').group('year').sum('size_bytes').count().run() And get a result like this: { {"group": 1901, "reduction_size_bytes": 13929238, "reduction_count": 192}, {"group":…
Duane J
  • 1,615
  • 1
  • 15
  • 22
0
votes
1 answer

How to achieve many to many relationship among 2 tables in rethinkdb?

So this is quite basic in webapps but I am unable to figure out the solution in rethinkdb as its my first time working with DBs. One post has many tags and one tag has many posts under it. I want to be able to retrieve all the posts when I click on…
0
votes
1 answer

Filtering based on key/value in all objects in array in RethinkDB

I have a RethinkDB table with records structured like this: { one: [ { field: val, foo: bar }, { field: val2 } ] } Now, if I do something like reql = reql.filter(function(tb) { return…
haroba
  • 2,120
  • 4
  • 22
  • 37
0
votes
1 answer

How to use both: filter and group in rethinkdb

I want to group filtered result, not all, only filtered. Something like this: r.table(TABLE_NAME).filter(...).group("supplier").max("ts").run(...)
okuznetsov
  • 278
  • 1
  • 5
  • 12
0
votes
2 answers

RethinkDB: get a document by key-value pair?

I'm evaluating RethinkDB as a Mongo replacement due to lack of stable Mongo drivers on Node. I've read the docs at http://www.rethinkdb.com/api/javascript/get_all/ and have a very simple question: how do I get a document by key value pair? The…
mikemaccana
  • 110,530
  • 99
  • 389
  • 494
0
votes
1 answer

non writing replace/update in rethinkdb query

I'm new to rethinkdb and have simple trouble. Suppose I have following objects structure: Table A: [{ 'id': '1', 'b_list': ['11', '12'] }] Table B: [{ 'id': '11', 'value': 'somevalue1' },{ 'id': '12', 'value':…
Stqs
  • 355
  • 1
  • 4
  • 13
0
votes
1 answer

Using $this when not in object context RethinkDB time object

I'm trying to convert an object that holds a rethinkdb datetime object (provided by the PHP-RQL library) but i'm getting a fatal error saying: Using $this when not in object context This is an overview of the code: $day = new stdClass; $datetime =…
fenfe1
  • 71
  • 1
  • 6
0
votes
2 answers

How would you use map reduce on this document structure?

If I wanted to count foobar.relationships.friend.count, how would I use map/reduce against this document structure so the count will equal 22. [ [0] { "rank" => nil, "profile_id" => 3, "20130913" => { …
Christian Fazzini
  • 19,613
  • 21
  • 110
  • 215
0
votes
1 answer

making joins in rethinkdb

I am trying to make a join between two tables. The command I'm running is: r.table("userclientmap").eq_join("user_id", r.table("users")) My 'user' table looks like this: [ { "email": "nielsen.ruben@gmail.com" "password": …
Eldamir
  • 9,888
  • 6
  • 52
  • 73
0
votes
1 answer

How to insert ahead an element to an embedded array?

How to insert blow document { "author": "Vic Zhao", "text": "hell..............." } into blow document as first element of embedded array comments { name: 'Me', comments: [{ "author": "Joe S.", "text": "I'm…
Alex Luya
  • 9,412
  • 15
  • 59
  • 91
0
votes
1 answer

Is this possible to do in RethinkDB

I've used mongodb in the past and I want to use similar schema. I've tried to create it using PHP driver but it doesn't work as I expected. So my guesses were either rethinkdb does not support it or php driver is not capable to do…
ewooycom
  • 2,651
  • 5
  • 30
  • 52
0
votes
1 answer

Filtering out results using sub-queries in ReQL/Rethink?

I'm am trying to learn more about RethinkDB and its sub-query abilities. I was wondering if the following would be possible in ReThinkDB: // example of "post" document: { id: .., allow: [], disallow: [some_label_id, other_label_id], ... } //…
dgo.a
  • 2,634
  • 23
  • 35
-1
votes
1 answer

run multiple instances of Rethinkdb on the same machine

I would like to run multiple instances of Rethinkdb on the same machine. Is that possible? if so, what is the set up?
Marek
  • 11
  • 1
-1
votes
1 answer

how to publish ASP.NET web api from internet modem's port

I want to publish my web api from my internet modem. With this, my android app(rest client) can send HTTP requests. This is for an android app-realtime DB connection, i use RethinkDB. I tried ngrok to publish but my realtime DB is running on local.…
Ege
  • 138
  • 1
  • 14
-1
votes
1 answer

How to get most recent message in a messaging DB? (RethinkDB)

Hi I'm building a chat messaging system and am reading/writing to the DB for my first time. I'm creating the method calls to retrieve relevant data I need for this chat. Like with most chat systems, I want to have a general list of message with the…
Sam
  • 495
  • 3
  • 11
  • 19