Android: Best Way To Store Large Amount Of Sensor Datas Over Long Time

I'm fairly new to Android-Development and I got a general question about How-To: My App gets Sensor-Data from Step-Detector (Detected steps gets added up). Now I need to store thos

Solution 1:

Try using Realm noSql database for it. The point is, you can save entire database on sd card as separate file for each day and process it later. It is native and work very fast with large amount of data. You can process all your readings later on - open database, transform readings (perhaps interpolate values for older to shring data in size) and then upload it to the cloud and delete database file. But, anyways, a database is just implementation details, consider abstracting out all your operations so you can replace db later on. As far as I know, sqLite stores all tables in a single file, so you will need column for a date and all records will be stored in single table. Realm is more flexible for this task.

Solution 2:

SQL Lite can be used , it will be there as long as your application exist in the device, however if you want you can use Cloud Service, Azure provides simple and easy to use App Service , which have easy tables , in which you can directly call the APIs and internally it takes care of making connection and inserting the data into table.You can use Free Tier of App Service to test the concept.