Starship

Natan Debach

@natan_debach

Computer science, second year at Reichman. Building a lab-slot scheduler because the shared spreadsheet kept breaking.

1 post5 followers5 following

  1. 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.

    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 insert that either succeeds or fails. There is no version where two people b…

    Read the article →