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

adamkiss

#!/usr/bin/env fish

function nr -a script --description 'npm run shortcut with default script set to "start"'
    if not string length -q $script
        set script start
    end

    npm run $script
end

adamkiss

<?php

use Kirby\Cms\App;
App::plugin('adamkiss/simple-snippets', []);

if (! function_exists('s')) {
	/**
	 * Short, auto-return snippet call with support for auto-merging certain parameters
	 *
	 * @param string $snippetName