Linux and PHP web application support and development (Bromsgrove, UK)
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).
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).
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 ….
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 […]
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 […]
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 […]
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)
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 […]
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”]); […]
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 […]