Otreva is looking for a rockstar web engineer who can work front end and back end in an MVC framework. That means you live and breathe database driven websites. We are looking for someone who understands that creating strong platforms that can connect with multiple social networks and is device agnostic is part of the […]

Sort Randomly and Efficiently Purpose There are many things on websites that developers need to display randomly and efficiently. Examples include classifieds, news feed items, and pictures. As a human, it makes sense to see a random list of the newest content posted to a website. If the website is getting thousands of images an […]

LAMP is a great software stack to get started with in building a reliable and efficient web application, but there are many instances when a program’s complexity requires a different database technology than MySQL—or RDBMS in general, to handle information storage and retrieval. This is increasingly the case as firms find new ways to leverage […]

As PHP has evolved into the lingua franca of web application development, so has its sophistication in terms of development methodologies and platforms. So it’s not surprising that the preferred approach in implementing software with PHP these days is to follow a model-view-controller (MVC) development framework. While this design pattern has been a popular in […]

Otreva was featured in the Scranton Times this weekend to highlight the new Lackawanna County Wireless network. Read more here

Mobile First is King Saying you can’t ignore mobile is like saying you can’t ignore your customers. With 53% of all Americans accessing the internet through mobile, and 31% of them as mobile-only, the better phrasing would be, “You still can’t ignore desktops.” That being said, the best approach to web design today is a responsive site or app […]

Web application development is ever-changing. As technology evolves, so do the alternatives we have to enhance a user’s experience. There are a number of trends that you’ll see in the coming months. These five are among the most likely to maintain momentum over the coming year. 1.  Different Types and Sizes of Fonts In the […]

Regardless of how much Google tries to discourage apparent search engine optimization (SEO) tactics, it’s still more important than ever to assure your website receives traffic. Say goodbye to continuous linking and keyword stuffing. Instead, it’s important for websites and content creators to focus on a different set of rules to earn Google’s trust. People […]

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