vendredi 20 février 2015

how to store Android database with variable number of attributes per row

For my Android app, I want to save data using sqlite with this format:


name, date, attr1, attr2, attr3,...


These are the requirements:



  1. each date can only contain each name once

  2. there can be a variable number of attributes(numbers) for each name

  3. each specific name has the same number of attributes


The app will be used to track events throughout the day. Events can have zero or more numeric properties.


The questions are: is sqlite the best way to store things here? If so how do I design my database? What other ways are there to store this kind of data?


Aucun commentaire:

Enregistrer un commentaire