Nov 20Hacking Streamlit — ReviewA hacker is a person skilled in information technology who uses their technical knowledge to achieve a goal or overcome an obstacle, within a computerized system by non-standard means. That quote comes from Wikipedia and that is a very politically correct expression. …Streamlit8 min readStreamlit8 min read
Published in500 Internal server error·May 5, 2021MySQL + SSL + DoctrineEnabling and enforcing SSL connection on MySQL is easy: Just generate the certificates and configure the server to require secure transport. And it’s even easier on the Azure Database for MySQL. Just go to the Azure portal and enable “Enforce SSL connection” in the “Connection security” of the database server…MySQL8 min readMySQL8 min read
Published in500 Internal server error·Apr 23, 2021Automating Self-Hosted Pipelines — Part 2In the first part of the article, I described how I automate the worker virtual machine setup using a Bash script. Now I’ll describe how to automate that Bash script using Azure Pipelines. Having gone through the first part of the journey, I now have a Bash script which takes…Azure Devops9 min readAzure Devops9 min read
Published in500 Internal server error·Apr 18, 2021Automating Self-Hosted Pipelines — Part 1As part of our movement away from Travis CI to Azure Pipelines, I came across a repository which needs to run docker commands with swap limiting capabilities. It is included in our application which runs docker containers and is in fact an important feature enabling the application developer to specify…Azure8 min readAzure8 min read
Published in500 Internal server error·Feb 16, 2021Kubernetes PreStop Hook ReflectionsI have an application which runs as a Kubernetes job. The application is implemented as a PHP Symfony console command, which is specified in the Dockerfile entrypoint: FROM php:7.4-cli ENV COMPOSER_ALLOW_SUPERUSER 1 WORKDIR /code RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin/ --filename=composer COPY . . RUN composer install $COMPOSER_FLAGS …Kubernetes5 min readKubernetes5 min read
Feb 3, 2021Flee from TravisTravis CI became a huge PITA last year. Basically, it randomly fails for hours or sometimes days. There are no status updates, no communication from support, etc. This is for another post. Yesterday this hit me on a hugely legacy app, which has a pipeline split in 7 stages of…Ci Cd Pipeline5 min readCi Cd Pipeline5 min read
Jan 13, 2021Pagination testing with Guzzle MocksHaving a lot of microservices means that writing a service client become a daily routine for me. Writing a client for a REST API service is usually nothing too difficult. I strongly favor this over just ad-hoc calling some endpoints via Curl or Guzzle. The client can handle all error…PHP3 min readPHP3 min read
Dec 9, 2020PHPStan with DoctrineRecently PHPStorm 2020.3 was released with first class PHPStan support. Eager to try it I enabled it for a current project. The project is a bit of a pickle because it was put on hold a year ago. When resumed we had to start with rewriting half of the code…Phpstorm3 min readPhpstorm3 min read
Nov 30, 2020Running Composer update on Ancient codePHP 8.0 was recently released. At the same time, I’m still occasionally working in an archeological dig on a hugely old PHP application. It’s so hugely old that it runs on PHP 5.6 only and depends on a framework which depends on Symfony 2.8 (that’s why it runs on PHP…Composer3 min readComposer3 min read
Published in500 Internal server error·Sep 27, 2018Testing the untestableAn important part of Keboola Connection are Extractors — especially Database Extractors. These components load data from different (SQL) databases and import them into Keboola Connection. They are in principle very simple — they execute an SQL query and export the result into a CSV file. As with all simple…Keboola13 min readKeboola13 min read
