JoeIndex
A catalogue of household items on four levels, home, space, container, item: to know where everything is and who you lent it to.
The problem
Household things get lost in two ways: you forget which cupboard you put them in, or you lent them and forget to whom. A spreadsheet cannot handle the hierarchy, and inventory apps are built for warehouses.
JoeIndex is made for home use: a few fixed levels, instant search and a record of loans.
How it works
Structure
A hierarchy of nodes with free key-value attributes on items and tags for search. Every space or container can have a photo or a floor plan, with markers showing where each element sits.
Usage flow
You enter a home and go down through rooms and furniture to the item, or search directly by name, attribute, tag or open loan. An item can be marked as lent to someone, with a due date and history.
Technical choices
Everything is rendered server-side in JoeCMS templates, and JavaScript only shows and hides; writes go through JSON services and every change refreshes the cache. Login and signup are the CMS ones, with the project's look.
Known limits
It is in the design phase: the clickable prototype and the page scaffolding exist, while saving, the floor plan with draggable markers and full search are still to be written.
Numbers
| Hierarchy levels | 4 |
|---|---|
| Planned tables | 5 |
Stack
- PHP 8
- MySQL
- JoeCMS
- jQuery