I have a MongoDB collection that stores some test submissions. The highlevel schema looks as follows. { "lessonType": "quiz", "userId": "639cb6d9513a420026eddca1" "courseId": "639cb6d9513a420026eddca2", "lessonId": "639cb6d9513a420026eddca3", ...some_more_fields } Now there are two indexes on this collection. first one: { courseId: 1,…
How do I tell PostgreSQL this? :: Get me the highest-ranked result for every element in a group, ranked by these attributes that you can already find in an index, so you don't have to rank the entire table. See…
I want to give a group of users selective access only to particular columns of an Application due a privacy concern. So, when user types '''SELECT *''' on restricted table, he could only see allowed columns. What I want to…
I have data on a MongoDB collection stored in documents like these: { "_id": "657c54befca2b6a2cdd935ba", "data": { "name": "Bob", "surname": "xxx", "age": "20", }, "header": { "data": "1702646974156", } "_class": "Prova" } { "_id": "657c54befca2b6a2cdd935bb", "data": { "name": "Tom", "surname":…
I've been stumped trying to optimize this query and was hoping some of you database wizards might have some insight. Here is the setup. Using TimescaleDB as my database, I have a wide table containing sensor data, it looks like…
i have table in database called land with a field landType , landType is an array of strings (string[]) i need to write a query that by taking an input for example "N" it returns the row if any of…
To keep it simple, I'm creating a list of of items in React that are pulled from the DB. Part of this is that we can delete/add items to the list, which i also want to reflect in the DB.…
I have a PostgreSQL trigger that fires after an INSERT on the auth.users table, calling a function handle_new_user() which, in turn, calls insert_into_profiles() to add user data to another table. The insert_into_profiles function is defined as follows: CREATE OR REPLACE…
I want to identify who is on my app so I can place green badges as indicators. I logged into my app (which I have not deployed) through Google OAuth, so the session is stored. However, I left days ago…
Cant connect to MongoDB database and store data in localhost:27017 using MongoClient. Cant display connection result in the console (both failure and success connections). var express = require('express'); var router = express.Router(); var mongoClient = require('mongodb').MongoClient /* GET home page.…