How good are the abstraction layers?

Choosing the features based on the lowest common denominator of X number of database systems is not the right approach in implementing an ORM! https://github.com/laravel/framework/pull/8400 This forces us to question the value of database abstraction layers and other abstraction layers in general. If one database system does not support a feature, the abstraction layer developer … Read moreHow good are the abstraction layers?

Managing date fields properly with correct time zones in PostgreSQL

In apps for users all around the world (even in apps for local users where DST applies) correct time zones should be set, after database connection is established, based on the user’s time zone setting (rather than hard-coded setting in app). Then, data read/write ops should be automatically handled by the database. For example, in … Read moreManaging date fields properly with correct time zones in PostgreSQL

WHAT HAS CHANGED SINCE PHP 5.5.3?

A LOT! From: http://www.charliebaird.co.uk/bugs_2000.htm Bugs are not always cute. So, we need to upgrade all software applications we use on a regular basis. Ref: php.net/ChangeLog-5.php Version 5.5.22 19-Feb-2015 Core: Fixed bug #67068 (getClosure returns somethings that’s not a closure). Fixed bug #68925 (Mitigation for CVE-2015-0235 – GHOST: glibc gethostbyname buffer overflow). Fixed bug #68942 (Use … Read moreWHAT HAS CHANGED SINCE PHP 5.5.3?

PHP says “Nooo” to my integer

Another eye-opener from PHP is the unexpected behaviour of integer filters. Here is a test case class checking “01” and “10” whether they are integers or not.

Refer to: http://php.net/manual/en/filter.filters.validate.php

PHP is dying faster because … (part 2)

PHP 5.0 was released in July 2004. Almost 11 years and we know that they gave up on PHP 6.0 🙁 In IT world, that is a massive failure and a huge embarrassment! Think for a minute: thousands of “genius” developers working together to improve PHP itself, rather than creating another bloody framework!!! How would … Read morePHP is dying faster because … (part 2)

PHP is dying faster because … (part 1)

PHP was well-known for its speed of development (no compilation or formal build process); even for developers from alien worlds like Java esp. when developing prototypes; because it was easy to learn, develop and deploy on almost any platform. I have been coding for almost 18 years now. I picked up PHP as a natural … Read morePHP is dying faster because … (part 1)

Online Relocation: Moving from 1and1 to AWS Route 53 and Digital Ocean

Even though it is time consuming, I think we have to reconsider our web hosting options regularly. If our current provider does not renew its products and services, together with their pricing structure (Amazon does, 1and1 does not), they become less competitive. After long research, I have decided that AWS has confusing pricing structure and … Read moreOnline Relocation: Moving from 1and1 to AWS Route 53 and Digital Ocean

EU VAT Number Validation SOAP Service

We are a VAT registered company in UK, and I am the lead developer of a small team. http://www.whatusersdo.com/ Like many online global businesses invoicing clients from many different countries, we are obliged to invoice them correctly with or without VAT whether they are VAT registered companies within EU or not, or individuals, etc. So, … Read moreEU VAT Number Validation SOAP Service

Architecture is everything, plan for speed at the beginning

We’ve recently needed to compare our file storage areas on Amazon and Rackspace. We’re mainly using Amazon S3 and using Rackspace Could Files to backup those files in S3. I’ve written couple of simple PHP scripts to get information (name, size, etag, date modified) about the files kept on Amazon and Rackspace using their corresponding … Read moreArchitecture is everything, plan for speed at the beginning