Yordano Pascual Rivera yordanoweb

Handle Supabase Roles

Add admin role to user

UPDATE auth.users
SET raw_app_meta_data = raw_app_meta_data || '{"role": "admin"}'::jsonb
WHERE email = 'user@mail.com';

Fix DM Verity Error

Not for all phones, but some Redmi.

Requirements

Linux (Debian, Ubuntu, ArchLinux, etc...).
The package android-tools or Linux distribution equivalent.

Steps

Capture a Screen Region with ffmpeg

Install the package slop for calculating the rectangle.

sudo apt install slop

Store in variables the region selected with mouse

Copying Large Images (>8GB) to SD Card

This updated guide uses the pi-shrink script from GitHub instead of qemu-img for shrinking the .img. Pi-shrink intelligently compacts Raspberry Pi OS images by zeroing free space and resizing partitions/filesystems. Warning: These operations erase all data on the SD card (/dev/mmcblk0). Verify the device with lsblk first.

Prerequisites

Backup SD card data.
Download pi-shrink: git clone https://github.com/Drewsif/PiShrink.git or grab pi-shrink.sh.
Make executable: chmod +x PiShrink/pi-shrink.sh.
Have .img file ready.

FIX Warp Terminal Redirection to Browser After xdg-open Call

Warp Terminal Login Loop Fix (Linux / xdg-open)

Problem

When logging into Warp Terminal on Linux:

Username/password succeeds
Browser opens for authentication
Final redirect tries to execute via xdg-open

Add text to speech to Open WebUI

Clone the repository

https://github.com/matatonic/openedai-speech

Download voices

Download to directory voices, the language voices to use from:

NoDogSplash.conf

This is the minimal config. All other options are not required to exist at the config file

# Interface of the Raspberry OS used to serve DHCP
GatewayInterface wlan0

GatewayName NoDogSplash

NoDogSplash SystemD Service

[Unit]
Description=Nodogsplash Captive Portal Service
Documentation=https://github.com/nodogsplash/nodogsplash
After=network.target networking.service
Requires=network.target

[Service]

Enter secure password to variable in PowerShell

$plainText = [Runtime.InteropServices.Marshal]::PtrToStringAuto([Runtime.InteropServices.Marshal]::SecureStringToBSTR($(Read-Host -AsSecureString)))

	const https = require('https');

	const SYMBOL = process.argv[2] \|\| 'SPX';

	const currentYear = new Date().getFullYear();
	const currentMonth = (new Date().getMonth() + 1).toString().padStart(2, '0');
	const currentDay = new Date().getDate().toString().padStart(2, '0');

	const DATA_URL = `https://www.barchart.com/proxies/core-api/v1/options/get?symbols=%24${SYMBOL}&raw=1&fields=symbol%2CstrikePrice%2CoptionType%2CbaseDailyLastPrice%2CbaseLastPrice%2CdailyGamma%2Cgamma%2Cdelta%2CdailyDelta%2CdailyOpenInterest%2CopenInterest%2CdailyVolume%2Cvolume%2CdaysToExpiration%2CexpirationDate%2CaverageVolatility&expirations=${currentYear}-${currentMonth}-${currentDay}&groupBy=strikePrice&le(nearestToLast,40)`;