in the following example I have a company named Colors Company that owns many shops { _id: ObjectId("78391283"), name: "Colors company", shops: [ {shopID: ObjectId("123456a1cb"), income: 0}, {shopID: ObjectId("2a1cb67890"), income: 0}, {shopID: ObjectId("2a1cb010111"), income: 0}, ... ], } I need…
My question is relevant to the concept of searching data. I am developing a project with Laravel. The question is, which is efficient? Get data from the database and search through PHP, Or prepare the SQL command and search inside…
Here is the code example: app.js const express = require("express"); const app = express(); const cors = require("cors"); require("dotenv").config({ path: "./config.env" }); const port = process.env.PORT || 5000; app.use(cors()); app.use(express.json()); app.use(require("./routes/record")); // get driver connection const dbo = require("./db/conn"); app.listen(port,…
I'm looking to improve the query performance of the following mysql query: SELECT * FROM items WHERE items.createdAt > ? AND items.createdAt + items.duration < ? What are the best indexes to use here? Should I have one for both…
i have json server fake data in my react app and here is my data: {"quotes": [ { "id": 1, "quote": "Javascript is my life", "author": "ali pasha", "comments": [], }, { "id": 2, "quote": "Learning react is very fun",…
the screenshot of MySQL exportMySQL tables do not show when trying to export my schema... I can see those tables in my schema, etc but not when trying to export. What could be wrong? I am using MySQL Workbench on…
I'm trying to retrieve data from database and display all the data using foreachloop. Im getting first row data easily without foreach loop but whenever I try using loop the error displays "foreach() argument must be of type array|object, string…
I have a users table and a column supervised_by where I want the id of the user who created the new user. For example: get the id of the admin in supervised_by column of the user the admin creates. users…
I have two tables I need to join these table and there is a possibility that joined table might return duplicate rows but there is column updated date which will be unique so I need to fetch record from these…
I have a question: we have a table that has (among other stuff) a couple of IP/port pairs that I would like to be globally unique to avoid crosstalk in streaming binaries that use this configuration. Assume a table as…