ziadoz

// @see: https://github.com/hassanshaikley/pico-pubsub
foo = () => ('foo', 'bar');
console.log(foo()); // Returns 'bar'

ziadoz

@view-transition {
    navigation: auto;
}

::view-transition-old(*),
::view-transition-new(*) {
    animation: none;
    mix-blend-mode: normal;
}

ziadoz

<?php
use ArrayAccess;
use Countable;
use IteratorAggregate;
use Traversable;

class Items implements ArrayAccess, Countable, IteratorAggregate
{
    public function __construct(protected array $items = [])
    {

ziadoz

<?php
> \Carbon\Carbon::now()->subMinutes(60)->longAbsoluteDiffForHumans();
= "1 hour"

> \Carbon\Carbon::now()->subMinutes(1440)->longAbsoluteDiffForHumans();
= "1 day"

> \Carbon\Carbon::now()->subMinutes(1560)->longAbsoluteDiffForHumans();
= "1 day"

ziadoz

<?php
// @see: https://www.php.net/releases/8.4/en.php
// @see: https://www.php.net/manual/en/language.oop5.lazy-objects.php
// @see: https://www.youtube.com/watch?v=7J6Z0F4vItw

// A simple Foo class with a constructor, property and method...
class Foo
{
    public string $foo;
    

ziadoz

<?php

use Illuminate\Contracts\Container\Container;
use Illuminate\Contracts\Container\ContextualAttribute;
use Illuminate\Support\Facades\Route;

/** 
 * Create a new contextual attribute that grabs fields from the request POST data.
 *
 * The equivalent of doing `$request->post($key, $default)` in a controller.

ziadoz

-- Typically it's common to add timestamp columns to the end of a database table, like this:
create table links (
	id bigserial primary key,
	link text,
	created_at timestamp without time zone not null default now(),
	updated_at timestamp without time zone not null default now(),
	deleted_at timestamp without time zone null default null  
);

-- However, when new columns are added it starts to look weird

ziadoz

<?php
function mincoins(array $coins, int $target): int
{
    // Check the simplest answers first...
    if (count($coins) === 0) {
        return 0;
    }

    if (in_array($target, $coins)) {
        return 1;

ziadoz

https://www.postgresql.org/docs/current/datatype-numeric.html#DATATYPE-SERIAL
https://www.postgresql.org/docs/current/sql-createindex.html
https://www.postgresql.org/docs/current/datatype-json.html
https://www.postgresql.org/docs/current/functions-json.html
https://www.postgresql.org/docs/current/ltree.html
https://notso.boringsql.com/posts/how-not-to-change-postgresql-column-type/
https://patshaughnessy.net/2017/12/12/installing-the-postgres-ltree-extension
https://pganalyze.com/blog/5mins-postgres-17-incremental-backups
https://www.mydbops.com/blog/postgresql-17-incremental-backup-pg-basebackup-pg-combinebackup/

ziadoz

# Docker
docker run --rm -it --network="host" --add-host host.docker.internal:host-gateway dimitri/pgloader:latest pgloader --verbose --debug --client-min-messages debug --log-min-messages debug mysql://<user>:<password>@127.0.0.1:3306/dbname postgresql://<user>:<password>@127.0.0.1:5432/dbname

# Brew
# @see: https://github.com/dimitri/pgloader/issues/962
brew install pgloader
pgloader --verbose --debug --client-min-messages debug --log-min-messages debug --dynamic-space-size 262144 -v pgloader.load

# Config (pgloader.load)
LOAD DATABASE