I have a Postgres DB, In which I am storing some analytical data in a table like a user id, city, country, source(referer), device_type(web, ios, android), etc. I wanted to show insights based on the data in the above table…
I have a table called addresses, it has a column name user_ids which is an array of the users who have that same address. When I request to /api/addresses what it returns is {id:1,name:"lorem", user_ids:[1,2]}. I want it to return…
Run into sql code with a lot of when: case when callDuration > 0 and callDuration < 30 then 1.4 when callDuration >= 30 and callDuration < 60 then 2.3 when callDuration >= 60 and callDuration < 120 then 3.7…
this is part of the database. The extention is .sql -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 20, 2011 at 05:08 PM -- Server version: 5.1.36 -- PHP Version: 5.2.9-2…
I was working with the MongoDB Atlas Server... and encountered this error... What does it mean...? Can someone explain in simple words plz... This was the query i was trying... db.posts.find({}, {title: 1, date: 0}) The structure of the posts…
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…