I love how the SHOW TABLES query return the rows and the bytes for each table listed, but unfortunately, that's not the case for the SHOW SCHEMAS query. What's
I have this weird state that my db got into. Basically, some text is in mixed mode. windows-1252 and miscoded utf-8. Here's a sample: "donc d'être transpa
I want to Install Oracle Database Express on macbook m1 but it only supports linux and windows, I downloaded Sql developer but I m unable to download Oracle dat
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