Member since 2025-12-22 09:24:20Z · 9mo ago
Total posts: 318 · Total topics: 315
A lot of work has gone into mediabot_v3 recently, and one of the most useful parts of it was not glamorous at all:
a real install test from scratch on a fresh Debian 13 system.
That kind of test is brutally honest. It does not care that the bot “work…
A new stabilization pass has just landed in mediabot_v3, and this one was not about shiny features.
It was about removing friction, tightening weak spots, and making the bot feel less like a long-running beta and more like something that can finally be released with confidence.
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…