Letzten Herbst besuchte ich mit meinem Göttibueb die Modellbaumesse in Friedrichshafen. Er war vor allem an den Modelleisenbahnen interessiert, was mir recht ist, war ich doch als Kind und Teenager auch grosser Modelleisenbahn Fan. Auf dem Heimweg sagte er mir, dass er sich als Geburtstagsgeschenk ein Haus aus dem 3D Drucker für seine Eisenbahn wünscht. Das Thema hat mich gereizt, und so begann diese Story...
Last autumn, I visited a model building fair with my godson. He is mostly interested in model trains, which suits me well, having been a model train aficionado as a kid and teenager. On the way home, he told me that he would love to get a 3D printed house for his own model railway as his birthday present. I thought that sounds cool, and so it began...
Conference: Software Talks, St.Gallen, Switzerland
Title: Can Postgres cover your NoSQL needs?
Links: slides, examples and performance measurements
Postgres is famous for its support for SQL data. However, Postgres also has powerful capabilities to work with JSON. I will show how to leverage the various JSON functions of modern Postgres to work with your less structured data. I will also show how to use some of that functionality from within Doctrine.
Visit the git repository for example code and performance test data. I also wrote blog post about the topic on my employers web site: JSON in Postgres and Doctrine ORM support for JSON.
After 10 years working exclusively on backend applications, last year I worked on web frontends again. This prompted me to reflect on the state of the art for frontend technologies.
At Liip, I built an online questionnaire as a highly interactive web application with almost no Javascript code. All business logic is consistently in the backend.
Relational databases feature dedicated column types to efficiently work with Json. The PHP library Doctrine ORM can leverage some of those functionalities into your PHP application.
The short answer of course is "it depends". Postgres has some powerful JSON capabilities. In this article, I show how to work with JSON in Postgres and provide some measurements of the performance of those operations.
Conference: Symfony Con Vienna, Austria
Title: Can Postgres cover your NoSQL needs?
Links: slides, examples and performance measurements
Postgres is famous for its support for SQL data. However, Postgres also has powerful capabilities to work with JSON. I will show how to leverage the various JSON functions of modern Postgres to work with your less structured data. I will also show how to use some of that functionality from within Doctrine.
Visit the git repository for example code and performance test data.
Conference: Drupal Mountain Camp, Davos, Switzerland
Title: HTTP Caching with Varnish
Links: slides
Get an introduction to caching "on the edge".
With the Varnish caching proxy, you can greatly increase the speed of websites and handle a lot more load. The basics are quite simple once you understand how the cache handling in HTTP works, so we will look into that first. We then go over cache invalidation, cache tagging strategies and have a look at Edge Side Includes (ESI).
Meetup: Symfony User Group Zurich, Switzerland
Title: Symfony Messenger Demo
Links: slides | demo
I gave a demonstration of Symfony Messenger at the Symfony User Group Meetup in Zürich.