CODEWITHSUNDEEP
objective-cmacossqlitecore-dataosx-mavericks
MiMo
MiMo

Reputation: 4975

Mac Application using SQLite database has three databases created in 10.9 Mavericks

I have a Mac application that is using sqlite as it's database. On OSX 10.7 and 10.8 when the application is launched it creates one file as it's database storage: appName.sqlite

After upgrading to 10.9 Mavericks I noticed that when I launch my application, it now creates three files.

I am assuming they are some kind of temporary files, but I cannot open any of them. As far as I understand with 10.9 Mavericks, SQLite has been updated, I'm wondering if this behavior is related.

Any insight would be extremely helpful.

Thank you

Upvotes: 2

Views: 891

Answers (1)

MiMo
MiMo

Reputation: 4975

Duncan's response has put me in the right direction, I have done some more research and it turns out that the answer was right in the release notes...

https://developer.apple.com/library/mac/releasenotes/DataManagement/WhatsNew_CoreData_OSX/

Mavericks came with the following change to the default SQLite behavior which resulted in my issue...

"The Core Data SQLite persistent store will default to using WAL journal_mode on all applications linked on or after 10.9. This mode offers better reliability and performance than the classic SQLite rollback (delete) journaling. WAL journal_mode is not, however, recommended for read-only database files, or for files that need to interoperate with OS X v10.6 or earlier."

Upvotes: 2

Related Questions