File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Android and the fly likes Lists inside SQLite Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Mobile » Android
Bookmark "Lists inside SQLite" Watch "Lists inside SQLite" New topic

Lists inside SQLite

Sunny Rodriguez

Joined: Jun 30, 2009
Posts: 5

I am creating an application that allows you to log the days you do a particular exercise. I am using SQLite to store each Exercise in a table that has attributes such as Sets, Reps, Weight. What I am confused about is how to store the dates. I want to store the dates so that when you click View Summary of an Exercise, you will see a list of all the days that you did the exercise and how many sets, reps, and weight. To store the dates I figured I would have to add a new column to the table using ALTER command and make the date the name of the column but then that would be inefficient.

I thought about storing objects, tables, and arrays inside of SQLite but I haven't seen any finite examples, if that. I thought about storing all the attributes inside of a custom Exercise object that would then be store in internal memory but I like the idea of a database to store the info.

What is the best way to store the dates?


After doing some research I realized I could create a new table and just make a column that stores an ID of the exercise and then another column that has the dates. Then I could just perform a SELECT to get only certain exercise.
I agree. Here's the link:
subject: Lists inside SQLite
It's not a secret anymore!