I am having huge problems with my cluster. Servers keeps disconnecting for unknown reason (there is nothing in logs) and crashing for unknown reason.
I think I might have cluster setup wrong.
First this is first, I understand sharding and that is…
In RethinkDB I am trying to chain multiple queries to multiple database tables. The idea is the same as stored procs for traditional dB's. Basically I query all the users connected to a device and then for each users try to get the rules attached…
When i have a query like this:
r.db('universe')
.table('Star')
.getAll(
r.db('universe').table('Ship').get(idShip)('idCurrentGalaxy'),
{index: 'idGalaxy'}
)
.changes({includeInitial: true})
I expect it to update the changefeed…
I have a document that looks similar to the following
{
...
reactions: [
{
user: 'user_id',
reaction: 'reaction_name'
}, {
user: 'user_id',
reaction: 'reaction_name'
}
]
...
}
I'm trying to remove an…
I tried to put together a Horizon app with an externally hosted RethinkDB and I couldn't seem to get it to work with existing tools. I understand Horizon includes a server-side API component, which may be why.
I want to be able to directly insert…
As rethinkdb suggest to keep the document size 16MB max for the performance reason. In my nodejs rest api app user can insert data using api. I cannot control how much data would be for an user. each user has individual document in a users table.…
i have this query:
r.db('test').table('users').getAll("amazon_11",{index:"parent"})
.innerJoin(r.table("posts"),function (posts, user) {return posts("employeeId").eq(user("employeeId"));}).zip()
…
For a given sequence, how can I fetch rows of certain row numbers(indices).
I know that nth() can select the nth index. But what if I want to select multiple rows by index ?
r.expr([0, 10, 20, 30, 40, 50]).nth(3) // gives 30
The above works.…
I have two "tables" such as:
PEOPLE (ID / NAME)
1 | JOHN
2 | MARY
3 | PETER
MESSAGES (ID / PERSON_ID / TEXT)
1 | 1 | 'Text'
1 | 1 | 'Text 2'
1 | 2 | 'Text 3'
1 | 3 | 'Text 4'
How can I get the number of messages of each person? Just…
I need to iterate through a primary table and add new documents to a different table each with id: and name: entries that match documents in the primary table.
I have read the relevant documentation, which is shamefully sparse, and I found this SO…
i am using rethinkdb with nodejs. i have a funds table and i am trying to calculate balance of any user by adding all the credit entries minus total debit entries. So far i was able to run following…
I have setup Rethinkdb to use and I am trying to connect to DB via Java program using Java Driver.
I downloaded RethinkDB java driver 2.3.1 from http://mvnrepository.com/artifact/com.rethinkdb/rethinkdb-driver/2.3.1.
But I am getting the…