Member since 2025-12-22 09:24:20Z · 3mo ago
Total posts: 26 · Total topics: 24
A new cleanup pass has just landed in mediabot_v3, this time focused on URL title handling.
The goal was not to add flashy features. The goal was to make link detection and title extraction more reliable, more consistent, and far less annoying to debug.
This round of work …
Snape didn’t teach potions by calling a house elf to do the brewing for him. Similarly, asking MariaDB to hash your passwords for you when you can perfectly well do it in Perl — with the same algorithm, without the round-trip — is an unnecessary dependency. Class is in session.
Every time a user joined a channel, this appeared in the logs:
[DEBUG1] userOnJoin() SQL Error: Unknown column 'id_user_level' in 'SELECT'
Query: SELECT id_channel, notice, id_user_level FROM CHANNEL WHERE name = ?
id_user_level has never existed in the…
A new cleanup pass has just been completed on mediabot_v3, with a focus on reliability and consistency rather than new features.
This round of work mainly addressed command management …
“CONSTANT VIGILANCE!” — Mad-Eye Moody, probably staring at a DBI statement handle that was never closed.
The previous audit session fixed the obvious statement handle leaks. This one went deeper — into the nested my $sth shadows, the early `…
The database driver was migrated from the legacy DBD::mysql to DBD::MariaDB throughout the entire codebase.
All DSN strings were updated from DBI:mysql: to DBI:MariaDB:, with host forced to 127.0.0.1 (MariaDB refuses port-based connections when `localho…
A new cleanup and hardening pass just landed in mediabot_v3.
Commit:
⚡ Stupefy fuzzy matches: unified hostmask magic and taught Mediabot stricter SQL spells
This round was focused on reliability rather than flashy features.
Just pushed a small cleanup commit on mediabot_v3:
🪄 Mischief managed: banished stray SELECT * queries and taught Mediabot cleaner SQL spells
This pass removes a bunch of leftover SELECT * queries and replaces them with explicit column lists where it made sense. The goal is simple: cl…
This session tackled one of the oldest forms of technical debt in the codebase: implicit SQL JOINs. Since Mediabot’s origins in 2007, many queries were written in the traditional comma-separated FROM A, B WHERE A.id = B.id style. Modern SQL has preferred explicit JOIN ... ON synta…
This session focused on a methodical bottom-up audit of all 32 Perl modules in the stack. No new features — just making the existing code more correct, more defensive, and less likely to silently misbehave under load or after a connection drop.
Three distinct categories of issues w…