I have a table Items with ~20k records. I need to be able to filter on multiple tags (or) and maintain order of the items, sorted by sticky then created-date.
For example I may fetch items tagged with tagA, tagB or tagC etc. If an item is sticky…
After looking at some SO questions and issues on RethinkDB github, I failed to come to a clear conclusion if atomic Upsert is possible?
Essentially I would like to perform the same operation as ZINCRBY using Redis.
If member does not exist in the…
I have lots of tables in database in rethinkDB. so I want document whole system with ER and UML diagram.
Is there any way to generate ER or UML diagram from existing database ?
Or any thing which helps me to create easily ?
I need to change the server_name of a running rethinkdb instance. I have stopped the server and update the /etc/rethinkdb/instances.d/default.conf file and then removed the metadata & rethinkdb_data from /var/lib/rethinkdb/default/data location. …
I found an answer for finding all documents in a table with missing fields in this SO thread RethinkDB - Find documents with missing field, however I want to filter according to a missing field AND a certain value in a different field.
I want to…
The solution to this RethinkDB query has eluded me for days now. Does not help that I'm a t-SQL developer...
Given a document structure like this:
var messages = {
"Category A" : {
catName: 'Category A',
…
Any idea how can I select the Agent IDs inside the clients filter?
This is what I have now and it works, but I do not like that first we are waiting for the Agents to be selected and then we do another trip to the database to select the clients.
Is…
rethinkdb and nodejs+express app fit well in container for cluster environment??
The situation is below in a docker container
1. Running rethinkdb and nodjs+express app in one container
2. During the boot up of nodejs app it checks if there is a…
Hello I'm new to RethinkDB and javascript in general. I was wondering what the best way is to perform a query with multiple filters including a regex match.
e.g. merge these two queries into one with the goal of finding all messages in a given…
Context: On the client, a field is modified and that change is propagated to the server as a keypath-value pair. I start out with a keypath, something like foo.bar.baz = cat, which I can convert to {foo: {bar: {baz: "cat"}}} and then merge into my…
Let's say this is the uuid of one of my documents in RethinkDB: 594a64ab-b78b-4838-a79f-318020a352a9
Normally, to retrieve the document, I do:
r.db("databasename").table("tablename").get('594a64ab-b78b-4838-a79f-318020a352a9')
Is there some way I…
I will be dynamically combining a range of tables with the exact same structure in RethinkDB.
I have my dynamically-generated list of tables in an array as follows:
tables = [r.table('table1'), r.table('table2'), ...]
And I am trying to do…