lukaskleinschmidt

Warning Make sure you have the old and new blueprint available when running this command.
Otherwise this command will wipe the currently stored content.
Always make sure to test the command first and have a backup of your content!

samzzi

function release() {
  composer_json="composer.json"

  if [[ ! -f "$composer_json" ]]; then
    echo "❌ ️Error: composer.json file not found."
    return 1
  fi

  echo "✅ ️Increment composer version"

adamkiss

SQL Optimization — Retour database, events overview

@distantnative asked me (well, anyone) to optimize a SQL query which generates an overview of Retour events.

#Programming/SQL

Original Query

with recursive dates as (
    select "2019-10-01" as date
 union all

bedeabza

function hexToHsl($hex) {
    $hex = array($hex[0].$hex[1], $hex[2].$hex[3], $hex[4].$hex[5]);
    $rgb = array_map(function($part) {
        return hexdec($part) / 255;
    }, $hex);

    $max = max($rgb);
    $min = min($rgb);

    $l = ($max + $min) / 2;