When using MySQL Stored Procedures in your application, it is important to be able to return multiple messages to the caller. MySQL will take care of all the directly database related errors, such as table not found, but for user errors, there is not much built in for that. An example of this would be […]

The research outlines the focus and capabilities of 8 top design and development firms specializing in Ecommerce solutions for the Shopify platform [including Otreva]. WASHINGTON, December 10, 2013 -­‐-­‐ Today SourcingLine published their initial Leaders Matrix on leading Shopify Designers & Developers. The proprietary Leaders Matrix analyzes each firm’s focus in Shopify design and development […]

Here at Otreva, we use MySQL stored procedures (SPs) in the back end of our projects.  It gives very precise security controls and modularity to functionality across multiple applications.  This is a performance booster for us in most cases because of the complexity of the functionality.  This article is not to discuss the pros and cons […]

We’ve been asked dozens of times by current and potential clients, why should I consider a responsive web design for my website or application instead of a completely separate mobile site? The short answer is, responsive design isn’t the best solution for everyone. Here are Otreva we don’t force responsive design onto clients. We recommend […]

Recently the development team here at Otreva created project named “How much does it cost to build an app” and built the site from the ground up in less than 24 man-hours on a Saturday afternoon. The goal was to produce an application that app pioneers, entrepreneurs, inventors, and innovators could use to estimate development […]

If you are like me, you are wondering why in the world Amazon Web Services Cloudwatch service doesn’t allow you to monitor memory usage?  Luckily they do allow you to use custom Perl scripts to create your own custom metrics. The following instructions will show you how to setup memory monitoring on your ElasticBeanstalk EC2 […]

Otreva is looking for an experienced front-end web developer to join our Jessup, PA based team. We need someone who is ready to jump in and get involved with every aspect of the product development process all the way from conception of the new features to collaborating with our entire team to ensure the proper […]

You’ve probably ended up here because you have an idea for a web application and want to see if it is something that can feasibly be done within a certain budget. For the most part, the bulk of the budget you are putting forward is for development time for experienced programmers, designers, and product managers. […]

We were recently asked on our Deploying WordPress to Amazon Web Services AWS EC2 and RDS via ElasticBeanstalk post how to easily manage multiple environments and multiple databases with one codebase. The answer with Amazon’s Elasticbeanstalk is pretty straightforward. Step 1: Launch a new environment within the same application. Step 2: Once that new environment is in […]

UPDATE*** Staging accounts are no longer supported: Hi Mike, Greetings from Amazon Marketplace Web Services Support, At this time we do not offer staging accounts for our Marketplace Web Services or MWS service. Though we have had sandbox or staging accounts in the past, it is no longer offered and the only place for the […]

We’ve internally been using Atlassian’s Bamboo CI and Jenkins CI build servers for some time now. As we have begun maintaining an ever growing codebase for our clients, we found it nice to have a CI server status board that our team can glance at throughout the day to see build and test statuses, integration […]

A common question we get asked is how do I ensure my WordPress application can scale with an influx of demand? What can I do do ensure high uptimes and great performance? As a member of the AWS Partner Network, our typical response is to build an auto-scaling, self healing cloud application using AWS ElasticBeanstalk. AWS […]