Here at Otreva we are big fans of GIT and also the Gitflow workflow. We were recently creating an Atlassian Bamboo continuous integration plan on our OS X Mac builder which needed to know what currently checked out GIT branch was currently being built since we are using Bamboo’s automatic branching feature. We were then building […]

Is Titanium crashing when you try to load it on Ubuntu with an error similar to: # # JRE version: Java(TM) SE Runtime Environment (7.0_72-b14) (build 1.7.0_72-b14) # Java VM: Java HotSpot(TM) 64-Bit Server VM (24.72-b04 mixed mode linux-amd64 compressed oops) # Problematic frame: # C [] webkit_web_view_get_type+0x2489 # The fix is simple, just disable […]

Are you trying to get the Android SDK up and running with Titanium Studio on Ubuntu, but can’t seem to get Titanium to recognize it? After spending hours, I found the solution which is quite simple. The issue really stems from NodeJS. On Ubuntu, node is actually the Amateur Packet Radio Node program. NodeJS is the package we want. […]

Responsive web design has come a long way in just a few short years since being introduced. It has allowed development shops like ours the ability to help out clients reach their end user regardless of what screen size the device they are using is. Responsive design takes an interesting approach to the problem mobile […]

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

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

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

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

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