Seems like new sqlite based applications will have a lot of troubles to be accepted in the Mac App Store thanks to strictly sandbox policies. The main issue is that sqlite uses temporary files (next to the database file) to store wal, shm or journal information.
Apple simply does not grant read/write privileges on non user specifically selected files… so there is no way for sqlite to create temporary information. A solution could be to just set journal_mode to MEMORY but database got corrupted in case of crash or power off and does not seem a very good solution. Another solution could be to have the ability to specify a directory for all these files… but there could be a lot of side effect. Please note that I also tried to set the com.apple.security.temporary-exception.files.home-relative-path.read-write to all user's home folder but Apple rejects all these settings. Anyone have another solution? Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
