Oliverde8's blue Website

Magento2 & PHP Optimisation - Coding well

I am not an expert in optimisation, neither is it a passion of mine to dive into others people code to try and optimise a page. But well these few days that s exactly what I was doing and I needed to rant a bit. You don t always need to be an "expert" to optimize a page, good sense is usually sufficient for most cases. In this case, I had to optimize a cart page that needed over 30 seconds to load on my dev environment. xhprof or blackfire is your best ally to try and figure you where to start with. They won t point you to where the issue is, even less so in Magento with Plug ...

Read more

Building a Simple PHP-ETL

Anyone of you fallowing my github might have seen that I have recently created a new library : PHP-ETL Recently I had a did a few repetitive projects, all of them consisted of transforming a csv file. I ended up identifying these repetetive tasks. Transformation : I identified the transformations very early in the process, and coded the RuleEngine a while ago. Grouping : On a few of the occasion I ended up having to group multiple lines of the csv file into one line. This I had todo to create configurable products from variants for exemple. Multiple destination : Quite often wh ...

Read more

Akeneo 2.0 - An alpha at it's best

I have been working with akeneo 2.0 for a few month now and I can say it has been a lot of frustrations. I will try to balance this article with nice new features in Akeneo 2.0 but not sure I will be able to balance much. Variations First of all let’s talk about “the” main feature in this 2.0, variations. Indeed the variaiton modelisation is much better. Using the interface is easier and variations can be found easily without much issue. If you have watched any of the Akeneo videos you will see how well it looks and seems to work. But here is where the dream ends, ...

Read more

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

xCMw-grafana.png

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

Assassin's Creed Origins

After a year of break AC is back. And this time we are going back way back in the past, into Egypt. Agains public opinion I quite liked AC Unity & Sydicate which I thought was both good games; even throught they were not exceptional. Syndicate was better with both twins being more fun while Unity was quite dull. But well compared to Black Flag, both remained unexceptional games. The main issue with both games was the story and the repetitive side quests. Black flag offered more diversity as the map represented a bigger area; but both Unity & Syndicate were in a single City and ...

Read more

68337136d43f24194e1a4efa02aa2d91cd2c986b[1].png

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

indiefix_ksp1.jpg

Kerbal Space Program (KSP)

I am not sure why it took me so long to write a review about this game, that said I haven t written a review for Maniaplanet either. But that s another story. KSP is one of these games I never intended to actually play, I hadn t ever heard of it, and even if I had would see no reason to do play it But one evening one of the twitch streames(braincage) I tend to watch started playing the game, at first I didn t think much of the game, braincage was discovering the game at it was hard to see any purpose to the game. Not sure how, I ended up in AkinesisGaming s channel. At that time Aki wa ...

Read more

2dd7c2aefb5d6589f101b8f2d34d15fa8d361ea7.jpeg

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

Symfony_Sonata05-300x230.jpg

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