What extension do you need in order to access a SQLite DB in an iPhone app?

Question

The problem I'm running into is that when using "MyDB.sqlite" the application seems to not read the DB correctly (stops, NOT errors, at this line according to NSLogs):

if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {

whereas if I rename the DB "MyDB.sql" (notice the lack of "ite") it will read the DB just fine. Did I import the DB incorrectly somehow? Am I using the wrong library? I did add the sqlite framework and imported it in the header file as follows:

#import <sqlite3.h>

Answer 1

It sounds like, at least in this context, the iPhone (or SQLite) only supports three character extensions on the file name. Is that a deal-breaker?

Answer 2

I'm using sqlite as extension for my db file, so there shouldn't be any problem with that. Why don't you provide more details like where you actually provide the file path. Most probably you're just missing some minor and annoying detail somewhere.