Developers Club geek daily blog

As through composer it is convenient to change a system package for its alternative version

1 year, 1 month ago
In any big project where composer is used, there is one problem sooner or later. In a framework, or in its some separate packet correct an error or add functionality, and the developer does not hurry to accept pull request. At the same time there is a wish to use temporarily updated packet, and then when pull request after all accept, to return to the official version. The situation is also complicated by the fact that the packet can be specified in dependences of other packets therefore just to replace one packet with another in composer.json it will not turn out.

Read more »


Pagekit: the overview of modular CMS based on Symfony

1 year, 1 month ago
Pagekit: обзор модульной CMS на базе Symfony

Get acquainted: Pagekit is the new modular CMS from the German studio vendor of the YOOtheme templates based on Symfony components, and also Vue.js, Webpack, Doctrine and other modern technologies. Pagekit reflected as a simplicity combination in management to flexible opportunities for development — what is not enough for the known CMS based on PHP and having a set of anachronisms.

Read more »


Reefs of use of Excel Power Query and MySQL for automation of the reporting

1 year, 1 month ago
image
All hi.
There came new 2016, so it is time to update tools for simplification of boring mechanical work. Departments of analytics, marketing, sales often face the following difficulties when updating the reporting:
1. Data should be aggregated from several sources.
2. Reports are formed in Excel that imposes considerable restrictions for volume of the processed data.
3. Modification of the unloadings which are in advance configured by developers business as a rule not the faster.

If reports need to be updated weekly or even daily, then this procedure becomes very napryazhny even for the most patient. By means of a superstructure of Excel Power Query and data record in MySQL it is possible to reduce updating of the majority of reports before simple clicking of the Update button:
1. Data from any quantity of sources are imported through SQL queries to the normal tables Excel.
2. Even from big base it is possible to write in Excel only small part of data (for example, total sums for the necessary range of dates with grouping only on the necessary columns).
3. Changes can be made to the report just having changed the SQL query. Further we create the necessary report standard means of Excel.

I will show how to configure and autocomplete the simple MySQL databases (on the example of unloading of statistics of all key word from Metrics Yandex) in this article, and then one button to update reports in Excel, using Power Query superstructure. Power Query has very strange features of work by drawing up SQL queries (especially dynamic) which we will sort in the second part of article.

Read more »


Php Inspections (EA Extended): we select strategy for 2016

1 year, 1 month ago
With come new year, the habrovchena!

2015 was PHP which are very sated for the world: it both long-awaited release of the 7th version, and major updating of many frameworks, and set of promising RFC.

For Php Inspections (EA Extended) last year was very saturated too: the project was issued, very quickly matured and could make the world of PHP a little better (symfony2, symfony 1.5, PHP CS Fixer).

Further (under a cat): several polls and an opportunity to influence the choice of strategy for 2016.

Read more »


RNR-Daydzhest No. 76 – results of 2015, a selection of interesting links + tender from the JetBrains company

1 year, 2 months ago


Following tradition, we decided to sum up the results of the expiring year and to select the most significant events in the world of PHP which, fortunately, there was much. And of course, a selection with links to fresh materials for the last three weeks.

Under a cat you are also waited by tender with prizes from the JetBrains company.
With coming New year! Pleasant reading.

Read more »


How to start own torrent search engine based on RuTracker?

1 year, 2 months ago
I as much as possible will try to write without "water". A minimum of the excess distracting information and verbalizations. Maximum of useful information and working code. I will not bring up a question why to someone own torrent search engine based on RuTracker. And I do not consider myself the guru of programming. We will just make this website together. Let's use Apache+PHP, MySQL and Sphinx. At once I will warn that the website will work at the minimum virtual hosting absolutely not quickly.

image

Read more »


We become professional PHP developers. Part 2: Importance of other people

1 year, 2 months ago
I bring to your attention transfer of the second part of a cycle of the articles "Becoming PHP professional".
First part. "A missing link"

And now we will be focused on system of mentors. In fact, this my personal opinion which formed for years which I spent in this sphere, but nevertheless I would advise everyone to read article and to learn how many people will agree and will not agree with me.

Read more »


Use of comet of the server for implementation of a simple chat

1 year, 2 months ago
Comet — any model of work of a web application at which permanent HTTP connection allows the Web server to send (push) given to the browser without additional request from the browser.

On the scheme the place of comets of the server in the course of work is represented.
На схеме изображено место комет сервера в процессе работы.

Read more »


Symfony2 Voters and Doctrine Filters on guards of safety

1 year, 2 months ago
Everything began when I customized a security system of one CRM. As it often happens, in it there were users with the different permission access levels to a specification (we will call them entities). They had an identical type of the main grid, customizability of access to entities was necessary. At first I thought of ACL, but …

Read more »


Performance comparison of PHP 7.0 and HHVM

1 year, 2 months ago


During quite long time about it there were no news, but, after long waiting, PHP 7 at last left on December 3, 2015. We decided to test the most popular CMS based on PHP to check as they work with PHP 7.

Read more »