[sqlite] Storing Images in Blobs - Best Practices

I've wanted to use SQLite Blobs for storing images for some time, and a new update to an iOS app gave me the opportunity - our Corporate Directory mobile app. I had considered it a few years before but after reading some posts that suggested a better way was to store links in SQLite and the imag

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

Ok, Kyle McKay responded directly offline with the solution. On my call: NSData *picData; sqlite3_bind_blob(preparedStatement, empProfPicDataPos, [picData bytes], picBytes, SQLITE_TRANSIENT); I had originally used picData, not [picData bytes]. And therein lies the fact that given I rarely u

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

The process, working in iOS: * Retrieve an employee photo using web service call, encoded in Base64 string * Convert Base64 string to NSData object - 3245 bytes * Store NSData object to a Blob in SQLite - 3245 bytes * Retrieve Blob to NSData object - 3245 bytes

Re: [sqlite] iOS Mem Alloc Issue - sqlite3_extended_errcode

ssion of SQLite Database Subject: Re: [sqlite] iOS Mem Alloc Issue - sqlite3_extended_errcode On Mon, May 9, 2011 at 3:19 PM, Rooney, Joe wrote: > I've used SQLite for some time in iOS apps, but now I'm doing an iPad > Corporate Directory app, and running into serious memory issues

[sqlite] iOS Mem Alloc Issue - sqlite3_extended_errcode

I've used SQLite for some time in iOS apps, but now I'm doing an iPad Corporate Directory app, and running into serious memory issues. Using Instruments, I'm finding fully 50% of my live memory is Malloc 52 KB, entirely allocated to libsqlite3.dylib, and specifically to sqlite3_extended_errcode.