We store volunteer hours in a database for every user, i'm trying to figure out how to structure a Postgres SQL query to find the percentage of total hours a specific user has spent at a location vs the total…
I need to uploading some PDF file into database and display it. I have found a way that posibly displaying the PDF file, but I had no idea how to save it into the database itself. I tried some tutorials…
I am unable to delete PostgreSQL database in azure using the below command: az PostgreSQL db delete Is there any other script such as bash to clean up azure postgreSQL database?
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…