Stack Overflow
Stack Overflow

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

how to filter out non-numeric values

I have a table (in a RethinkDB database) that has a bunch of documents with the field VIN0. This field almost always stores numbers, as intended. I had some data corruption recently where there are some strings in place of numbers for the field…
Heath Westbrook
  • 23
  • 2
0
votes
1 answer

RethinkDB query OrderBy distances between central point and subtable of locations

I'm fairly new to RethinkDB and am trying to solve a thorny problem. I have a database that currently consists of two kinds of account, customers and technicians. I want to write a query that will produce a table of technicians, ordered by their…
oleson
  • 581
  • 4
  • 3
0
votes
1 answer

Checking to see if a RethinkDB shard is in use?

I am wondering if there is a way to check to see if a RethinkDB shard is in use before performing so ReQL query on it. I am currently calling two functions back to back, the first creating a RethinkDB table and inserting data, the second will read…
Garrett
  • 699
  • 5
  • 19
0
votes
1 answer

performance issues while processing 2 tables in lockstep based on orderedBy from-to

Title is probably not very clear so let me explain. I want to process a in-process join (nodeJs) on 2 tables*, Session and SessionAction. (1-N) Since these tables are rather big (millions of records both) my idea was to get slices based on an…
Geert-Jan
  • 18,623
  • 16
  • 75
  • 137
0
votes
1 answer

Get an array of from a squashed changefeed event with RethinkDB

I have a simple database in which I insert messages. I use the the change() method with the squash option to get the new messages every 10 seconds: r.table('wall_posts').orderBy({ index: r.asc('date') }).limit(100).changes({ squash: 10 …
Matthias
  • 1
0
votes
1 answer

Rethinkdb mapreduce not has_fields not working properly

I'm trying to find the percent of records (grouped by company) that do not have phone numbers. I can do this with the following two queries: r.table('users') \ .merge(lambda u: {'groups':…
wspeirs
  • 1,321
  • 2
  • 11
  • 22
0
votes
1 answer

how to setup realtime geolocation tracking in nodejs and android

Hi I want to setup realtime geolocation tracking for Android devices. This will peak to around 500 devices running app in foreground at a given time sending data to the server (average around 5-10 devices at any given time). This will be similar to…
Ankit
  • 3,878
  • 5
  • 35
  • 51
0
votes
1 answer

Error on insert data on rethinkdb via python

with following python script: #!/usr/bin/python3 import rethinkdb as r import os import configparser as c from xml.dom import minidom import urllib3 config = c.ConfigParser() config config.read("etc/db.py") conn = r.connect(config.get("DB",…
Aldo Pellini
  • 3
  • 1
0
votes
1 answer

Rethinkdb group sequence by N elements

I have a sequence inside a document { errorTicker: [1,2,3,4,5,6,7,8,9] } I would like to do a group by N elements and get for N = 3 { errorTicker: [[1,2,3],[4,5,6],[7,8,9]] } What would have been ideal…
let4be
  • 1,048
  • 11
  • 30
0
votes
1 answer

How to inner join two tables by one table's pid with other table's embeded array field value?

(sorry,the question title is quite awkward) Hello,I have two table with data like this: //friend_group table { ..... { "id":"user-me"//owner id "FriendGroups":[ …
Alex Luya
  • 9,412
  • 15
  • 59
  • 91
0
votes
2 answers

How to check whether a sequence contains any element of another sequence in rethinkdb?

I knew that "contains" will check whether a sequence contains ALL elements of another sequence.I want to know: Is there any simple way to check whether a sequence contains any element of another sequence? Update: I don't want to check whether A…
Alex Luya
  • 9,412
  • 15
  • 59
  • 91
0
votes
1 answer

rethinkdb - create new field containing array based on field in parent

Using a public data set I ran this query on a table: r.table("contacts") .filter({"Type": "Agent","ContactDescription" : "CONDO"}) .hasFields("CorporationName") .group("CorporationName") .ungroup() .merge(function(row){ return {count:…
Barry G
  • 221
  • 4
  • 14
0
votes
1 answer

how to only retrieve a specific field based on a filter in rethinkdb

I'm building a database with rethinkdb and koajs. Is there anyway in Reql to only deliver a specific field within a filter function? here is my code: function bySwimmer() { return function *(next) { var qs = this.request.querystring; …
Joseph Palomino
  • 101
  • 2
0
votes
1 answer

Building rethinkdb from source on Ubuntu

I am trying to build rethinkdb from source and hitting on this error: npm WARN engine amdefine@0.1.1: wanted: {"node":">=0.4.2"} (current: {"node":"0.13.0-pre","npm":"2.11.3"}) npm WARN engine mime-db@1.13.0: wanted: {"node":">= 0.6"} (current:…
Nitish Upreti
  • 6,312
  • 9
  • 50
  • 92
0
votes
2 answers

Update array of objects in RethinkDB

I have the following document representing a chat room, where the timestamp in the member objects represents that particular user's last activity in the room. { "id": "4ff130cc-3201-4a30-8a4c-5ce4303d28d0", "name": "General chat", "members":…
Tholle
  • 108,070
  • 19
  • 198
  • 189
1 2 3
…
95 96