Oliverde8's blue Website

Mysql, the limit's of the offset

I was in conversation with a friend the other day, and we were talking about exporting by batch big quantities of data. I am not sure how we ended up talking about how using the "LIMIT". There are a few mistakes people does when working with SQL and adding LIMIT s with an offset to their queries. A database allows us to query a database and have results rather fast; but some very simple queries can create performance issues. It s important to understand the basics of how things work to understand the issue. In this article we will talk about the usage of the "LIMIT" ...

Read more


Grafana - Data visualization

I don t know if you ever heard of grafana, few people even in the computer industry has. Grafana is a great tool to visualise data. I have been using grafana for over a year now to have statistics on the usage of eXpansion. A tool I made for the Maniaplanet game. More know to many people is Kibana, and indeed I also started there. I first used Kibana to make visualise statistics on the usage of eXpansion. But I realized very quickly that Kibana was not designed for that. Kibana is designed for logs monitoring; I could get nice graps showing me stats about the different versions of the tool ...

Read more


eXpansion2 - Abandoning Doctrine & Going with Propel

Among the many things I try and manage at home one of my favorites ongoing projects is eXpansion2. For those that doesen t know what it s about; it s a server controller for the Maniaplanet(Tracknmania) game. It connects to the games dedicated server and adds interfaces to manage the server as well as new features such as records. The controller runs as a deamon on the server. eXpansion is a project we started a while back, been 5 years or maybe even more. The first version was based on a controller made by the game s developpers. The last version of the game has broken our controller a ...

Read more


Akeneo 1.7 - OAuth

One of the wonders of Symfony is how easy it can be to add new features to existing systems. We are going to add OAuth support to Akeneo PIM which is a Symfony based php application. In order to do this wer are going to use the awsome HWIOAuthBundle. Prerequisites Have basic SF knowledge(and thefore composer...) Have a working Akeneo 1.7 accessible from akeneo.local.com Let s get going Firs of all let s us install the hwiOAuthBundle, composer require hwi/oauth-bundle We shall now enable it in the `AppKernel` new HWI\Bundle\OAuthBundle\HWIOAuthBundle(), ...

Read more


Sonata, MongDB & Symfony 3.3 on PHP7.1

I wanted to know if it was possible to use Sonata with mMngodb. After some research I found out that it was indeed possible. If there is one thing I love it s discovering new things, trying out new things. There is so much I would like todo, sadly weekends are to shorty for all the experiments I wish to run. I would like to write about those experiments more often, but it takes quite a lot of time to write these articles; so usually I don t write much about it. But getting mongodb sf3.3 with sonata working without a mysql server has been slightly more complicated then expected, becaus ...

Read more


For what's worth, my thought on Magento2

I have been working with Magento in general for over 3 years now. And with Magento2 in particular for 1 year or so. So I thought it was time to make a small article about what I think about Magento2. It brand new Well Magento2 comes with plenty of new things, Zend2 & it s Dependency Injection System, which is enchanced in M2. The api layer for interacting with the DB. The native rest/soap api s. Magento 1 did have a few, but M2 make it much easier to create new API s sing the api layer. Composer out of the box (finally) Improved layout systemp with ui ...

Read more


Akeneo 1.6 : Creating an Installation Bundle.

In the cook book of Akeneo we can find a section about how to cutimize the dataset : https://docs.akeneo.com/1.6/cookbook/setup_data/customize_dataset.html For having done this a few times I can say that the instructions are not very clear if you wish to do slightly more then what the default installer does.. To keep the tutorial short I will consider that you already know symfony, and won t give precissions on how to create a bundle or such details. First let s create our own dataset then we will see how the akeneo installation of the dataset s work in order to really understand w ...

Read more


Optimizing Akeneo / Configuring APC & OpCache

Optimizing Akeneo / Configuring APC & OpCache Since I started using Akeneo I never really was impressed by the load times. The time it takes to go from the grid to the product edit page is simply to long. I had times around 7 seconds for a relatively small project and well it needed to be improved. After a little investigation I found that the slowest operation was in Symfony\Component\Translation\Translator::initializeCacheCatalogue The strange part is that it was the inclusion of the php files that was slow even throught I had apc cache activated. So I decided to look a bit mo ...

Read more


Is Node.js really be better then PHP? A pointless discussion

Recently there has been lot s of articles about how great & superior node.js is vs PHP. So I decided it was time for me to give it a try. Of course I know that node.js isn t a language but more an integration of javascript as a server side scripting language. Performance The main point that is pointed out is the speed thanks to it being non blocking. That quite bugged me. On the majority of the applications I have worked on Symfony, Magento(1&2) Drupal... The main reason the application takes times to open is the database. So Node.js will be faster because it s going to be able t ...

Read more

PHP running Asynchronous processes

I have been programming in PHP for quite a while now, and even through at work & for my own I use PHP quite a lot for creating website I actually started programming in PHP with daemons and still continue to do so. My main development for PHP daemons has been for Maniaplanet controllers like eXpansion. Well particulart for those who don t like PHP, it does sound dump to use PHP as a daemon right? Well it isn t as dump as it sounds. The advantage of using a script language for the controller is to make it easily extensible. We ask people to copy paste files at the right place and there i ...

Read more