Whether you’re new to MySQL or an experienced user, this guide will provide you with the essential commands to make your work more efficient and productive. I’ll update this command list from time to time. User Management @'%' -> external access allowed @'localhost' -> only access on the machine List users select * from…

The OpenSearch Service on AWS can be expensive, especially when dealing with large volumes of data. In this context, many businesses are looking for ways to save costs on OpenSearch while still maintaining its performance and functionality. …

Instagram supports to publish different kind of contents to a business account programmatically, but to get everything working you have to do some preperation. I focus to avoid any SDK or dependencies, simple cURL commands are enough and can be implemented in any programming language. 3 steps to get started Content publishing via the Graph…

Self-hosting Google fonts is a must nowadays due to GDPR, but self-hosting fonts and icons brings a lot of benefits to your web applications: Reuse of current HTTP connections for the same domain instead of fetching fonts from Google Versioned fonts that stay the same. Did you know that Google…

Imagine you have a legacy project with spaghetti javascript code and need to troubleshoot. You have no idea where to start other than searching your IDE for some special keywords to find the right spot. I needed to do this in an older Ext JS application. With no idea where…

In this post I will show you how you can optimize your PHP programs in terms of memory usage in the cloud. There are several ways you can control it and keep it low. Cloud computing The cloud allows you to run PHP code Serverless(cloud functions) or in Container based environments. The…

In this post I show you how to setup a web proxy with Docker in no time. But first of all we should ask ourselves why do we actually want to do that? Example code: https://github.com/stefpe/squid_proxy Why a proxy? A proxy is sitting between a client(sending a request ) and a server(responding to…

Repository for the article: https://github.com/stefpe/phpstan What is static code analysis? With static code analysis, you can check whether your code fits the defined requirements in terms of form and syntax. The check is performed without executing the program. …

Software as a service apps should store configuration values in environment variables when you rely on the twelve-factor app Saas guide. The twelve-factor rule says you should seperate config from your code, because configuration varies across environment stages: https://12factor.net/config Since nginx version 1.19 it’s possible to replace values in nginx…