Pm2 is a great utility for keeping your Node production applications running. It provides high-level process management, and consolidates all your logs into one common location. In addition, you can…
While working with Node.js recently, I ran into a situation with the mode parameter used in several functions; fs.open, fs.appendFile, fs.writeFile, etc. When trying to create a new file and…
Don’t be scared, dealing with Mongo is not that difficult, especially with some help from Flash. While some people know of Mongo as a fictional planet where the comic and…
I have been using Code Igniter and Ext JS 4 for several months. In that time, I have created a couple basic templates to display MySQL tables and perform CRUD…
Using ALTER IGNORE TABLE [TABLENAME] ADD UNIQUE INDEX `UNIQUE_INDEX` ([FIELDNAME]) to remove duplicate rows in a table is a fast an efficient process, however on large tables where the physical…
The fastest and easiest way to delete duplicate records is my issuing a very simple command. alter ignore table [tablename] add unique index `unique_index` ([fieldname]) What this does is create…