Fri, Aug 2, 2013
Many applications use Core data for iOS devices, others utilize frameworks like fmdb. But there are also people that write SQLite access from scratch. The comes the answer - how do you cache prepared statements (I will not discuss here why we cache prepared statements)? Well - I have implemented 2 methods: 1) Using C syntax to maintain array of sqlite_stmt* 2) Using NSPointerArray* to store sqlite_stmt* that are prepared First approach has it’s advantages in regards of using older SDKs (NSPointerArray is available from iOS 6.