packaging(pie): submit php-firebird + pdo-fbird to Packagist for PIE discovery

[satwareAG-ironMike]

Context

PECL is deprecated. PIE (PHP Installer for Extensions) replaces it, using Packagist for package discovery. Unlike PECL, Packagist submission is instant — no account approval queue, no identity verification, no SSH keys.

Once composer.json has the php-ext section (issue #484) and the pdo_fbird/composer.json exists (issue #509), both packages can be submitted to Packagist. Users then install with:

pie install satwareag/php-firebird    # procedural + OOP API
pie install satwareag/pdo-fbird       # PDO driver (separate package, see #509)

Acceptance Criteria

• Prerequisite: Issue packaging(pie): add php-ext section to composer.json for PIE compatibility #484 is complete (composer.json has php-ext section, committed to satware-main)
• Prerequisite: Issue packaging(pie): create pdo_fbird/composer.json for split PIE package satwareag/pdo-fbird #509 is complete (pdo_fbird/composer.json exists)
• Prerequisite: Issue ci(pie): extend split-stubs.yml to also split pdo_fbird/ to satwareAG/pdo-fbird repo #510 is complete (split-stubs.yml creates satwareAG/pdo-fbird repo)
• satwareag/php-firebird submitted to Packagist at https://packagist.org/packages/submit
  • Repository URL: https://github.com/satwareAG/php-firebird
  • Packagist detects "type": "php-ext" and lists it as an extension
  • Package appears at https://packagist.org/packages/satwareag/php-firebird
• satwareag/pdo-fbird submitted to Packagist
  • Repository URL: https://github.com/satwareAG/pdo-fbird (split repo from ci(pie): extend split-stubs.yml to also split pdo_fbird/ to satwareAG/pdo-fbird repo #510)
  • Package appears at https://packagist.org/packages/satwareag/pdo-fbird
• Packagist webhook configured for auto-update on tag push (both repos)
  • GitHub repo Settings → Webhooks → Add webhook
  • Payload URL: https://packagist.org/api/github
  • Content type: application/json
  • Secret: Packagist API token (from https://packagist.org/profile)
• Verify: pie install satwareag/php-firebird works on a clean machine after tag push
• Verify: pie install satwareag/pdo-fbird works on a clean machine after tag push
• Document the Packagist package URLs in docs/packaging/INSTALL-PIE.md

Dependencies

• packaging(pie): add php-ext section to composer.json for PIE compatibility #484 (php-ext section in composer.json) — must be done first
• packaging(pie): create pdo_fbird/composer.json for split PIE package satwareag/pdo-fbird #509 (pdo_fbird/composer.json) — must be done first for the PDO package
• ci(pie): extend split-stubs.yml to also split pdo_fbird/ to satwareAG/pdo-fbird repo #510 (split-stubs.yml extension) — creates the satwareAG/pdo-fbird repo on GitHub

Suggested Test Plan

1. After packaging(pie): add php-ext section to composer.json for PIE compatibility #484 is committed and pushed, go to https://packagist.org/packages/submit
2. Enter https://github.com/satwareAG/php-firebird → Click "Check" → Submit
3. Verify: https://packagist.org/packages/satwareag/php-firebird shows the package
4. On a clean machine with PHP 8.4: pie install satwareag/php-firebird
5. Verify php -m | grep firebird — extension loaded
6. After packaging(pie): create pdo_fbird/composer.json for split PIE package satwareag/pdo-fbird #509 + ci(pie): extend split-stubs.yml to also split pdo_fbird/ to satwareAG/pdo-fbird repo #510, repeat steps 1-4 for satwareag/pdo-fbird
7. Verify php -m | grep pdo_fbird — PDO driver loaded

Reference

• PIE install docs: https://github.com/php/pie/blob/1.5.x/docs/usage.md
• Packagist submission: https://packagist.org/packages/submit
• Packagist GitHub webhook setup: https://packagist.org/about#how-to-update-packages

[satwareAG-ironMike]

Status Update

Completed

• Both packages registered on Packagist: php-firebird, pdo-fbird
• All 3 prerequisites met (packaging(pie): add php-ext section to composer.json for PIE compatibility #484 php-ext composer.json, packaging(pie): create pdo_fbird/composer.json for split PIE package satwareag/pdo-fbird #509 pdo_fbird/composer.json, ci(pie): extend split-stubs.yml to also split pdo_fbird/ to satwareAG/pdo-fbird repo #510 split-stubs workflow)
• Broken webhooks deleted (were returning 403 "Invalid github signature" on every push)
• Packagist API update step added to publish-release.yml in docs(pie): INSTALL-PIE.md + Packagist API update in publish-release #562 (replaces webhooks with direct API calls)
• docs/packaging/INSTALL-PIE.md written in docs(pie): INSTALL-PIE.md + Packagist API update in publish-release #562

Pending (after #562 merges)

1. Repo admin: Set PACKAGIST_API_TOKEN GitHub secret from https://packagist.org/profile
2. Manual sync: Visit both Packagist package pages and click "Update" to pull v13.0.2
3. Verify: pie install satwareag/php-firebird + pie install satwareag/pdo-fbird on clean machine

Why v13.0.1/v13.0.2 are missing from Packagist

The GitHub webhooks were created with an incorrect secret (doesn't match the Packagist API token). Every webhook delivery returned 403 "Invalid github signature". The webhook message itself says: "Delete this webhook and recreate it using the manual account sync trigger."

Instead of recreating webhooks, PR #562 adds a direct API call to packagist.org/api/update-package after each release. This is more reliable because:

• No signature verification needed
• Runs only on tag pushes (not every push)
• Logged in the release workflow (visible in Actions logs)