of expertise

in software


Latest news

We wish you a pleasant reading

Viewing posts for the category Web

Postgres crosstab benchmark

Paweł Drozd

For the specific case described in the previous article, we did some comparison tests to check if we have chosen really the best solution. We had a database of rare type (most of the entries for given periods had no values) and for each query about products (usually 100 rows per query) we need to add a different count of additional columns, which were a pivot from a given row relation to anothe...

Postgres optimisation with crosstab

Paweł Drozd

One of the most interesting projects realised in the last year by our Web team was creating a service to analyze our client’s trends and product sales forecasts. They were supposed to be generated from considerable historical sales data with a group of defined indicators taken into account.

UA PyCon 2017, Lviv

Michał Zyndul

PyCon Ukraine is an independent, community-run, community-controlled and not-for-profit conference dedicated to the Python programming language, Python applications, toolkits and frameworks and other "related" technologies — databases, GIS, high-load systems. It also features the place for socialization of the Ukrainian Python users. It is organised by the Kyiv Python User Group, Lviv Python Us...