@distantnative asked me (well, anyone) to optimize a SQL query which generates an overview of Retour events.
#Programming/SQL
with recursive dates as (
select "2019-10-01" as date
union all| 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; |
@distantnative asked me (well, anyone) to optimize a SQL query which generates an overview of Retour events.
#Programming/SQL
with recursive dates as (
select "2019-10-01" as date
union all| 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" |
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!
| # =========================================== | |
| # ZSH Hacks - Dreams of Code | |
| # =========================================== | |
| # Add these to your .zshrc file | |
| # =========================================== | |
| # ------------------------------------------- | |
| # 1. Edit Command Buffer | |
| # ------------------------------------------- | |
| # Open the current command in your $EDITOR (e.g., neovim) |