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

ziadoz

Disable the firewall:
/usr/libexec/ApplicationFirewall/socketfilterfw --setglobalstate off

Remove the firewall config (**doesn't work due to permissions**):
sudo rm /usr/libexec/ApplicationFirewall/com.apple.alf.plist

Or, backup the firewall config (**doesn't work due to permissions**):
sudo mv /usr/libexec/ApplicationFirewall/com.apple.alf.plist /usr/libexec/ApplicationFirewall/com.apple.alf.plist.bak

Enable the firewall:

ziadoz

/**
 * Array Looping
 */
const arr = ['foo'];

// A for...in loop will return the key...
// @see: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/for...in
for (const key in arr) {
    console.log(key);
}

ziadoz

@php
$attr3 = 'baz';
$attr4 = 99_999;
$attr5 = new stdClass;
$attrWtf = 'wtf';
@endphp

<x-my-component
    attr1="foo"           {{-- Component receives string --}}
    attr2="{{ 'bar' }}"   {{-- Component receives string --}}

ziadoz

<?php
// @see: https://docs.pydantic.dev/latest/concepts/pydantic_settings/#usage

final readonly class DatabaseConfig
{
	#[Concat(
		#[Env('DB_HOST')],
		#[Str('://')],
		#[Env('DB_USER')],
		#[Str('@')],

ziadoz

<?php
/*
Contextual attributes were implementated by @innocenzi and @ollieread:

- https://github.com/laravel/framework/pull/51934
- https://github.com/laravel/framework/pull/52428

I added contextual attributes for the core drivers:

- https://github.com/laravel/framework/pull/52265

ziadoz

The in-game camera speed when using a controller is really slow.


The issue appears to be caused by Steam Input:

Steam > Settings > Controller > Disable Enable Steam Input for Switch Pro controllers


You'll know when the change has worked because the camera speed will be a lot faster, and also controller button icons in the user interface will be grey/generic rather than Xbox coloured.

ziadoz

<!-- Most browsers support "display: none;" on select options to hide them. -->
<!-- However, Safari doesn't support this, and will still display the option. -->
<!-- The solution is to "display: none;" and disable the option. -->
<!-- The option will be hidden in most browsers, but still disabled in Safari. -->

<select>
    <option></option>
    <option value="foo">Foo</option>
    <option value="bar">Bar</option>
    <option value="baz">Baz</option>

ziadoz

console.log(
    new Intl.DateTimeFormat('en-GB', { hour: 'numeric', minute: 'numeric', second: 'numeric' })
        .formatToParts(new Date)
        .map((part) => part.value)
        .join('')
);