probably someone has encounterd the same problem and have a solution. I have a SQL Database in my Azure Portal account. I have created a NodeJS application in a
in my database there are 2 tables : posts, room Posts tables include ID and Title columns and includes many rooms and hotels titles and IDs. In the room table t
I'm working on a monitoring system to retrieve hardware metric by telegraf and store the time-series data to TDengine. But seem the data insertion is very slow
I have a PostgreSQL database with Sequelize ORM and I want to listen for new entries. How should I do? Should I use Sequelize afterCreate hook? Can someone help
I have an app that spikes postgresql queries at morning 70% CPU usage, and has very few the rest of the day less than 20% usage. I want this machine to autoscal
I am unable to connect to PSql from my DigitalOcean server. This happened after resizing the droplet. listen_addresses = '*' added to postgresql.conf host all a
I have two columns price and sold_count for the product table. How do write sql query to find the top 3 shops having highest Revenue (calculat
My company recently migrated to Redshift from Redash recently and I'm having a hard time recreating the YEARWEEK() function available in MySQL but not in Redshi
We have: Postgres Database Photo: import {Entity, PrimaryGeneratedColumn, Column, ManyToOne} from "typeorm"; import {User} from "./User"; @Entity() export clas
I am creating a stock market simulator in flutter, which gets data from the fmp api. Can you use the same api key for all users or do I need to create a databas
include("src/database.php");#this included file works wll $query=mysqli_query($conn,"SELECT * FROM students limit 1"); $data=mysqli_fetch_assoc($query); echo "m
I want to connect the Wordpress pluggin wpdatatables to my Ms sql database, but every time i try it appear the next message: "wpDataTables could not connect to
I have tried the following steps to install and setup mongodb in my mac from here https://docs.mongodb.com/manual/tutorial/install-mongodb-on-os-x/ but I got th
I plan on creating an application on flutter that uses firebase auth and cloud firestore. My plan is to create a user and the use the user's u
I moved some of my data from PostgreSQL to BigQuery. Before PostgreSQL database was using 130 GB of storage, now I only need 30GB. However, in the Google Cloud
I am explaining with a simple example see my MongoDB collection looks like this: [ { pid: erwer, qty: 3, LevelDetails: {
I'm trying to connect to an IBM DB2 database using SQLAlchemy connection format but it keeps failing to connect. I am using these libraries: !pip install sqlalc
I got this message when I try to run query on XAMPP in macOS #1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, n
I have an application where it can have multiple thousands of urls. Let's assume the url paths are of the form, /app/v1/test1 /app/v2/test2 I want to store thes
Confused why getting this issue while trying to connect to my DB. Connection failed: No route to host <?php $servername = "HOST"; $username = "USERNAME