I have pretty much straight forward test project, that works fine on Windows. I took the project and I "moved" it to the Mac on Xcode. There is something I don't understand:

- if I give to the constructor method anything else than only filename as connection string, t.i. fill name with path, constructor method is unsuccessful. i.e. "test.db" works and "Macintosh HD/Users/TheUser/test.db" doesn't...- although test application executer normally and returns no errors of whatsoever, the file test.db is never created...

That is strange. I have been testing the SQLite interface on my Mac through a unit test suite, and then verifying the database through the sqlite3 command line shell. My code is more or less similar to the following: