Two weeks back, in our project, we noticed that there were lot of values with leading and trailing white spaces in our database and also many duplicate row entries, as a result of which our program was not working correctly. I was assigned the task of cleaning up our PostgreSQL database.
There were two clean ups to be done:
1. Stripping of leading and trailing white spaces in string values.
2....
Popular Posts
-
If you are building an Angular.js application and wish to add a modal dialog box or a simple popup, then the ngDialog module provides an...
-
A quick way to delete redis keys from the command line would be: redis-cli DEL "del_key" If you wish to delete all k...
-
"Actually, the best gift you could have given her was a lifetime of adventures..." - Lewis Carroll in 'Alice in Wonderlan... -
Programming. Geeks. Both were initially new to me when I entered college. Apart from few basic programs which I had done using C in high ...
-
Two weeks back, in our project, we noticed that there were lot of values with leading and trailing white spaces in our database and also m...
-
At times, we have a requirement to calculate the number of weekdays / working days between two dates. Here's how you do it using Pytho...
-
Recently, in our project, I was asked to configure Nginx for load balancing as our app was becoming slow, owing to high traffic. I haven...
-
As I was solving a couple of problems in Checkio, I came across a new concept - lookaheads in regular expressions. At first, it was sli...
-
"We travel not to escape life, but for life not to escape us." Last week, I had taken my parents to Manali on a family adve... -
"We live in a wonderful world that is full of beauty, charm and adventure. There is no end to the adventures we can have, if only w...