Filament Inventory

A single-user, mobile-first filament spool tracker. Vanilla PHP + SQLite + vanilla JS — no third-party code, no build step.

Requirements

• PHP 8.0+ with pdo_sqlite enabled (standard on nearly every host)
• Any web server (Apache, nginx, or php -S)
• The data/ directory must be writable by the web server

Install

Copy the whole folder to your web root and open it in a browser. On first visit you'll be asked to set the admin password (stored as a hash in data/pass.hash). The SQLite database (data/filaments.sqlite) is created automatically.

nginx users: data/.htaccess only protects the database on Apache. On nginx add:

location ^~ /autofeed/data/ { deny all; }

Features

• Inventory list is public read-only (set public_view to false in inc/config.php to require login for everything); adding, editing, and using filament require the password.
• Logins last until you actually log out. A "remember me" cookie (selector/validator, only the validator's hash is stored) re-establishes the session even after PHP's session garbage collection sweeps it — the default 24-minute idle window was why logins kept lapsing. Logging out deletes the token server-side, so a copied cookie is dead the moment you log out.
• Passkeys: sign in with a fingerprint, face, or screen lock instead of the password. Add one per device on the Keys page. Hand-rolled WebAuthn (ES256/RS256, no dependencies); attestation is intentionally not verified, since on a personal site any authenticator the owner chooses is acceptable. Passkeys are bound to the hostname they were created on, so one made at localhost will not work on the live domain — register one on each address you use. Needs HTTPS (or localhost); the Keys page says so plainly when the connection is not secure. The password always keeps working as the fallback if you lose your devices.
• Spool fields: type, color, brand, total weight, empty spool weight, cost, abrasive, high-flow, silk, matte, rainbow/multicolor, color-shifting/two-tone, transparent/clear, notes. Silk spools get a shine sweep on their swatch, rainbow spools an animated all-hue ring, two-tone spools fade between their two colors, and transparent/clear spools show an image-editor-style checkerboard through the color. Remaining filament = total − spool, reduced as you log usage. Re-weigh a spool and update its weights to reset the remaining amount.
• Color can be sampled with the phone camera (live view needs HTTPS; the "Photo" button works everywhere) — the image never leaves the phone.
• Logged usage can be corrected: every entry in the Use page's history has Edit and Delete. Deleting puts the grams back on the spool; editing can change the amount, the print-file label, or move the entry to a different spool (the old spool is refunded and the new one charged). "Show all" opens the full history to reach older mistakes, and a spool's last-used date is recomputed whenever an entry moves or disappears.
• When a deduction empties a spool, the Use page offers to delete it from the inventory, saying up front how many logged prints will go with it. The offer is re-checked against the spool's real remaining amount, so undoing the usage withdraws it.
• "Use filament": drop or pick a .gcode/.bgcode file and the grams used are read from the slicer metadata (PrusaSlicer, OrcaSlicer, Bambu Studio; Cura is estimated from meters via material density). Parsing happens in the browser — the print file is never uploaded. Manual gram entry also works.
• Adding a spool is quick: one-tap presets for the common spool amounts (1 kg / 500 g / 250 g / 100 g), and the empty-spool weight auto-fills from the most common value among the same brand's existing spools (manufacturers reuse one spool design) — a hand-typed weight is never overwritten.
• CSV export and import (Report page, login required). Export downloads the whole inventory as a spreadsheet-friendly CSV that doubles as a backup. Import accepts that same file back (rows whose id matches update the existing spool; others are added) or a CSV from elsewhere — only a type column is required, , and ; delimiters and decimal commas are handled, and a database backup is taken first.
• Email report: from the Report page, send the inventory report (spools listed lowest-first, CSV attached) one-time, or enable a daily morning email. The daily report goes out on the first page visit after the chosen hour; for exact timing point a cron job or uptime monitor at the tokenized cron.php URL shown on that page. Sending uses PHP's mail(); if your host is picky about sender domains, set mail_from in inc/config.php.
• The inventory list has a filter panel: narrow by type, manufacturer, amount left (nearly full / partly used / low), special properties, or a free-text search across color names, brands, and notes. Groups combine with AND, choices within a group with OR, and changes apply instantly.
• Dark mode follows the system preference.
• Every change (add, edit, delete, bulk edit, usage deduction, CSV import) first snapshots the database to data/backups/; the newest 10 snapshots are kept. To undo a mistake, copy the relevant backup over data/filaments.sqlite.