Choosing the Right NoSQL Database Type [Slide] NoSQL is the next big thing in big data. Since the technology is relatively new undergoing innovations every now and then, it is safe to say there are no defined standards related to NoSQL database. NoSQL databases most popularly get categorized into the following four types: Key-Value Store Document-based Store Column-based Store Graph-based… Read More
3 Issues in MySQL concatenate String in procedure for dynamic DML I was trying to figure out one of my long coding procedure issue in mysql that I just did and could not find exactly problem. Let’s have a look one of my sample issue as a use case during my experience. I create a procedure that contain a very long dynamic insertion string by using… Read More
MySQL Workbench – Error Code: 1175. You are using safe update mode When you execute the update/delete request in MySQL workbench and you got the message error as: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column And in MySQL Workbench also mention how we solve this issue as well by following message: To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect… Read More
Upgrade WampServer 2 to 2.2 or latest without losing data and less config WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. I found WampServer is an easy tool for development PHP app in Windows. But since, I have to upgrade my development environment to match my production server for PHP 5.3.x and MySql 5.5.x, WampServer… Read More
Oracle PLSQL – Function to Spelling Number to other language automatic You might face the same issue to me when you want to spell number to text in different language than English. Here is the solution I asked in StackOverflow and made together with the one who initialized this idea, it’s kind of a great idea you may want this experience. We used Yahoo Babelfish translation… Read More