Database Storage iPhone Problem

[Mystery]

Hi, I am new to the forum and very new to iPhone development as well. My knowledge is form reading Beginning iPhone development by Apress.

What I am trying to do, is i want a database that has all the different car models and their manufacturers MPG (doesn't change). What i want the program to be able to do is for the user to select the car model, and then the program will understand what the user selected and output the proper MPG for the car.

I am also looking for another database that I will be able to write to. This database will hold a lot of values and will constantly be added to, however there is no specified length.

What would be the best way to do these two different databases? All help is appreciated.

[DeeJay_CRO]

Originally Posted by Mystery

Hi, I am new to the forum and very new to iPhone development as well. My knowledge is form reading Beginning iPhone development by Apress.

What I am trying to do, is i want a database that has all the different car models and their manufacturers MPG (doesn't change). What i want the program to be able to do is for the user to select the car model, and then the program will understand what the user selected and output the proper MPG for the car.

I am also looking for another database that I will be able to write to. This database will hold a lot of values and will constantly be added to, however there is no specified length.

What would be the best way to do these two different databases? All help is appreciated.

I do not understand why two databases? Shouldn't be enough only one? With several tables, if needed...

[dany_dev]

SQLite or maybe just xml if the data is "static" and user should not change it......

[Mystery]

Originally Posted by DeeJay_CRO

I do not understand why two databases? Shouldn't be enough only one? With several tables, if needed...

These two are completely separate. One database is just going to be read from (static) which gives the manufacturer's MPG of the car. Another one is recording start time/end time, velocity, acceleration of the car. This will be recorded for each time the user takes a trip.

I was looking into property lists and iphone core data. Would the property list be good for a "static" database and the iphone core data for the other database?

[dany_dev]

Originally Posted by Mystery

These two are completely separate. One database is just going to be read from (static) which gives the manufacturer's MPG of the car. Another one is recording start time/end time, velocity, acceleration of the car. This will be recorded for each time the user takes a trip.

I was looking into property lists and iphone core data. Would the property list be good for a "static" database and the iphone core data for the other database?

as said, you can use plist or xml or json, but you should prefer SQLite or Core Data

Core Data Tutorial: Getting Started | Ray Wenderlich

iPhone SDK Tutorial: Reading data from a SQLite Database | dBlog.com.au