How should I specify the path for an sqlite db in an iPhone project?

After adding it as a resource, the database file itself is in the project root.

I’ve only been able to open it by specifying the full path as OS X sees it, i.e., “/Users/Louis/Documents/Test Project/test.db”.

  • TTT attributed Label Multi- colored Font help
  • Swift can't show back button after hiding it
  • Upload multiple images in one request
  • Parse HTML in objective C
  • How to put buttons over UITableView which won't scroll with table in iOS
  • How to jump to system setting's location service on iOS10?
  • But of course there is no such path on an iPhone.

    I think I should define the path as “application root/test.db” but I don’t know how, or if that would even work anywhere else besides my development machine.

    Thanks for any ideas.

    3 Solutions Collect From Internet About “How should I specify the path for an sqlite db in an iPhone project?”

    To get the path of the file you’ve added in XCode you would use pathForResource:ofType: with your mainBundle.

    NSString *path = [[NSBundle mainBundle] pathForResource:@"yourDb" ofType:@"sqlite"];
    

    But you can’t change files in the mainBundle. So you have to copy it to another location. For example to the library of your app.

    You could do it like this:

    NSString *libraryPath = [NSSearchPathForDirectoriesInDomains(NSLibraryDirectory, NSUserDomainMask, YES) lastObject];
    NSString *targetPath = [libraryPath stringByAppendingPathComponent:@"yourDB.sqlite"];
    
    if (![[NSFileManager defaultManager] fileExistsAtPath:targetPath]) {
        // database doesn't exist in your library path... copy it from the bundle
        NSString *sourcePath = [[NSBundle mainBundle] pathForResource:@"yourDb" ofType:@"sqlite"];
        NSError *error = nil;
    
        if (![[NSFileManager defaultManager] copyItemAtPath:sourcePath toPath:targetPath error:&error]) {
            NSLog(@"Error: %@", error);
        }
    }
    

    Getting Paths to Standard Application Directories

    Don’t just use the SQLite API, use this amazing wrapper called FMDB: https://github.com/ccgus/fmdb