I’ve been converting my sim security “cam” system from using http posts to google forms backed by a spreadsheet to a nice litlle php service writing to a mysql database. The next two interesting next steps to consider are: (1) since the detectors are LSL scripts using sensors, they have limited range and frequency… So I end up with lots of point observations of visitors without any continuity- not a problem, but sometimes I’d like to watch paths not points. So the question is should I keep this information in the database in some form or just regenerate it on the fly when I query. (2) pretty displays: tabular it trivial, but little maps and such would be cool… And not an area I know much about.