Imaging a query that delivers "posts" in a specific time period between "from" and "to". A simple query. Additionally, I need to get ONE record BEFORE and ONE record AFTER what the original query specified. For example, a table holds…
I have a table with two columns. One is Name, other is Mark. Mark can be low, mid or high. Under every name, i want count of high low and mid. enter image description here
db.inventory.aggregate( [ { $lookup: { from: "order", localField: "_id", foreignField: "item_id", as: "inventory_docs" } } ] ) The $lookup is joining based on the item_id field, which is indexed. If 100,000 documents pass through this $lookup, it increased the query…
When creating a new user in Postgres, I have a trigger that automatically creates a chat for him (like saved messages in telegram). I also have a chat_members table in the database that stores chat members in a many-to-many relationship…
ыI have a table with a json as a field. The structure of a json is completly random but it never has inner objects inside. data {"test": "baa-1496", "test2": "baa-1431", "test3": "baa-1497"} {"test": "baa-1452", "test4": "baa-1597"} i want to turn…
I want to perform insert operations into the database on each pagination page, starting from the first page to the last page, and finish when the last page is done. but the problem is, I tried this code, but it…
I am trying to search my MongoDB of products. The dataset has multiple of each product to record price over time. I would like to search for a phrase then limit the results to 1 of each UPC. My current…
This is a senario: I have got a object let's say a cat. For example when I insert the cat 4 details to database, I can add children to cat 4, lets say cat 1, 2 and 3. In web…
could not connect to server: unable to connect to postgresql server. connection refused (0x0000274D/10061) is the server running on host and accepting TCP/IP connections on port 5432? i tried to login into the xampp application to fetch the report and…
I want to store such fields in the table as: the ID of the employee, his last name and first name, and how many hours he worked on each day of the month. For example, March 1 - 6 hours,…