Pular para o conteúdo
#0507
ExecSqlite

The field trip's data sheet is a URL on thirty phones

Biology class, a creek, thirty students, thirty phones. The teacher wrote a twelve-line exec script the night before: it reads site, temp, ph, and student from metadata.query, inserts a row into /hoody/databases/readings.db, and returns a small HTML form for the next reading. Its URL is a QR code taped to the clipboard.

Students scan, fill in, tap submit. Every reading lands in the class database on the container, timestamped.

Back in the classroom the projector opens the sqlite URL with a base64-encoded SELECT site, avg(ph) in the query string, and the chart of the whole creek is on the wall before the bus is parked.

No app store, no accounts, no thirty spreadsheets to merge. The phones needed a browser and a camera.

The lab notebook was a URL, and thirty phones wrote to it at once.