Noticed the strangest behavior today.
After I changed the bundle identifier in my XCode project, the sqlite database no longer had the tables I'd created before. Changing the bundle identifier back made the tables accessible again. Even from the command line interface they had disappeared.
The way to resolve it was to re-enter the data :\
Not sure why this happened or how it could be easier to migrate the data over yet. I need to investigate this more.