Reading and writing images to an SQLite DB for iPhone use

by

You’ll need to convert the UIImage hosted within your UIImageView into a binary BLOB for storage in SQLite. To do that, you can use the following:

NSData *dataForImage = UIImagePNGRepresentation(cachedImage);
sqlite3_bind_blob(yourSavingSQLStatement, 2, [dataForImage bytes], [dataForImage length], SQLITE_TRANSIENT);

This will generate a PNG representation of your image, store it in an NSData instance, and then bind the bytes from the NSData as a BLOB for the second argument in your SQL query. Use UIImageJPEGRepresentation in the above to store in that format, if you like. You will need to have a BLOB column added to the appropriate table in your SQLite database.

To retrieve this image, you can use the following:

NSData *dataForCachedImage = [[NSData alloc] initWithBytes:sqlite3_column_blob(yourLoadingSQLStatement, 2) length: sqlite3_column_bytes(yourLoadingSQLStatement, 2)];       
self.cachedImage = [UIImage imageWithData:dataForCachedImage];
[dataForCachedImage release];

More Related Contents:

  1. convert UIImage to NSData
  2. File write with [NSBundle mainBundle] fails
  3. How to write iOS app purely in C
  4. Synthesized property and variable with underscore prefix: what does this mean? [duplicate]
  5. UIImage resizing not working properly
  6. Cocoa error 3840 using JSON (iOS)
  7. Phone number formatting on iOS
  8. Animating an image view to slide upwards
  9. Supporting Open In… menu item in my app for iOS Mail And Safari
  10. Xcode doesn’t show the line that causes a crash
  11. Allowing interaction with a UIView under another UIView
  12. Super slow lag/delay on initial keyboard animation of UITextField
  13. What does @synchronized() do as a singleton method in objective C?
  14. CoreData relationship fault?
  15. Show screen on first launch only in iOS
  16. How can I create a zip file by using Objective C?
  17. resizing a UIImage without loading it entirely into memory?
  18. RootViewController Switch Transition Animation
  19. UIWebView iOS5 changing user-agent
  20. Simple http post example in Objective-C?
  21. iOS: How do I know if a property is KVO-compliant?
  22. Custom nav bar styling – iOS [duplicate]
  23. RestKit: How does one post an array of objects?
  24. Is it possible to detect that your iOS app is running on an iPad mini at runtime?
  25. UITextField subview of UITableViewCell, get indexPath of cell
  26. Use Data From Class Without A New Init
  27. iPhone – Differences among time zone convenience methods
  28. iOS: Compare two NSDate-s without time portion
  29. WaveForm on IOS
  30. Detecting if UIView is intersecting other UIViews

Leave a Comment