Databases
StackOverflow2013
Postsdbo
POInserting image in to Database using sqlite in xcode4.6
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInserting image in to Database using sqlite in xcode4.6
    primarykey
    data
    text
    <p>im Working on inserting <em>IMAGE in to Database</em> using sqlite in Xcode 4.6 ,i just wanted to insert a <strong>textfield</strong> and <strong>uiimageview</strong>(having dynamically generated barcode image).</p> <p>unfortunately im getting <strong><em>" Error is: out of memory "</em></strong></p> <p>hear is the code I'm using ,plz let me know where my mistake is &amp; Let me know for more details</p> <p><strong>* 1. Database creation*</strong></p> <pre><code>-(void)createoropendb { NSArray *path =NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); NSString *docpath =[path objectAtIndex:0]; dbpathstring =[docpath stringByAppendingPathComponent:@"DataBase.db"]; char *error; NSFileManager *filemanager =[NSFileManager defaultManager]; if (![filemanager fileExistsAtPath:dbpathstring]) { const char *dbpath =[dbpathstring UTF8String]; if (sqlite3_open(dbpath, &amp;barcodeDB) == SQLITE_OK) { const char *sql_start ="CREATE TABLE IF NOT EXISTS DBTABLE1(NAME TEXT UNIQUE,IMAGEURL BLOB)"; NSLog(@"db created"); sqlite3_exec(barcodeDB, sql_start,NULL,NULL, &amp;error); sqlite3_close(barcodeDB); } } } </code></pre> <p><strong>* 2.button to insert data*</strong></p> <pre><code>- (IBAction)savedata:(id)sender { UIImage *image =imageView.image; NSData *imageData=UIImagePNGRepresentation(image); [self SaveImagesToSql: imageData.bytes:Uimagetext.text]; } </code></pre> <p><strong>* 3.method to insert data*</strong></p> <pre><code>- (void) SaveImagesToSql: (NSData*) imgData :(NSString*) mainUrl { const char* sqliteQuery = "INSERT INTO DBTABLE1(NAME,IMAGEURL) VALUES (?, ?)"; sqlite3_stmt* statement; if( sqlite3_prepare_v2(barcodeDB, sqliteQuery, -1, &amp;statement, NULL) == SQLITE_OK ) { sqlite3_bind_text(statement, 1,[mainUrl UTF8String], -1, SQLITE_TRANSIENT); sqlite3_bind_blob(statement, 2,[imgData bytes],[imgData length], SQLITE_TRANSIENT); sqlite3_step(statement); NSLog( @"Saved image successfully" ); } else { NSLog( @"SaveBody: Failed from sqlite3_prepare_v2. Error is: %s",sqlite3_errmsg(barcodeDB) ); } // Finalize and close database. sqlite3_finalize(statement); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USrmaddy
    1. USSamurai Warrior
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInserting image in to Database using sqlite in xcode4.6
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POInserting image in to Database using sqlite in xcode4.6
      1. USandroidgeek
      1. VTFavorite
    3. VO
      singulars
      1. POInserting image in to Database using sqlite in xcode4.6
      1. This table or related slice is empty.
      1. VTUpMod
    1. COBy the way, while I hope I answered your question below, but two unrelated observations: 1. I should point out that storing images in the database doesn't always work very well. If you're dealing with large images, you'll often get much better performance storing the image in the `Documents` folder of the file system, and only saving the filename in the database. If you're dealing with thumbnails, the difference is modest, but with large images, the performance hit is observable.
      singulars
      1. POInserting image in to Database using sqlite in xcode4.6
      1. USRob
    2. CO2. I don't know where you're getting the images (from the network?) but retrieving the images via `UIImagePNGRepresentation` is not guaranteed to get you the same file as you originally retrieved when you got the image. You might want to save the image as you're updating the `UIImageView`, not retrieving the `UIImage` later and converting it back to a `NSData` with `UIImagePNGRepresentation`. PNG is less problematic than JPG, but it's still not perfect. Save the original data and bypass the round-trip to the `UIImage` property if you can.
      singulars
      1. POInserting image in to Database using sqlite in xcode4.6
      1. USRob
    3. CO3. You should also check the results of `sqlite3_step` (in case the insert failed). Probably `sqlite3_bind_...` statements, too, though I've never had them fail on me.
      singulars
      1. POInserting image in to Database using sqlite in xcode4.6
      1. USRob
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload