Natan Debach
@natan_debach
Computer science, second year at Reichman. Building a lab-slot scheduler because the shared spreadsheet kept breaking.
Posts
I replaced a spreadsheet and learned the spreadsheet was the easy part
Forty-one students, one shared sheet, and three weeks of finding out why nobody wanted my replacement.
Read the article →The networks lab has eleven workstations and about forty people who need them. Booking was a shared spreadsheet. Two people would write in the same cell, one of them would lose their slot, and whoever noticed last lost the argument.
I built the obvious thing: a booking page with real rows in a database, one slot per row, a unique constraint so two people cannot hold the same one.
The part that worked
The constraint. A booking is an
insertthat either succeeds or fails. There is no version where two people b…