I am creating something like google drive or some cloud using PHP and HTML where you can save your files but i have problem with saving files to binary code and uploading it to database. I mean i want to…
language: Python 3.7.0 mysql-connector-python==8.0.31 I'm working on a website and have just implemented a database. The response I'm getting from the database looks like this: [('indigo', 'admin')] How do I extract the two values from the tuple in a list…
I am getting the error below when I try creating a database. Here is the database.yml: default: &default adapter: postgresql pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %> timeout: 5000 development: adapter: postgresql encoding: unicode database: MyDatabase host: localhost pool: 5…
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…