Open source has its advantages as well as challenges free more often than not means you are the master of your own destiny, technologically-speaking. Be that as it may, solutions are often within reach and well-documented by the developer community. The following are some guidelines, methods and techniques to develop a sound web application deployment […]

According to WordPress founder Matt Mullenweg, 18.9 percent of the web is using WordPress. Of that nearly 19 percent, more than half (66 percent) of these websites and blogs are in English. In May 2013, WordPress celebrated its tenth anniversary. Since then, 69 million sites have been built using the platform. Why are so many new sites […]

Problem Getting Values From Delimited Array in MySQL MySQL does not have an array type, and if you need to implement arrays, a delimted string is a simple way. If you are using strings to pass a delimited array in MySQL, you have run into the problem of getting a value out at a index. […]

Table Data Usage MySQL stores the amount of disk space it uses per table in the information_schema database. Getting the information out is a simple SQL statement, but it is stored in bytes, so if you want to see MB, mB, GB, etc it is a different query. To make this a simpler task, I […]

These days, to run a business,  you don’t need a physical office or even a dedicated phone line. What you do need in 2014 is a web page. Business webpages have replaced everything from business cards and storefront signage, to stationary and in-person customer service systems. And so, as most of us these days know, smart companies […]

responsive web development company

Internet access is no longer confined to just desktops or laptops. According to Search Engine Land, more than 95% of people access the web from a mobile device. Although mobile devices make accessing the web much more convenient, sites that aren’t optimized for mobile viewing are often unresponsive on these devices. The font displays too small, […]

responsive e-commerce web design

You’ve finally gotten your website up and running. The traffic is flowing in, but not as quickly as originally projected. Why isn’t your new website acting as the sales funnel you expected? Today’s consumer uses smartphones and mobile technology for purchasing. If your site does not use responsive web design, mobile shoppers may never see […]

Problem EXECUTE IMMEDIATE is currently not supported by MySQL for executing dynamic SQL, but with the following solution, dynamic SQL can still be one line. Usually writing dynamic SQL in MySQL requires 3 or 4 steps from beginning to end. They are build the query, PREPARE a statement from the query as a user variable, […]

MySQL does not have an array type that can be used in table definitions which precludes a programmer from using arrays in Stored Routines as well. This can be troublesome when a group of values need to be passed. I wrote a few functions and a stored routine example below to handle these situations. The […]

channelape

Otreva has been working on a new product called Channel Ape for the last few months. Channel Ape was designed to help omni-channel e-commerce vendors manage their platform in a single mobile friendly, cloud based system. Many e-commerce store owners are plagued with constant redundant management like order fulfillment, product data management and customer management […]