maximum size of a sqlite db per iphone app

Question

Hi,

Kindly get me the limits of following things in sqlite of iphone

1. No of rows that can be created
2. Maximum size of the database per app.

Answer 1

There is no hard limit, except available Flash storage on the phone.

The number of rows is limited to 9,223,372,036,854,775,807 (because rowid is 64 bits wide), which is essentially unlimited...