I'm a junior web developer trying to develop my first Ruby on Rails project. I'm following this guide to deploy the app on render.com. However, after installing rails and following this command to create a database (I'm on Ubuntu): rails…
In this case I have seen the official documentation of choreo, ballerina, but I could not find how to execute a query where I need to filter by the ObjectId, In Java I could do it by importing BSON, but…
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?