Robert Kummer rokde

rokde / SlowQueryListeningOnLaravel4

Created February 11, 2015 14:58

Logging slow queries in Laravel environments (e.g. /app/start/[environment].php)

	/** @var \Illuminate\Log\Writer $log */
	$log = App::make('log');

	DB::listen(function ($sql, $bindings, $time) use ($log) {

	if ( ! starts_with($sql, 'select'))
	return;

	// only log long running select statements
	if ($time <= 1)

rokde / comparing-time-periods-or-date-ranges-in-sql.md

Created February 1, 2018 09:53

Comparing Time Periods or Date Ranges with SQL

TL;DR

SELECT * FROM periods
WHERE range_start <= @check_period_end
  AND range_end >= @check_period_start

The opposite:

rokde / DatePicker.vue

Last active March 13, 2018 08:35

Explanation of using v-model with two-way sync for input form controls within your own custom components.

	<template>
	<div class="date-picker">
	Month: <input type="number" ref="monthPicker" :value="value.month" @input="updateDate()"/>
	Year: <input type="number" ref="yearPicker" :value="value.year" @input="updateDate()"/>
	</div>
	</template>

	<script>
	export default {
	props: ['value'],

rokde / AppServiceProvider.php

Created December 3, 2024 09:06

Laravel AppServiceProvider

	<?php

	declare(strict_types=1);

	namespace App\Providers;

	use Illuminate\Database\Eloquent\Model;
	use Illuminate\Support\Facades\DB;
	use Illuminate\Support\Facades\URL;
	use Illuminate\Support\Facades\Vite;

rokde / composer.json

Created December 3, 2024 09:08

Laravel composer.json improved

	{
	"$schema": "https://getcomposer.org/schema.json",
	"name": "laravel/laravel",
	"type": "project",
	"description": "The skeleton application for the Laravel framework.",
	"keywords": ["laravel", "framework"],
	"license": "MIT",
	"require": {
	"php": "^8.2",
	"laravel/framework": "^11.31",