This thread in the SQLite forum should be instructive: https://sqlite.org/forum/forumpost/90d6805c7cec827f