EcoWatch

EcoWatch is a lightweight platform for logging environmental observations and incident reports from the field. Server-rendered PHP and MySQL keep it deployable on minimal hosting, and every entry is stored with location and timestamp metadata so submissions can be reviewed and filtered on a dashboard. Tailwind CSS keeps the interface responsive and usable on the phones people carry into the field.
Why server-rendered PHP + MySQL?
The platform is deliberately lightweight: server-rendered PHP deploys on standard hosting, and a normalized MySQL schema keeps reports queryable as the dataset grows without adding frontend infrastructure.
Why Tailwind CSS for the interface?
Tailwind keeps the phone-first, field-friendly UI consistent and fast to iterate on without a heavier frontend build toolchain.
Index the columns you actually filter on
Adding indexes on date and location as reports accumulated kept dashboard queries fast without application changes.
Field forms need tolerant validation
Reports entered from a phone need forgiving input handling, clear required-field errors, and sensible defaults for location and timestamp.