2023
2022
MySQL 5.7 Does Not Have an Official Docker Image on ARM/M1 Mac
Here is how you can run it anyways
- Tech Article
- betterprogramming.pub
Don’t Forget Setting Database Locks on Your Orm Entities
A huge advantage of relational databases is transactions and locking. Don’t waste it by not using it
- Tech Article
- betterprogramming.pub
The “Tick” Pattern — A Solution for Temporal Problems in State Machines
How to automate workflows that wait for external and time conditions without exploding complexity
- Tech Article
- betterprogramming.pub
3 Ways To Use ElasticSearch in a Symfony Project With ApiPlatform
When your SQL Database does not cut it anymore.
- Tech Article
- betterprogramming.pub
Improve PHPUnit Performance by Parallelization Using Liuggio-fastest
Finally use your multi-core CPU to run your tests multiple times faster, even with complex test setups.
- Tech Article
- betterprogramming.pub
TypeScript NPM package quick start
Create a node project that is easily testable and maintainable with minimal setup overhead.
- Tech Article
- medium.com
Apple implemented the biggest improvement to bluetooth audio since 2009
Did you ever listen to music on bluetooth headphones and got a call? Did the quality get a lot worse? What happened to all those fancy bluetooth audio codes that every reviewer is always talking about?
- Tech Article
- medium.com
Clip - In-browser video compression
The easiest way to optimize videos. No software installation necessary.
There were multiple reasons for this project: - I figured that emscripten could theoretically be used to compile ffmpeg for the browser ~ and that someone already did that. - I sometimes send video snapshots from gameplay over Discord, and Discord has a 6mb file limit. - I was involved in some content sites that use videos and properly compressing videos for web usage has some pitfalls.
So this web application was the combination of all these factors. The idea is to just have a few dynamic presets, that properly optimize based on the source video for the best resultsso that the user doesn't need deep knowledge about codecs, bitrates, container tweaks etc.
- Web Application
- clip.marco.zone
2021
Manually implement OAuth Client functionality in Symfony
First of, use something like the KnpUOAuth2ClientBundle if it serves your need. Having documentation beats the best implementation in any case.
- Tech Article
- medium.com
Mastering Doctrine ORM relations
There are only 2 types of relations. All other types are usually bugs.
- Tech Article
- medium.com
Texel - Text element editor
A tool to easily view and edit text/translation files in your software projects.
This project was the result of the question on how to help someone change text strings in a project with the least amount of integration effort. Since everything I do, when integrating text changes, is just copying the text into translation files and committing them, I thought that building a tool that could abstract away GIT and JSON/YAML files would be a good idea.
I don't think I'll actually ever use this project like this, but I found another great use. Modern Chrome allows a web application to access an entire folder, so I implemented scanning a local project for translation files. This is actually awesome, since it is easier to edit text in tables than in JSON files. You just need a great translation extractor tool in your projects like i18next-parser.
- Web Application
- texel.marco.zone
Doctrine/Symfony centralized access control
My current best shot at implementing none annoying, fine grained and scalable access control in a symfony application with a doctrine database.
- Tech Article
- medium.com
Seamless docker dev environment on a VPS
Use cloud compute resources to improve the performance of your projects and also avoid the slow filesystem on Docker for mac.
- Tech Article
- medium.com
2020
Youtube Music fix volume ratio
Makes the YouTube music volume slider exponential so it's easier to select lower volumes.
This was a small side project where I was just annoyed that YouTube Music is unusable as a background service simply because you can't get it quiet enough.
It is technically my most successful project to date but it's also less than 10 lines of codes. Such is fait.
- Software Application
- greasyfork.org
Share an Aurora Serveless between services using CloudFormation
Securely set up RDS Aurora Serverless and use custom resources in CloudFormation to create additional databases and users across multiple stages or even serv...
- Tech Article
- marco.zone
Share an Aurora Serveless between services using CloudFormation
Securely set up RDS Aurora Serverless and use custom resources in CloudFormation to create additional databases and users across multiple stages or even serv...
- Tech Article
- marco.zone
Configure https for the official docker php apache images
Here is what to do to get quick and dirty https working.
- Tech Article
- marco.zone
Configure symfony for a serverless lambda environment in bref
A guide on how to configure everything in the full multipage symfony skeleton to run on aws lambda, with code snippets, to get you started.
- Tech Article
- marco.zone
Static resource distribution on a aws serverless multipage application
Hosting a multipage application has never been simpler but aws and serverless aren't build for that use case. But, when configured correctly, it is actually ...
- Tech Article
- marco.zone
Docker for mac uses over 100% cpu while doing nothing
I use a docker for mac which has some performance problems. But it seems the interface in the background might also have some flaws.
- Tech Article
- marco.zone
A driver to use the aws aurora serverless rds data api in the doctrine database abstraction layer.
- Software Source Code
- github.com
2018
TYPO3 Canonical-Url
Eine echte Canonical Url in TYPO3 die sich nicht durch AdWords Parameter und Ähnlichem austricksen lässt und keine Sicherheitslücken öffnet.
- Tech Article
- marco.zone
TYPO3 Css/Js-Spam verhindern
TYPO3 kombiniert normalerweise alle css/js Dateien zu einer Datei. Dies hat jedoch einen großen Hacken.
- Tech Article
- marco.zone
TYPO3 Erweiterungs Wunschliste
Eine Sammelstelle für TYPO3 Erweiterungen die ich unbedingt haben will und irgendwann vielleicht auch baue.
- Tech Article
- marco.zone
2017
Formular-Finisher zum TYPO3 Backend-Editor hinzufügen
Der umständliche und undokumentierte Weg eigene Finisher in den neuen TYPO3 8.7 Formular-Editor hinzuzufügen.
- Tech Article
- marco.zone
Composer und Bower über Docker ausführen
Composer und Bower via Docker so einrichten als wären sie nativ auf dem Mac installiert.
- Tech Article
- marco.zone
Jira Performance optimieren durch AdBlock
Jira ist langsam und, wie viele moderne Webseiten, überladen. Ich hab versucht Jira mit AdBlock etwas benutzbarer zu bekommen.
- Tech Article
- marco.zone
MacBook Pro 13" (2016) Bildschirm Rant
Das MacBook Pro hat viele schwächen. Hier ist noch eine die mich wahnsinnig macht und scheinbar niemandem auffällt.
- Tech Article
- marco.zone
2015
HTML Bilder in Responsive Websites
Einige Ansätze Bilder in Webseiten zu verwalten, die sich an die Bildschirmgröße anpassen müssen.
- Tech Article
- marco.zone
Progressiver HTML Blocksatz mit Silbentrennung
Einige Browser unterstützen Silbentrennung über CSS. Hier ein Trick für Blocksatz wenn Silbentrennung vorhanden ist.
- Tech Article
- marco.zone
Ein Blog mit Jekyll und Gulp
Beste Webentwicklungsumgebung die ich je auf die Beine gestellt hab, doch war das Einrichten (mit meinen Ansprüchen) nicht so einfach wie ich dachte.
- Tech Article
- marco.zone