title: How to balance out row mode and column mode in cygnus?
body: <p>I have a weather-station that transmits data each hour. During that hour it makes four recordings (one every 15 minutes). In my current situation I am using <code>attr_persistence=row</code> to store data in my MySql database. </p>
  
  <p>With row mode I get the default generated columns: </p>
  
  <pre><code>recvTimeTs | recvTime | entityId | entityType | attrName | attrType | attrValue | attrMd
  </code></pre>
  
  <p>But my weather station sends me the following data:</p>
  
  <pre><code> |   attrName    | attrValue
  
     timeRecorded   14:30:0,22.5.2015
     measurement1   18.799
     measurement2   94.0
     measurement3   1.19
  </code></pre>
  
  <p>These attrValue are represented in the database as string. </p>
  
  <p>Is there a way to leave the three measurements in row mode and switch the timeRecorded to column mode? And if not, then what is my alternative?</p>
  
  <p>The point of all this is to query the time recorded value, but I cannot query date as long as it is string.</p>
  
  <p>As a side note: having the weather station send the data as soon as it is recorded (every 15 minutes) is out of the question, firstly because I need to conserve battery power and more importantly because in the case of a problem with the post, it will send all of the recordings at once. </p>
  
  <p>So if an entire day went without sending any data, the weather station will send all 24*4 readings at once...</p>