mysql Find JSON element in MySQL MySQL isn't really build for searching through JSON data. PostgreSQL seems to be way better in this regard. Nether the less it is possible to search since MySQL 5.7.To do so
vue.js Send form data with axios (Vue.js) Sending JSON is the default for axios and doesn't need to be mentioned. When I've implemented a JWT login (which needed form data to be send), I thought it will just need a
DateTime ParamConverter in Symfony controller Param converters are a very useful feature in Symfony when working with controllers. The default setup does not support dates to be converted. But Sensio does.By installing the sensio/framework-extra-bundle with composer
php Order values in German alphabetical order with PHP Order numerical values or things like dates is no problem with PHP. Even ordering by alphabet isn't that big of a deal. But when you use another language then English, things get interesting.
php Force composer to use specific PHP version Sometimes you have a different version of PHP installed on your machine or setup as on the live server. To prevent the installation of packages which won't be compatible on the live server,
vue.js Using Vue.js template delimiters in twig When using Vue.js and rendering templates in twig you're running into the issue that both use the same delimiter. Luckily you can define the symbols which are used as delimiters:new Vue(
javascript Improve page loading performance when using jQuery For the first version of projects I usually use a CMS with a theme. You get most of the content very fast and are still able to build a great API in the
php Get Monday of week with DateTime Working with calendars in PHP offers interesting problems. One of them I stumbled upon was finding the Monday of a specific week as a DateTime object. There are multiple ways, especially with adding
json Validate JSON Schema array or object Somethings a JSON response contains attributes which (depending on the resource) might be ether and object or an array. When writing a JSON schema, you usually use just one type. But there is
doctrine Flush entity manager on object when many objects are in use When flushing an entity manager in Doctrine, there are two ways to do it. Just flush one element or all objects that entity manager manages.Usually there is not really a difference in
git Changing git commit message after push You know the feeling when you just pushed a commit to the remote and realize you've got a typo or some information missing in your commit message? There is a fix for that.
contao Contao Login Case-Insensitive Usually the login in Contao is case-sensitive. But especially when using the email address of users as there username for the login this doesn't make sense. From a technical perspective it's understandable. But
node Promises with loops in Node JS Running all actions asynchronously by default is one of nodes greatest strengths. Waiting for an action to finish is very easy with promises. But how do you wait for multiple promises which might
quote Quote "Most organizations unintentionally create systems that require extraordinary people to deliver ordinary results." - Dantar OosterwalSad but very true. I see this quite often. People trying to solve problems with specific new rules
mysql Convert DateTime to different timezone When starting a new project, usually you don't directly start a worldwide service. Because of this most of the time you don't directly start with DateTime conversions as it's just more effort without
mysql Search in Doctrine JSON Type I'm working on an API project at the moment. The API is build with a simple Symfony / MySQL (through Doctrine) stack. One of the requirements added was a search function. Previously this wasn't
ssh Upload file via ssh connection One common thing you have to do when doing Sysops, is uploading or downloading files. Most times you've got a SFTP connection to do so, but often times that's not possible and you
learning My Top 10 Books Books jumpstarted my career as a freelancer and an entrepreneur. They are one of the biggest contributors to my wellbeing and personal and business success. A few of them are so simple in
git Remove file from git history Switching from Bitbucket to Github had one hickup I didn't expect. On Github the maximal file size is 100MB. On Bitbucket it's higher and I had a video with over 345MB in my
php Symfony http basic auth for debugging on live server When deploying a Symfony application you usually remove the dev environment for security reasons. Which of course makes it more difficult to debug the system if there are errors occurring. An easy solution
console zsh agnoster theme without hostname I really like the agnoster theme for my terminal. But the hostname is just to long and not really useful on your local machine. That's why I searched for a way to remove
contao Contao changelanguage on root level When using multiple languages with Contao on one domain you always define one fallback language which is used when you visit the website through the root url. If you've implemented a language switch
quote Love of code Software developers need to stop loving the code they create and start loving the value that their code delivers - Jerónimo PalaciosA quote I came across that has a really good point.
video HTML Video Background Rendering There are nice tools to generate all formats you need for a background video. The best I found is ffmpeg. With the following commands you can create a webm and ogv format from
console Create folders from text file Did you ever had the case that you wanted to create a lot of folders but didn't want to do this by hand? There is a simple command to create a list of