Just another tech blog

Tips for landing a new job

I guess most of us went down that road at some point and understand, that beside the diplomatic and official answer, there are plenty of reasons for leaving the current company, e.g., expectations were not met, promises were broken, no further growth for your career, supervisors, and and and ;). But this post ain’t about why I left my company or why you should leave yours. It is about how I managed to get my new job and the experience I made during that period. #1 Keep going until the end If you – for whatever reason –...

Are stored procedures faster than queries?

In some companies including leading ones stored procedures are labeled as bad practice and banned forever, in others they are praised for better performance. Let’s take a closer look into it. Caching the execution plan Let’s start from the performance perspective. Whenever you submit a query to the database system, it will need to create a query execution plan. This is an ordered set of step, which tells the database how to get your data. Every query requires a query plan before it is actually executed. Since there are different way how to get there, the DB will...

ERR_TOO_MANY_REDIRECTS by WordPress on LAMP stack with nginx/HTTPS as reverse proxy

I wanted to setup my new WordPress blog on my (new) server running on Ubuntu to have nginx/HTTPS as the reverse proxy for my Apache HTTP Webserver (LAMP stack). Although they are great materials, following the 2 tutorials of DigitalOcean gave me a hard time due to the ERR_TOO_MANY_REDIRECTS caused by WordPress: How to install WordPress with LAMP on Ubuntu Configure nginx as webserver and reverse proxy for Apache Reason for ERR_TOO_MANY_REDIRECTS Please be aware, that the ERR_TOO_MANY_REDIRECTS can have different (and !multiple!) causes. Although most of the blog articles and forum discussions, that I read during my research of...