I need to join all the three tables as mentioned below datatype id code 1 Q_1 2 Q_2 3 Q_3 4 Q_4 5 Q_5 6 Q_6 7 Q_7 8 Q_8 9 Q_9 10 Q_10 model id datatype_id values model_ex_id 1…
We created several views postgresql 12 (not materialized views) which include nested queries and multiple joins. we are facing a strange behavior, are noticing that some views are disappearing from the view list and others are remaining. is this related…
Having a table such as follows: CREATE TABLE Associations ( obj_id int unsigned NOT NULL, attr_id int unsigned NOT NULL, assignment Double NOT NULL PRIMARY KEY (`obj_id`, `attr_id`), ); this should occupy 16 bytes per row. So the overhead per…
I have a database in which records look like this: { id: someId initialValue: 100 currentValue: 150 creationDate: someDate } And I have to get values that are the biggest in terms of difference between currentValue and initialValue. Is it…
Hello fellow StackOverflow community, I've encountred an error when trying to .map() a getDoc() constant in my Next.js app, saying the following: "TypeError: Cannot read properties of undefined (reading 'map')". I'm new to Next.js and I would appreciate a lot…
So basically I'm trying to get all the documents (as it's called in Mongodb) in a collection. I've watched some Youtube videos and they use the db.collection.find() method to do this. In my case however this doesn't work for some…
I have mysql DB with important financial data, currently the data is stored as float type and I get incorrect data due to float rounding, I want to store it as DECIMAL. What is the safe way to convert the…
I have 2 tables in a database, users and users_removed with columns "id(primary key), email(unique), password" and "id, user_id(foreign key (user_id) references users(id)" respectively. When a user registers the users table gets the data accordingly. And when the user wants…
Via SQL, I'm trying to get from this: id group_id session_id field_label field_value sent_at 1 frosted flakes blue bowl first_name Bob 2022-11-05 18:18:19.093 2 frosted flakes blue bowl first_name Bobby 2022-11-05 18:17:31.274 3 frosted flakes blue bowl last_name Brown 2022-11-05…
I have two collections Categories and Subcategories inside a Categories collection. I have an array that is storing the ids of subcategories that are stored in Subcategories collection. Below is my document structure: Categories collection { id:65, title:"Automotive", active:true, subcategories:[35,28,30]…