The SQLite backup you create will not include any text messages sent or received after it was created. Any such messages will be permanently lost from the iPhone if the SQLite backup file is ...

XnView uses an SQLite database for storing this info and accessing it; Windows uses a flat file for the image metadata and another for the actual image thumbnails.

I've got it in a sub-folder, and the data source has a hard-coded path to the db file. How can I make it relative? For a WebApp, I'd rely on Server.MapPath, but how to do something similar here?

SQLite provides the sqlite3_open function to create or open a database file, returning a connection handle on success. The trick is that even if it fails to establish a valid connection, a connection ...

SQLite is, however, quite handy for creating a temporary database in memory. In such cases you might not want to deal with a physical file on disk. That in itself can add a lot of complexity: First ...