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

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.