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

rethinkdb PHP-RQL changes

I'm using PHP-RQL library to work with RethinkDB, i need to get changes when new data inserted. but i'm getting PHP Fatal error: Uncaught RqlDriverError: Options must be an array. in api documentation its says: table->changes(array('squash' =>…
0
votes
2 answers

Subqueries to filter out in rethinkdb

How do write an equivalent statement in RethinkDB using Python client driver? SELECT id fields FROM tasks WHERE id NOT IN (SELECT id FROM finished_tasks) This is what I tried: r.table('tasks').filter(lambda row: r.not(row['id'] in…
user462455
  • 12,838
  • 18
  • 65
  • 96
0
votes
1 answer

Is there a way to query the closest locations on a filter in RethinkDB?

Currently, the Rethink API documentation says that the get_nearest command only works on a table. Ofcourse I can filter the results afterwards, but that seems inefficient, plus that requires to have all the items sorted by distance when I want to…
Fritzz
  • 656
  • 6
  • 27
0
votes
1 answer

Node.js database initalization from multiple modules

I have 3 modules in a project: A,B,C; all of them are using Rethinkdb, which requires an async r.connect call upon initialization. I'm trying to make a call from module A to B from command line; however, despite starting r.connect on require(), B…
Silver Dragon
  • 5,480
  • 6
  • 41
  • 73
0
votes
1 answer

append to nested array in rethinkdb

I have a data structure as follows: { id: blah-blah-blah, settings: { stuff: {}, other_stuff: {}, provided: [] }, .... } I need to update various items with dynamically generated…
BarthesSimpson
  • 926
  • 8
  • 21
0
votes
1 answer

RethinkDB: trouble with basic JavaScript example

I have the server running on port 8080, I can see the web interface... When I try to run this example from command line, like this: node test.js (node version: 4.1.0), I…
davidhq
  • 4,660
  • 6
  • 30
  • 40
0
votes
1 answer

How's the best way to perform a nested concatMap to achieve joining multiple tables?

on the concatMap api page in RethinkDB website, it's saying eqJoin is implemented with concatMap + getAll, which should provide better performance than other joins. in my case, I'd like to join multiple tables, here's an example, let's assume I have…
oldlam
  • 13
  • 5
0
votes
2 answers

Rethinkdb insert query results into a table

I'm trying to insert the results of a query from one table into another table. However, when I attempt to run the query I am receiving an error. { "deleted": 0 , "errors": 1 , "first_error": "Expected type OBJECT but found ARRAY." , …
scull7
  • 105
  • 1
  • 5
0
votes
2 answers

How can I force close open connections in RethinkDB?

I have problems with my open connections with RethinkDB. If errors occur in my Sinatra back-end app methods, the connection with Rethink is not closed. Therefore the number of open connections slowly increases. This results in too many open…
Fritzz
  • 656
  • 6
  • 27
0
votes
2 answers

How do is a particular id in a RethinkDB table?

With a Python list I can do: if 'myfakeuser' in list_of_usernames: print "This user exists" How can I do this with Rethinkdb? r.db('mydb').table('users').get('myfakeuser').run() doesn't return anything or raise an error when there's no id set…
Tim Clemans
  • 875
  • 1
  • 10
  • 18
0
votes
1 answer

Efficient way to get difference of two streams in RethinkDB

I am running some performance benchmarks on RethinkDB (related to a specific use-case). In my simulation, there are 2 tables: contact and event. A contact has many events. The event table has 2 indices: contact_id and compound index on [campaign_id,…
shardnit
  • 127
  • 1
  • 9
0
votes
1 answer

Create an SSH tunnel on the server that needs to access the remote application port

I am developing Node.js application. And also new Linux systems. I installed RethinkDB to Google Compute Engine instance. I can access to 28015 driver port locally. But I cannot access to the driver port (28015) so that it cannot be accessed from…
hiwordls
  • 781
  • 7
  • 17
  • 35
0
votes
1 answer

Rethinkdb Client in Python Not Showing Field Values

For some reason Rethinkdb is not showing field values for valid objects when using the get() method: >>> import rethinkdb as r >>> conn = r.connect( "localhost", 28015) >>> conn.repl() >>>…
wspeirs
  • 1,321
  • 2
  • 11
  • 22
0
votes
2 answers

Rethinkdb chef solo cookbook

Is there any RethinkDB chef solo cookbook that allows one to install latest rethinkdb on ubuntu 14.04 / AWS. I tried couple options, however it didn't help. https://github.com/vFense/rethinkdb-chef - how to install latest…
tennis
  • 91
  • 1
  • 8
0
votes
1 answer

Isolate customers in RethinkDB database

I am looking for a strategy to implement a shared RethinkDB cluster between customers with data isolation. I would like to have multiple customers that would use a shared RethinkDB cluster, but I'm not sure about how to enforce the separation of the…
nha
  • 17,623
  • 13
  • 87
  • 133