Programming – Page 2 – MuratYaman.co.uk

How good are the abstraction layers?

April 15, 2015 by murat

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?

WHAT HAS CHANGED SINCE PHP 5.5.3?

March 19, 2015 by murat

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

February 17, 2015 by murat

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.

class TestFilters extends PHPUnit_Framework_TestCase
{

    public function test_filter_int_with_zero_prefix ()
    {
        $result = filter_var('01', FILTER_VALIDATE_INT) !== false;
        
        $this->assertTrue($result);
    }
    
    public function test_filter_int_with_zero_suffix ()
    {
        $result = filter_var('10', FILTER_VALIDATE_INT) !== false;
        
        $this->assertTrue($result);
    }
    
}

class TestFilters extends PHPUnit_Framework_TestCase

{

public function test_filter_int_with_zero_prefix ()

{

$result = filter_var('01', FILTER_VALIDATE_INT) !== false;

$this->assertTrue($result);

}

public function test_filter_int_with_zero_suffix ()

{

$result = filter_var('10', FILTER_VALIDATE_INT) !== false;

$this->assertTrue($result);

}

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

PHP is dying faster because … (part 2)

February 17, 2015 by murat

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)

February 16, 2015 by murat

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)

EU VAT Number Validation SOAP Service

January 9, 2015January 9, 2015 by murat

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

October 19, 2014July 30, 2014 by murat

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

Composer for PHP: Do we really need it?

June 8, 2014June 8, 2014 by murat

If you are wondering what we are dealing with in PHP world on a day to day basis, here is an example: just check http://getcomposer.org and autoload*.php files in it!! It’s supposed to be a solution!? First of all, PHP saved us huge pain by autoloading classes. It’s been brilliant! Now, it is a mess, … Read moreComposer for PHP: Do we really need it?

To use a framework or not to use a framework: again!

October 2, 2013October 2, 2013 by murat

If using a PHP framework is recommended for its reusability, maintainability, popularity; why would a developer create a web application which does not have many reusable parts, which is not easy to maintain, and which takes time to learn even though you can easily find another developer who used it before?! Here are some interesting … Read moreTo use a framework or not to use a framework: again!

Postgresql and Node.js 100% Javascript Adventure – Part 2

September 15, 2013 by murat

This is the second part of PostgreSQL, Node.js and JavaScript post. We can continue by installing PL/V8:

sudo apt-get install postgresql-9.2-plv8

1	sudo apt-get install postgresql-9.2-plv8

Then we can create the extension in our database.

sudo su postgres
psql mydb

1 2	sudo su postgres psql mydb

And run SQL command below:

create extension plv8;

1	create extension plv8;

Then, we can create functions using PL/V8 JavaScript language. A simple example is below:

CREATE FUNCTION public.service (
  inputs pg_catalog.json
)
RETURNS pg_catalog.json AS
$body$
var result = {};
var cmd = 'SELECT * FROM tbl_test';
result.outputs = plv8.execute(cmd);
result.row_count = result.outputs.length;
return result;
$body$
LANGUAGE 'plv8'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER;

CREATE FUNCTION public.service (

inputs pg_catalog.json

)

RETURNS pg_catalog.json AS

$body$

var result = {};

var cmd = 'SELECT * FROM tbl_test';

result.outputs = plv8.execute(cmd);

result.row_count = result.outputs.length;

return result;

$body$

LANGUAGE 'plv8'

VOLATILE

CALLED ON NULL INPUT

SECURITY INVOKER;

It gets variable inputs as JSON … Read morePostgresql and Node.js 100% Javascript Adventure – Part 2