< description

Notes, thoughts, failures. A blog.

< tags | sort -R | ಠ_ಠ
soyuka@soyuka.me ~/soyuka.me/tags/php/

Streaming big json files the good way with php

Json is now really popular to share data between components. I’m working on an small EAI (Enterprise Application Integration). It’s basic purpose is to transform and integrate data from an application to another. Original data is transformed to JSON from an SQL instance, parsed by the EAI and backed up in another database with transformations and tests. The problem This seems really simple on the first look, but when you work with big files, you can not simply json_decode a file and put it back where you need too.…
~1500 Words

Install nginx, php-fpm with oracle on Debian Wheezy

Install Oracle instant client

First of all, download those both files from the official Oracle website:

  • oracle-instantclient11.2-basic- library files later extracted in /usr/lib/oracle/11.2/client/
  • oracle-instantclient11.2-devel- headers files extracted in /usr/include/oracle/11.2/client

~600 Words

Install php5 php5-fpm and nginx on Debian 5 Squeeze

In many tutorials I’ve seen that you should use dotdeb packages like this:

vim /etc/apt/sources.list.d/php-fpm.list

deb http://packages.dotdeb.org stable all  
deb-src http://packages.dotdeb.org stable all

~100 Words

Installing OCI8 extension for PHP 5.4 debian wheezy (x86)

“Welcome to the oracle hell”… Just read that on the php OCI8 man page and it’s true. Installing OCI8 extension wasn’t hard but took a lot of googling time… I’m describing here what I did to accomplish this hard task.

~500 Words

CSV vers MYSQL en php

Transformation d’une ligne csv à une requête SQL, le script remplace toutes les entrées à chaque fois, il ne met pas à jour mais est facilement transformable (voir la variable $q).