In this exercise that my professor refuses to correct in class, I have to do this query: Return the names of heroes that begin with I or J, and all their mentors. Here is the structure of the objects I’m playing with ...
databaseanswers.net Latest Questions
This is not full text search! I have approximately 1 billion of rows, the core column is a string with medium length of 13 chars and I want to search with a substring as filter in any positions (left, right, middle) ...
I have been trying for several days to write a script to update the children of a collection based on a value of that array items element. Here is the data structure: { "_id" : BinData(3, "nmtYgz4fOkSqXEBp56fPWA=="), ...
I just started to learn NoSQL. I have a table Orders, which contains a field with the type array – books inside which a field with the type string – name. I want to get the book which is the ...
Quick preamble before the real question: I’m PM’ing a chrome plugin that will allow users to write emails more quickly…implementation similar to Grammerly. The plugin will remember things that the user does and offer them as suggestions going forward. An easy example: ...
Example: I created two models, a "post" model and a "category" model. I would like to create a category and when I create the post, I reference the id of the category and automatically register this post within "PostsId" in the ...
I am confused the way i need to structure my documents to effectively search/fetch items by tag when needed. Meaning,structure of each document goes like: { name: "Delicious blackforest cake", tags: ["blackforest","birthday","designer"] ... } { name: "Red velvet cake", tags: ["party","anniversary","designer"] ... } ... There’s total of ...
{ $lookup: { from: "follows", let: { id: "$_id", ...
I have data in XML format (may be JSON also) in a very heavy files: 10M records per file on a monthly basis with tens of files by reception. I need to store the records and retrieve info them based ...
For my graduation project, I need to draw a ERD to combine 2 databases, SQL for authentication and NoSQL for other data like articles and posts and tasks. How can I specifically display relationships between user (SQL) and their posts (NoSQL) ...