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 […]


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 […]

responsive e-commerce web development

Using responsive e-commerce development may have been a trend just shy of two years ago, but it’s not going away anytime soon. Responsive web design means that your website is resized depending on what device the site is being viewed from. It creates flexibility in a website’s layout, fonts and pictures in order to adapt […]

Jessup Tekridge Center Otreva

After the past year in an amazing space, Otreva has moved our offices to a larger space in the TekRidge center in Jessup, PA. We will miss our wonderful neighbors at Appek Apps. Come by and say hello if you are in the area. New Address: 50 Alberigi Drive Suite 110 Jessup PA 18434

Our applications can get 10’s of thousands of images uploaded daily. The business requirements asked that the image names be obscured, so someone doesn’t write a simple crawler to get image 001, 002, 003, etc and that the images are stored in an S3 bucket. We came to the conclusion to create and store the […]