Linux and PHP web application support and development (Bromsgrove, UK)

tel: 0845 0046746

development

PHPUnit and PDO – max_user_connections reached

We have a set of PHPUnit tests running against a Propel/PDO application. Recently, with a recent increase in the number of tests, we’ve found that we’ve been hitting MySQL’s max_connections or max_user_connections limit (see /etc/mysql/my.cnf on the MySQL server).

, ,

Read more...

require.js – an introduction

When creating more complex web applications, you end up with more and more Javascript, which can quickly become difficult to maintain. RequireJS is one approach to helping solve this (and other issues).

, ,

Read more...

Looking ahead to PHP 5.6

PHP 5.6 is almost here (we hope) – so we’ve had a look at some of the upcoming changes, and here are the ones of most interest to us. In a nutshell – variadics & splat, constant scalar expressions and ArrayOf type hinting ….

, , ,

Read more...

FourSquare API Integration thoughts

We’ve been rummaging through a few REST APIs recently – trying to integrate and match up data from various providers with the aim of improving the overall experience on a website (and accompanying mobile apps) and the quality of search results. Here are some findings from using the FourSquare API – Things which are good […]

Read more...

Coding Katas

A useful way of ‘warming up’ in the morning is to spend 10-15 minutes doing a short task/exercise – partly to hone your skills as a programmer through practice and repetition – and partly just to get into the right frame of mind. See this article on wikipedia for more information and links, and one example String […]

, ,

Read more...

Improving site performance using asynchronous database writes and memcache in PHP

Web applications often have a requirement to log information about a request to a database. In a contrived example this could just be a global counter which attempts to amaze visitors to your site about how many requests you’ve handled in the last hour/day/week/month. One approach to doing this is to update a database each […]

, , , ,

Read more...

Upcoming talk – Native vs Hybrid mobile application development (WooWeb)

Tonight (2012/10/18), David will give a short (15ish minute) talk at the WooWeb meeting (Worcester, UK) covering mobile app development – specifically the advantages and disadvantages of developing using frameworks like PhoneGap or writing an app natively. Contents: Why PhoneGap? Disadvantages / Advantages of PhoneGap? Disadvantages / Advantages of Native development Example(s)

, , ,

Read more...

Being sued for security holes?

TechRepublic have an interesting article covering whether Software Developers should face legal action if their coding results in (presumably exploited) security vulnerabilities. Given that most security breaches result in data loss (for individuals) – fines from the ICO ought to be relevant – Tesco being investigated by the ICO Belfast NHS Trust fined £225,000 by the […]

,

Read more...

What you don’t want to see ….

A customer recently asked us to perform some enhancements to some code they’d purchased – when we started looking at it, some obvious glaring security holes stood out – //This stops SQL Injection in GET vars foreach ($_GET as $key => $value) { $_GET[$key] = mysql_real_escape_string($value); } And – if (isset($_GET[“job_id”])) { $job_id = mysql_real_escape_string($_GET[“job_id”]); […]

Read more...

Faster is better – rethinking SQL queries to improve API response times

At the moment we’re redeveloping an existing JSON based API, which is used by a mobile application. We knew the performance of the previous release of the API was good – it’s been in use for the last two years without any problems, and easily outperforms a competitor’s API. However, our dataset size is due […]

, , ,

Read more...

‹ Previous Posts