Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations. Closed 5 months ago. Improve this que…
Tag: node.js
UNION ALL Slower than N queries
This question is following this question where I wanted to select the MAX value of multiples fields while retrieving each row. The accepted answer with UNION ALL worked like a charm but I now have some scaling issues. To give some context, I have more than 3 million rows in my matches table and the filters us…
loosing connection to sql server from express js api
Im building this api that gets data from a database and posts data to another database both located on the same server but it seems that im having problems with the connections when i first run the app everything works fine but after making some api calls it just crashes and doesnt work again my guess is conn…
How to convert Buffer to base64 image in Node js
I am getting data from my SQL database like this: How can I convert result to a base64 image in Node.js? For Example: ‘data:image/png;base64,iVBORw0KGgoAAAANS’ Answer Since you’re receiving a Buffer back as output, Buffer.toString(‘base64’) will convert the raw binary data in the buffe…
How can I extend an SQL query in a variable?
I am testing possible SQL injections on my DB, and I am running a simple function to get results which a user should not be getting. The return value is correct based on id, however, the rest of the query is completely being ignored. I want to return all the data from the data table. Is there something wrong …
use quotes in sql query node.js
I have my query like so: but when I insert the query into my database (I am storing the query for analytical purposes), it fails because of the quotes. how can I fix this? I tried converting thequery to toString(), but that was a useless attempt. Any other ideas? edit: error i am recieving is: Answer This is …
I am getting this error on inserting data in ClickHouse
Unknown error field: Code: 27. DB::ParsingException: Cannot parse input: expected ‘”‘ before: ’40”,”gmtoffset”:0,”open”:109.6,”high”:109.6,”low”:109.6,”close”:109.6,”volume”:0,”previousClose”:108.…
Error with passing in the same variable into multiple parts of SQL statement
So I have a Node.js query that should pass in these three values and update a specific column by a specific amount for a user with a specific id: The ‘sqlStatement’ looks like: As you can see, it should pass in the values such that the SQL statement looks like: I’ve also tried to write sqlSt…
Changing a column value to several records in a consecutive fashion using clever statements in SQL
I have a Postgres table that has an order view field in her, I’m using Nodejs with express This order view is of type INTEGER and has the constraints of NOT NULL and UNIQUE Inserting a new record may bring problems with that, because, if the existing records have view orders of, say, [1, 2, 3, 4, 5], an…
Sequelize – How to get reviews for post with likes count for each review
I have a function like this. It receives comments on the post. And it doesn’t work – it makes endless requests. If we remove this line, the function returns one comment with counted likes. And if you remove this block: … then the function will return an ARRAY of comments. Why does the like c…