Tagged Questions
0
votes
0answers
16 views
Node.JS Ensure Config File Ready
I have a config.js file for Node that I have set user data, database connection data, and IP address for the server. As I am working in multiple environments I have configured the config.js file to ...
0
votes
2answers
55 views
Which's the best DB(NoSQL or regular SQL) to choose using Node.js? [closed]
I've read that there are more information about using MongoDB with Node.js rather than MySQL and that is a concern for me, because I'm used to work with MySQL. In terms of development and performance ...
0
votes
1answer
33 views
Caching mysql database with node.js
I need to provide a caching layer for mysql database on my node.js server app.
The caching should be able to hold array objects (not just a key-value store).
What module should I use for it ?
...
0
votes
1answer
19 views
Using mysql instead of redis to share context for clients hitting multiple instances
Okay , i went through a few posts regarding scalabality of nodejs/socket.io . And in all cases i found out that apart from using load balancers , it is recommended to use redis for key:value storage ...
0
votes
0answers
13 views
Using transactions for deleting posts and related attributes
Okay i have a database with the following tables for posts and related attributes :-
The post content table (with post_id as primary key)
The user table (with user_id primary key)
The post_upvotes ...
0
votes
2answers
19 views
unable to remove SQL syntax in UPDATE query
I am updating table when i run this query it give an error:
client.query('UPDATE Campaign SET ( Name, StartDate ) VALUES ( "' +req.body.Name+ '" , "' +req.body.StartDate+ '" ) WHERE idCampaign = ' ...
0
votes
0answers
16 views
node.js , mysql too many connections on multiple clicks
Okay i have implemented a like button in my website using node.js/socket.io . Whenever the user clicks the like button the following stuff happens -
1) using jquery i check the data-islike attribute ...
0
votes
0answers
7 views
How to use hasOne() method of orm2
var Student = db.define('student',{
name:String,
departmentId:Number
})
var Department = db.define('department',{
departmentId:Number,
departmentName:String
})
now,I want to get the departmentName ...
-2
votes
1answer
33 views
how to create a chat in php website [closed]
I'm working on a huge project which is written with php.
At the beginning I have start to develop it on node.js.
As there the creation of private chat was not a big problem.
But in fact As I was ...
-2
votes
0answers
18 views
Global array in node.js [closed]
Using node.js 0.10.8. I currently have an application that is comparing netflow src and dst ip addresses to a MySQL table where a username is associated to an active ip address. Every netflow packet ...
0
votes
1answer
23 views
'OkPacket' in mysql module of node.js
I'm trying to get results by each row from mysql table:
query.on('result', function(row) {
connection.pause();
console.log('First Name: ', row.FirstName);
...
0
votes
1answer
43 views
How are left join, inner join, union of mysql can be replicated in redis
I think cross referancing is a good way of learning. I made some research on redis and it seams that as a schameless database redis don't have tables. Instead of tables it has got key-value, key-list, ...
0
votes
1answer
24 views
How do I add a lot of data to Sequelize model?
I have many .txt files where each line has some data that I want to add to a model, so that it can be ready for querying. The problem is that none of the "insert" queries are being executed, probably ...
0
votes
1answer
18 views
NodeJS Mysql Stop Server Crash on Error
I am using https://github.com/felixge/node-mysql
and everytime a mysql query throw an error, for example if a row does not exist. The node server crashes.
connection.connect();
...
0
votes
0answers
43 views
Sharing sessions across php and nodejs using a database(preferably mysql)
I am designing an application where i need to share sessions across php and nodejs . What i'm designing -> A real-time notifications system . I want the node.js application to get the user_id from the ...
-1
votes
3answers
33 views
PHP and MySQL - How does PHP connect to the MySQL server? [closed]
I am in the process of connecting a Node.JS server with a PHP application (on the same VPS) and a solution that I have found was to communicate via cURL.
I am thinking of going one step further and ...
-4
votes
0answers
20 views
I am xampp user and I love xampp [closed]
I am xampp user and I love xampp. But which is better xampp or simply install all php, apache, mysql separately so that even when i install node.js, ruby in my system i can access mysql?
(if you ...
1
vote
0answers
23 views
Application does not terminate with MySQL pool
I am writing a nodejs application and want to use connection pooling.
However, the following application does not terminate - although I would expect it to terminate after the call to ...
0
votes
0answers
33 views
ECONNREFUSED mysql nodejs
I'm trying to follow the 'tutorial' on http://www.gianlucaguarini.com/blog/push-notification-server-streaming-on-a-mysql-database/ to get accustomed to node and node+mysql. It throws an error whilst ...
-1
votes
0answers
20 views
Syntax error in node-mysql query
I am creating a table but at Foreign KEY it gives syntax error
client.query('CREATE TABLE AgencyUser '+
'(idAgencyUser CHAR(36) NOT NULL ,'+
'FullName VARCHAR(45) NULL ,'+
'Email ...
0
votes
1answer
32 views
Insert query is not inserting values in the table
I want to insert the values that i get from req.body. I save it in variables then pass them as values in the insert query. But nothing saved in the table.
Please help me out:
var name=req.body.Name;
...
-2
votes
0answers
27 views
nodejs with mysql and elasticsearch [closed]
Could there be anything potentially wrong with this combination? Anything I should keep in mind ? I have a solid understanding of nodejs/js
The site is mainly going to have search (hence ...
0
votes
0answers
26 views
MySQL/node.js transactions within a stored procedure intermix
I am using a single MySQL client for multiple HTTP requests in node.js. So if I run transactions the queries could probably intermix. For example the first page request runs a transaction on the MySQL ...
1
vote
1answer
45 views
How to perform CURD on mysql using Node.js
I am new in Node.js. Well i have experience in Backbone on Client side and Server side using PHP Laravel framework.
I want know is following connection/communication workflow is correct or possible:
...
2
votes
2answers
42 views
How can we use Node.js on server side
I am new to Node.js. Are we able to connect mysql with Node.js directly or we need any npm installation to perform it and if i am using nosql database like MongoDB then how can we connect it with ...
0
votes
1answer
66 views
Node.js and MySQL “Too many connections” error
I'm using Node.js to run a web-server for my web application. I'm also using the node-mysql module to interface with a MySQL server for all my persistent database needs.
Whenever there is a critical ...
0
votes
2answers
41 views
Query to get recent messages in a 'threaded' view
I'm trying to rebuild an existing messaging system so it looks similar to Twitter's DM service. Currently I am only showing unread messages to my users, but I would like to show messages sent between ...
1
vote
0answers
35 views
Disconnect event fired many times in socket.io
I've implemented a simple chat application .But when client leaves the page or closes browser tab disconnect event is called many times. Some time twice some time thrice. Inside disconnect call back ...
1
vote
1answer
65 views
Socket.io for checking updates from database
I have a node.js server that connects to a mysql database and opens up a new socket using socket.io. The role of this server is basically to notify any client (user) that connects to it when there's a ...
1
vote
0answers
57 views
Retrieving chat history and saving it into mysql in node.js
I've developed a chat application using socket.io that is working fine
Code is like this
var sys = require('sys');
var fs = require('fs');
var io = require('socket.io');
var Server = ...
