All Questions
Tagged with mysql javascript
39 questions
3
votes
1
answer
117
views
Consuming sharded database using node.js
I think the only big improvement that can be made is to check which shard to query based on the userIds of the followed users. One easy way is to check the last ...
user225166
0
votes
3
answers
994
views
url encoding and storing (JS, PHP, MySQL) [closed]
This question is about how best to encode, send and store information between JavaScript, PHP, and MySQL
I am doing a GET request from HTML/JavaScript to my PHP server, which is then storing the data ...
- 143
1
vote
1
answer
86
views
A Java EE7 web application for counting views in a static HTML page
I have this blog lurking around in the web. It's just static HTML, but I was interested to keep track of all the views on that blog. Finally, I end up with the following web application:
(The Java ...
- 30.2k
3
votes
2
answers
138
views
Wordpress Ajax Custom Query - High CPU LOAD
I'm developing a fully AJAX community WP theme that comes with a lot of custom queries.
Everything is fine, there is no bug but recently but I had a few clients that have a huge database and my theme ...
- 63
2
votes
1
answer
182
views
NODE JS Unlink and delete MySQL data
Here is my revised code from my other review question Node JS delete multiple MySQL linked records and delete physical file
Just would like to hear some reviews if I have the right logic.
...
- 235
4
votes
1
answer
275
views
Correctly using promises with node-mysql
I have been trying to do a simple query and return the results with node-mysql however I had several problems. Originally I wrote it where there was no promise, but ...
- 141
3
votes
2
answers
675
views
Getting data from database through Ajax post request
Is the method used below to get data from a database efficient and optimal? The data is in a MySQL database, and in my server I have a PHP file with the following code to return some information:
<...
- 131
0
votes
1
answer
61
views
Scrape page and send user only new results
Review Wanted
Application Summary
The application is a simple screen scraper which is to notify the user when new items are posted.
The code is run as a CRON job every ten minutes. It will scrape the ...
- 171
2
votes
1
answer
72
views
Dynamically inserting html from external file and updating the database
I need some suggestions on how to approach this. I want to allow users to create sections of website. The code so far is working but since I am new to back-end I feel like there is better, more ...
- 21
2
votes
0
answers
154
views
Querying Aurora via Node.js
Function queries data from an Aurora database. Aurora database is the MySQL engine therefore, I'm querying it with a MySQL NPM module. If there is something better, I'm all ears.
The calling function ...
- 153
1
vote
1
answer
138
views
Authentication using express-session
I'm making an online shopping store or e-commerce and I use an express session for many things.
Example: Shopping Cart, Authentication user*
I store the data chart list in the database based on the ...
- 113
2
votes
0
answers
876
views
Async/await Mysql wrapper
I used MySQL, but it was inconvenient so I made a wrapper.
It works, but I'm unsure if there are any issues.
Used node module - mysql2, bluebird
sqlWarpper.js
...
3
votes
1
answer
63
views
Handling download requests using PM2
I Using Nodejs v9.10.1 for handle download operation from another application. When using PM2 in fork mode to make alive my code. After 50 minutes, this will show high memory usage.
Server Config is ...
2
votes
1
answer
223
views
MySQL Connection URI Regular Expression
I'm currently working on a project that involves a MySQL database. To make life a little easier, I've been working on a regex that should validate and pull apart the different sections of the ...
- 249
1
vote
2
answers
1k
views
Router for quering MySQL results in NodeJS
What should I consider in order to refactor the following code ?
It seems very close to proudly become a Pyramid of Doom:
...
- 111