vielhuber

use Illuminate\Support\Carbon;

// create
Carbon::now();
Carbon::yesterday();
Carbon::today();
Carbon::now();
Carbon::now('Europe/London');
Carbon::tomorrow();
Carbon::createFromDate($year, $month, $day, $tz);

vielhuber

show installed languages

tesseract --list-langs

input.jpg > output.txt

tesseract input.jpg output -l deu

vielhuber

• prefix query with EXPLAIN ANALYZE: EXPLAIN ANALYZE SELECT * FROM ...

• debug with https://explain.depesz.com

vielhuber

SELECT *
FROM table
WHERE
    col1 = 'foo'
    AND
    col2 = 'foo'
    AND (
      col3 = 'foo'
      OR

vielhuber

links

• overview: https://www.gruenderkueche.de/fachartikel/xrechnung-erstellen-so-funktioniert-es-diese-tools-gibt-es
• generator: https://xrechnungsgenerator.nortal.com
• validator: https://validator.invoice-portal.de
• php-library: https://github.com/horstoeko/zugferd
• php-visualizer: https://github.com/horstoeko/zugferdvisualizer

installation

vielhuber

{
    "version": "0.2.0",
    "configurations": [
        {
            "name": "Listen for Xdebug",
            "type": "php",
            "request": "launch",
            "port": 9003,
            "ignore": ["**/vendor/**/*.php"]
        }

vielhuber

installation

plain

composer require --dev phpstan/phpstan

phpstan.neon:

vielhuber

modify git message

install

• mkdir -p ~/git-template/hooks
• nano ~/git-template/hooks/prepare-commit-msg
• chmod +x ~/git-template/hooks/prepare-commit-msg
• git config --global core.hooksPath ~/git-template/hooks

uninstall

• git config --global --unset core.hooksPath

vielhuber

on every code change, don't forget to restart

• php artisan queue:restart

production (normally used with supervisor)

• php artisan queue:work --sleep=3 --tries=1 --memory=768 --timeout=10800

test queue locally

• php artisan queue:work --env=production --sleep=3 --tries=1 --memory=768 --timeout=3600
• php artisan queue:listen --env=production --sleep=3 --tries=1 --memory=768 --timeout=3600 # does not need restarts, but is less more efficient

vielhuber

prevent static classes

// bad
Example::calculate($obj)
  
// good
(new Example($obj))->calculate()