PHP Classes

File: docs/UPGRADING_1.9.8.md

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   docs/UPGRADING_1.9.8.md   Download  
File: docs/UPGRADING_1.9.8.md
Role: Auxiliary data
Content type: text/markdown
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 5,057 bytes
 

Contents

Class file image Download

Upgrading to 1.9.8

Make sure you have a current backup of your database and files before upgrading.

Table of Contents

Summary of Changes

Web Interface

  • The user-facing echoarea subscription manager at `/subscriptions` now uses a more compact filter layout modeled after `/echolist`, with network filtering and an option to show only interest groups that currently have message traffic.
  • Subscribing or unsubscribing from an echoarea in `/subscriptions` now updates in place instead of reloading the page, preserving the current scroll position and active search/filter state.

Developer / Infrastructure

  • Realtime wake-up signaling now has a small transport abstraction around PostgreSQL `LISTEN/NOTIFY`. The current implementation is still PostgreSQL-only, but the direct `pg_*` calls are now concentrated in dedicated realtime classes instead of being spread across `BinkStream`, the AI bot daemon, and the admin daemon.
  • Database bootstrap now has a minimal platform abstraction for DSN construction, session initialization, and base schema selection. PostgreSQL remains the only supported backend, but connection and setup behavior is no longer hardcoded in one place.
  • `.env` may now include `DB_DRIVER=pgsql`. PostgreSQL is still the only supported value today. This setting exists to make future backend setup work easier to isolate if it is ever pursued.
  • A new developer reference document, `docs/PostgreSQLDependencies.md`, tracks intentional PostgreSQL-specific dependencies and where they currently live.
  • BinkP session logging now closes failed session rows more aggressively and retires orphaned `active` rows whose handler process has already exited, so the admin BinkP session view no longer treats dead pre-handshake sessions as long-running live connections.

Web Interface

Subscription Manager

The /subscriptions page now presents its filtering tools in a compact filter panel instead of a long row of controls and per-interest buttons.

The updated page adds:

  • a network filter for narrowing the visible echoareas by network
  • a compact interest picker instead of a button wall
  • an `Only show groups with messages` filter that limits the visible results to interest-grouped areas with message activity
  • the search and sort controls inside the same filter panel for a tighter layout
  • in-place subscribe/unsubscribe updates that do not reset the current search, filters, or scroll position

This change is user-facing only. It does not alter subscriptions, interest membership, or message access rules.

Developer / Infrastructure

Realtime Signaling Abstraction

The realtime event path now uses dedicated transport and maintenance classes instead of inlining PostgreSQL signaling details directly into each caller.

This change does not alter the current supported backend. BinktermPHP still requires PostgreSQL, and BinkStream still uses PostgreSQL notifications today.

What changed:

  • `src/Realtime/BinkStream.php` now publishes wake-up notifications through a dedicated publisher class
  • `scripts/ai_bot_daemon.php` now listens through a dedicated PostgreSQL event listener class
  • `src/Admin/AdminDaemonServer.php` now delegates `sse_events` cleanup to a maintenance service

This keeps the current PostgreSQL behavior while making future transport changes, such as Redis-backed wake-ups, easier to isolate.

Database Bootstrap Abstraction

Database bootstrap now resolves platform-specific setup behavior through dedicated classes under src/DatabasePlatform/.

Current scope:

  • DSN construction
  • session initialization
  • base schema path selection

PostgreSQL is still the only supported platform. The new DB_DRIVER setting should remain pgsql.

BinkP Session Log Cleanup

The BinkP session log now treats abnormal session termination more defensively.

What changed:

  • the inbound and outbound BinkP session wrappers now close the session log row when a PHP `Throwable` escapes the normal handshake or transfer flow
  • the admin `active` BinkP session listing now retires older `active` rows whose recorded handler PID is no longer running
  • `scripts/database_maintenance.php` now includes a stale-session cleanup pass before age-based BinkP log retention cleanup

This keeps the admin BinkP dashboard aligned with real process state when a remote peer connects, drops during handshake, and the handler process exits before the session log row was finalized.

Upgrade Instructions

From Git

git pull
php scripts/setup.php
scripts/restart_daemons.sh

Using the Installer

Download the latest installer from the BinktermPHP website and run it. The installer handles file replacement, runs setup, and restarts all daemons automatically.