྅༻ Ǭɀħ ༄༆ཉ ozh

=== YOURLS SQL Queries Benchmark ===
Date: 2026-02-19 22:25:26
Cache plugin: DISABLED
Iterations per query: 10
========================================

--- OPTIONS TABLE QUERIES ---
SELECT all options (WHERE 1=1)                               | Avg:   1.06ms | Min:   0.94ms | Max:   1.71ms
SELECT single option (LIMIT 1)                               | Avg:   0.97ms | Min:   0.86ms | Max:   1.15ms

./admin/index.php:304:$url_results = yourls_get_db('read-admin_index')->fetchObjects( "SELECT * FROM `$table_url` WHERE 1=1 {$where['sql']} ORDER BY `$sort_by` $sort_order LIMIT $offset, $perpage;", $where['binds'] );
./includes/Database/Options.php:46:$sql = "SELECT option_name, option_value FROM $table WHERE 1=1";
./includes/Database/Options.php:105:$sql = "SELECT option_value FROM $table WHERE option_name = :option_name LIMIT 1";
./includes/Database/Options.php:164:$sql  = "UPDATE $table SET option_value = :value WHERE option_name = :name";
./includes/Database/Options.php:209:$sql  = "INSERT INTO $table (option_name, option_value) VALUES (:name, :value)";
./includes/Database/Options.php:240:$sql = "DELETE FROM $table WHERE option_name = :name";
./includes/functions-shorturls.php:259:$delete = $ydb->fetchAffected("DELETE FROM `$table` WHERE `keyword` = :keyword", array('keyword' => $keyword));
./includes/functions-shorturls.php:289:$insert = $ydb->fetchAffected("INSERT INTO `$table` (`keyword`, `url`

In about:config turn toolkit.legacyUserProfileCustomizations.stylesheets to true
Open folder %APPDATA%\Mozilla\Firefox\Profiles\, find one or more folders and go to the folder that has a lot of other folders.
Create a new folder named chrome and in that folder create file userChrome.css

.tab-audio-button {
    pointer-events: none !important;
}

$maintenance_start;
$ydb;
$yourls_actions;
$yourls_allowedentitynames;
$yourls_allowedprotocols;
$yourls_filters;
$yourls_l10n;
$yourls_locale;
$yourls_locale_formats;

Master/Slave DB Setup

POC plugin: shows how a YOURLS instance using a Master/Slave DB setup would work.

Requirements:

a Master (write) / Slave (read) DB setup, obviously.
YOURLS 1.10.3 and above

Installation

Factory reset : plug the device, not the RJ45, push pin into reset hole for 5 secs. LED goes flashing green - once solid red, device is ready to configure. Unplug/plug back.
With phone : connect to Wifi broadcasted by the device (TP_Link_Extender_something)
Open http://tplinkrepeater.net/ (be sure to deactivate your custom DNS on phone)
Connect : admin/admin
Create new admin user
Change mode : "mode" icon in the top right - chose AP, apply. The LED goes flashing. Plug RJ45.
Open http://<ip of device>, connect -- NOT HTTPS !
Network : disable DHCP
Wifi, Wifi Param : copy SSID & password of your wifi network
Wifi, WPS : deactivate

Export all databases except #mysql50#mysql-8.4, information_schema, mysql, performance_schema and phpmyadmin :

 for DB in $(mysql -u root -e "SHOW DATABASES;" | grep -Ev "mysql|phpmy|schema|Database"); do echo "DB : $DB"; mysqldump -u root --skip-lock-tables --databases $DB > db_${DB}.sql; done

get list of default packages

In https://downloads.raspberrypi.org/raspios_arm64/images/ go to dir matching your setup and download the .info (eg : https://downloads.raspberrypi.org/raspios_arm64/images/raspios_arm64-2025-05-13/2025-05-13-raspios-bookworm-arm64.info)

Remove the first lines so all you have is a list of packages, and :

cat 2025-05-13-raspios-bookworm-arm64.info | cut -d' ' -f3 | sort > ~/initial_paquets.txt

This will be the sorted default package list.

  $('body').find('a').each(function() {
    var href=$(this).attr('onclick');
    if(href) {
      href=href.replace("location.href='", '').replace(/'$/g, '');
      $(this).attr('href',href);
    }

Bookmarklet with https://mrcoles.com/bookmarklet/ : (include jQuery)

	<html>
	<style>
	html {
	background-color:yellow;
	}

	body {
	margin:0;
	display:grid;
	place-items:center;