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
11
votes
2 answers

Testing Promises with multiple thens using testdoublejs

I am using testdouble for stubbing calls within my node.js project. This particular function is wrapping a promise and has multiple then calls within the function itself. function getUser (rethink, username) { return new Promise((resolve, reject)…
ckross01
  • 1,681
  • 2
  • 17
  • 26
11
votes
1 answer

How suitable is opting for RethinkDB instead of traditional SQL for a JSON API?

I am building the back-end for my web app; it would act as an API for the front-end and it will be written in Python (Flask, to be precise). After taking some decisions regarding design and implementation, I got to the database part. And I started…
linkyndy
  • 17,038
  • 20
  • 114
  • 194
10
votes
1 answer

How do I use a Ratchet\Server\IoServer object after run executed?

I want to run a function that iterates through a generator class. The generator functions would run as long as the Ratchet connection is alive. All I need to do is to make this happen after the run method is executed: use…
112233
  • 2,406
  • 3
  • 38
  • 88
10
votes
1 answer

RethinkDB - Find documents with missing field

I'm trying to write the most optimal query to find all of the documents that do not have a specific field. Is there any better way to do this than the examples I have listed below? // Get the ids of all documents missing…
vimfluencer
  • 3,106
  • 3
  • 17
  • 25
10
votes
1 answer

How to join tables with a array of IDs

Attempting to use this example to join on an array of IDs: https://github.com/rethinkdb/rethinkdb/issues/1533#issuecomment-26112118 Stores table snippet { "storeID": "80362c86-94cc-4be3-b2b0-2607901804dd", "locations": [ …
Dustin Brownell
  • 817
  • 7
  • 10
9
votes
1 answer

Easiest way to copy/duplicate a RethinkDB database?

How can I easily duplicate my production database (mydb) to create a dev database (mydb-dev)? The rethinkdb restore command seems to have no option to specify the name of the output database. It only has the option to select which database I'd like…
3k-
  • 2,467
  • 2
  • 23
  • 24
9
votes
1 answer

How to use getall with orderby in RethinkDB

i want to list records where id=1 between two timestamps and finally order them according to timestamp. Mysql query something: Select * from test where (timestamp between 100099323 AND 1423699323) AND id=1 order by timestamp there are more than 5…
amit
  • 874
  • 7
  • 16
9
votes
4 answers

rql get multiple documents from list of keys rethinkdb in javascript

I have a table of "person" data, which has a unique key "id". I have a list of id's that I want to get the data for which I'll be sending as a JSON array from the client to the server. The serve recieves that data as a JSON array. Now is there a…
CamHart
  • 3,825
  • 7
  • 33
  • 69
8
votes
1 answer

Extract Only Date from DateTime Object in Javascript?

i have Json Array which look like this and its working fine but i need to arrange them gruopwise like DateWise [ name: 'Ali', startedAt: Wed Dec 28 2016 15:32:07 GMT+0500 (Pakistan Standard Time), userId: '0002' }, { completedAt: Wed Dec…
DEO
  • 316
  • 2
  • 4
  • 18
8
votes
1 answer

Time pseudotype instead of ISO8601 when using group operator

I'm getting started with RethinkDB and I'm having some trouble understanding what's going on with some queries I'm running. The problem is querying objects with date time types from a NodeJS app (using the rethinkdbdash driver) which exposes a JSON…
Marc
  • 213
  • 2
  • 12
8
votes
1 answer

Querying array of nested objects

Say I have this JSON (sample - a real-life example can be found at apple itunes rss feed) stored in a RethinkDB table called 'test': { "feed": { "entry": [ { "title": { "label": "Some super…
codeclash
  • 2,053
  • 19
  • 17
8
votes
1 answer

RethinkDB: iterating over object properties

I have the following data structure: wall { slug: "wall-slug", nodes: { "node1": "id-from-nodes-table-1", "node2": "id-from-nodes-table-2" } } nodes { id: "id-from-nodes-table-1", something: "something" } Trying…
La Faulx
  • 472
  • 3
  • 10
8
votes
2 answers

RethinkDB multiple queries in a single request

I'm trying to execute several RQL commands in a single request to server, without much success I may add. I have tried r.union, but it only works with sequences. What I really want: [r.db(..).table(..).get(id1).delete(), …
PJK
  • 2,082
  • 3
  • 17
  • 28
8
votes
1 answer

Can RethinkDB handle large data sets (TB+) and serve as DB for an OLAP app?

Can RethinkDB handle large data sets (i.e. multiple tera bytes ) effectively to serve as DB for an analytics application ?
JE42
  • 4,881
  • 6
  • 41
  • 51
8
votes
4 answers

RethinkDB index for filter + orderby

Lets say a comments table has the following structure: id | author | timestamp | body I want to use index for efficiently execute the following query: r.table('comments').getAll("me", {index: "author"}).orderBy('timestamp').run(conn, callback) Is…
Robert Zaremba
  • 8,081
  • 7
  • 47
  • 78
1
2
3
95 96