So last week I got everything to work, set the database filling and apparently it crashed at some point, because the database wasnt very full, so I slowed collectd down a bit. Then I wrote some sql code to get aggregations for the data for a period of a given length over several periods of that length.

This week, I spoke to Nathan about what he was doing, and that made me think of a couple of improvements to how the database is being run. I wrote a new insert trigger so that it will create a new table if it needs to, and then just inserts directly into the new table as opposed to starting with the first table and checking each one until it finds the one it fits..