Search Results

Search found 4 results on 1 pages for 'gsiener'.

Page 1/1 | 1 

• How do I aggregate activerecord model data for a specific time period?

  - by gsiener

  I'm collecting data from a system every ~10s (this time difference varies due to communication time with networked devices). I'd like to calculate averages and sums of the stored values for this activerecord model on a daily basis. All records are stored in UTC. What's the correct way to sum and average values for, e.g., the previous day from midnight to midnight EST? I can do this in sql but don't know the "rails way" to make this calculation.

  Read the article

• What type of database schema should I use for storing and working with geolocation data?

  - by gsiener

  I'm creating an application that will store geolocation data for specific transactions. Should I store a simple lat/long or is there a more preferred standard? What datatypes should I use to allow for switching to NoSQL in the future?

  Read the article

• How can I create activerecord models that are subsets of a certain model?

  - by gsiener

  I've seen this before but can't figure out what the correct term is. Basically, I'd like to create models for a specific subset of table data. E.g. (these are not the real classes) class Person < ActiveRecord::Base class Man < Person <something here> :gender => 'male'

  Read the article

• Group mysql query by 15 min intervals

  - by gsiener

  I've got a monitoring system that is collecting data every n seconds (n ~=10 but varies). I'd like to aggregate the collected data by 15 minute intervals. Is there a way to corral the timestamp column into 15 minute chunks to allow for grouping to work?

  Read the article

1