Skip to content

Instantly share code, notes, and snippets.

View ziadoz's full-sized avatar

Jamie York ziadoz

View GitHub Profile
@ziadoz
ziadoz / links.txt
Last active October 6, 2024 18:22
Postgres 17 Playground
@ziadoz
ziadoz / readme.txt
Last active September 26, 2024 15:46
PGLoader - Importing MySQL into Postgres
# 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
ziadoz / reset_macos_firewall.txt
Last active September 20, 2024 22:24
Reset macOS Sequoia Firewall
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
ziadoz / loops.js
Last active August 29, 2024 15:31
JS Loops Example (for...in, for...of, forEach(), entries(), keys(), values())
/**
* 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
ziadoz / index.blade.php
Last active August 29, 2024 14:48
Laravel Blade Props
@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
ziadoz / config.php
Created August 21, 2024 11:17
Pydantic Settings for PHP
<?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
ziadoz / MyCommand.php
Last active August 20, 2024 19:31
Laravel 11.21 Container Contextual Attributes
<?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
ziadoz / readme.txt
Created August 12, 2024 12:19
Darksiders 1 Warmastered Edition PC - Camera Speed Bug
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
ziadoz / select-options-hide.html
Last active August 6, 2024 13:40
Hide/Disable Select Options in Browsers (Safari Bug)
<!-- 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
ziadoz / date-hms.js
Created July 9, 2024 11:13
JS - Get Hours, Minutes and Seconds from Date
console.log(
new Intl.DateTimeFormat('en-GB', { hour: 'numeric', minute: 'numeric', second: 'numeric' })
.formatToParts(new Date)
.map((part) => part.value)
.join('')
);