See the query below where I get the reputation value from direct addition without a function. SELECT "User"."id", "User"."name", "User"."title", "User"."about", "User"."location", "User"."isModerator", "User"."createdAt", ( -- question vote COALESCE(SUM("PostVote"."value" * 10) FILTER (WHERE "value" = 1 AND "Post"."questionId" IS NULL),…
I made a small shopping application with flutter using Android studio, it retrieves the items from a database on 000webhost,it works perfectly fine on pc and even on a phone emulator on pc,but if I turn it into an apk…
I have a laravel application A with a mysql database db1 and a table p1 and a diffrent php application B with an equivalent table p2 in its mysql database db2. I want to find best, secure and complete way…
I have a deeply nested json array. The array contains a list of json objects, I want to remove any of the objects that are matched based on a field within the object. { "name": "John smith", "items": { "unknown-key-1":…
I am using mongoose to connect the MongoDB with my backend. const connectDB = async () => { try { const conn = await mongoose.connect(process.env.MONGO_URI, { useNewUrlParser: true, useUnifiedTopology: true, }); This is the piece of code I wrote and…
I want to save in Postgres TIMESTAMP WITH TIME ZONE column 2012-08-24 14:00:00+03:00 After a SELECT I am getting: 2012-08-24 11:00:00+00:00 I know that my DB is on UTC zone, but is there a way to save it and not…
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":…