Comet Corgi

Clog 1.0 adds account administration and seeds the cave inventory. It upgrades the SQLite schema from version 2 to version 4 in one install run. Clog remains an Elephentity-based PHP application with SQLite storage.

What's new

• User management: administrators can add users, reset passwords and delete users from the new Users page (/users), reachable via Manage users in the account menu. Resetting a password or deleting a user signs them out of every session. Administrators can't reset or delete their own account, and nobody becomes an administrator automatically.
• Cave inventory seed: a one-off migration adds the stock photographed in the cave on 2026-09-28: 15 items and 20 units at location 2, dated 2026-09-28. If an item with the same barcode already exists, the units are added to it.

Breaking change

install upgrades storage to schema version 4:

• Version 3 adds an admin flag and a session version to accounts. Existing accounts and sessions are unchanged.
• Version 4 adds the cave seed. Databases without location 2, including fresh installs, gain no stock.

Earlier releases refuse a version 4 database, so keep the pre-upgrade backup to roll back.

Download and update

Use clog-standalone.tar.gz from this release. It includes compiled frontend assets, generated application code and locked production PHP dependencies.

The host requires PHP 8.3 or newer, PDO SQLite, mbstring and a web server. Follow the hosting guide:

1. Stop the PHP-FPM pool.
2. Back up the database.
3. Replace the application files.
4. Run php standalone/cli.php install.
5. Restart PHP-FPM.

Then grant the first administrator with php standalone/cli.php user:admin <username>.

Validation

Generated-code and GraphQL checks, frontend checks and production build, backend and schema-upgrade tests, browser regression tests, and production archive verification passed for the release commit.

Full changelog: 0.2...1.0