SimpleSQL 1.0.1

SimpleSQL 1.0.1

This source release improves the safety of SQL and YAML session loading and saving for plugins that bundle SimpleSQL as a virion.

• SQL read failures and malformed rows no longer open an empty session.
• Offline YAML edits are exposed only after their SQL synchronization succeeds.
• Saves for one session are ordered, and newer edits remain dirty until saved.
• A failed save keeps the session open. If SQL still fails during shutdown, SimpleSQL attempts to write a separate .recovery.yml snapshot for manual restoration.
• Session IDs are encoded before use in YAML filenames. Ordinary player name filenames remain unchanged.
• The library now has locked PHPStan max analysis, regression scripts, CI and Dependabot configuration.

The optional third openSession() callback reports load failures. Existing two argument calls remain valid. The manifest still requires API 5.0.0 and PHP 8.1 or newer. CI analyzes the pinned Axolotl-PM 5.49.1 source. A staged SimpleEconomy PHAR containing this source and libasynql was built with DevTools and passed a console-driven SQLite save on Axolotl-PM 5.49.1. Other server releases, MySQL and connected player behavior have not been verified here.

Commit CI and tag CI passed Composer validation, PHPStan max, regression scripts and PHP lint.

For an upgrade, rebuild the consumer PHAR with the tagged SimpleSQL source and keep its SQL resources and libasynql virion. Back up the SQL database and YAML directory first. Roll back by rebuilding with the prior SimpleSQL source and restoring the matching data backup if needed. Recovery snapshots are not loaded automatically.