All Questions
11,929
questions
0
votes
0
answers
57
views
npm MYSQL often in timeout
I am using mysql Pool to handle DB connections of my Nodejs server. Node server is used by a WebApp. Node server is deployed under Heroku, MySql DB is hosted by Google SQL.
A couple of times each day, ...
0
votes
0
answers
31
views
error while export data to csv from mysql in nodejs
i want to export data to excel from mysql using nodejs currently i have 5M+ records in database and throw error kill but when i have around 1.7M records at that time this is working so i think i need ...
0
votes
1
answer
93
views
javascript - heap out of memory
i have api in nodejs for read data from mysql database and write it into csv file and download file after complete write in csv file. when i have 1.7 million records in database it is working but now ...
0
votes
0
answers
27
views
Connecting of array with duplicate records with prisma
I have a project with prisma for a practice CBT software. on my database i am to recieve random questions for a particular topic and some questions will be duplicate(This is what i want). I connect ...
0
votes
0
answers
31
views
Typeorm Optimize Query - Fetch Message Rooms with only the latest message
I have a MessageRoom Table that can contain many messages.
I want to fetch all rooms with only the latest message.
This is for a chat app.
const rooms = this.roomRepository
....
0
votes
0
answers
32
views
DISTINCT query in Sequelize using belongsToMany relation and including many tables
I have two related models Product and Category which are joined with belongsToMany relation. I'm trying to fetch those products which has some categories using [Op.in] operator but can't get distinct ...
1
vote
1
answer
76
views
SQL syntax error when trying to create a new table using TypeORM
I'm doing the backend for a project using NodeJS. To manage the DB I'm using typeorm.
I've created several tables with no issues.
Now I'm trying to create a new table (or entity) that has a date ...
0
votes
0
answers
24
views
node js and mysql issue
I created a node.js app, that deals with a mysql database and also renders a very simple index.html as a front end.
I tried to deploy it on render but after a few second of successfull connection it ...
0
votes
0
answers
27
views
MySQL installation is all messed up, trying to untangle it [duplicate]
In the past I've used my local installation of mysql for my relational database needs. But it's been a few months since I used it, I've been working on MongoDB projects for the last year or so. I just ...
0
votes
0
answers
121
views
TypeORM save function seems to generate individual insert statements instead of one bulk insert SQL
I am using TypeORM as the ORM for my PlanetScale (MySQL) DB. I want to insert records in bulk. My code looks like this:
const batch = [{name: 'a'},{name: 'b'},{name: 'c'},{name: 'd'},{name: 'e'}];
// ...
0
votes
0
answers
30
views
error in sql query result while search with nodes [duplicate]
i have one query for search where i have string Ennemie d'état and if i search with key Ennemie d'état then it show data not found problem is in single quote (') my query is as below:
WHERE (
...
0
votes
0
answers
14
views
Problem defining associations in sequelize, I get 'Unknown Column' for the foreignKey used in the association
I am trying to use sequelize to interface with my MySQL db. The Database connection is setup fine, I can add, get, update entries. The main problem is when I define associations.
I want to define an '...
0
votes
1
answer
54
views
Node js and MySQL, i need to implement dynamic MySql connections, depending of who is connected to the server
I got an app, and i got different customers, let's say:
customer_1,
customer_2
i got the sequlize config
const Sequelize = require('sequelize');
const Op = Sequelize.Op;
const fs = require('fs');
...
0
votes
0
answers
68
views
How to load data to, and save data from a Handsontable to a MySQL database?
I am developing a web app where users can enter data into a spreadsheet like like UI and click on a submit button, and the data gets stored in a mysql database table.
I built the project with vite and ...
1
vote
0
answers
20
views
Error while excecuting a join query with sequelize
I have three entities Service, Sale, and SalesServices. The relationship within sales and services is of many to many:
associations.js
const User = require('./User.model');
const Employee = require('./...