Rather than doing malloc you can mmap the file and then copy it into the blob.
Peter A. Friend wrote: > On Feb 27, 2008, at 4:48 PM, Mike McGonagle wrote: > >> Hello all, >> I was hoping that someone might share some tips on working with >> Blobs? I >> would like to be able to store some images and sound files in a >> database, >> but never having dealt with them, I am kind of at a loss for some >> examples. >> I have looked on the web, and there are few examples that were of use. > > Well, I wrote a quick and dirty program for stuffing image files into > a database. You just provide a directory and it stats() each file, > allocates enough space for the image data, then loads it from disk. > Sql statement is something like: > > char* sql = "insert into i (name, data) values (?, ?);"; > > Of course if your images are huge this method coud be problematic. I > believe SQLite supports an incremental way to do this but I haven't > looked at those calls yet. > > while ( (dentry = readdir(dir)) != '\0') { > if (dentry->d_name[0] == '.') > continue; > > if (fd != -1) { > close(fd); > fd = -1; > } > > if (data != '\0') { > free(data); > data = '\0'; > } > > snprintf(fname, sizeof(fname), "%s/%s", newdir, dentry->d_name); > stat(fname, &sb); > > if ( (data = malloc(sb.st_size)) == '\0') { > fprintf(stderr, "malloc() failed\n"); > sqlite3_finalize(stmt); > sqlite3_close(db); > exit(1); > } > > if ( (fd = open(fname, O_RDONLY, 0000)) == -1) { > fprintf(stderr, "open() failed\n"); > sqlite3_finalize(stmt); > sqlite3_close(db); > exit(1); > } > > if ( (retval = read(fd, data, sb.st_size)) == -1) { > fprintf(stderr, "read() failed\n"); > sqlite3_finalize(stmt); > sqlite3_close(db); > exit(1); > } > > if (retval != sb.st_size) { > fprintf(stderr, "read() failed\n"); > sqlite3_finalize(stmt); > sqlite3_close(db); > exit(1); > } > > rc = sqlite3_bind_text(stmt, 1, dentry->d_name, dentry->d_namlen, > SQLITE_STATIC); > > if (rc != SQLITE_OK) { > fprintf(stderr, "sqlite3_bind_text() %s\n", sqlite3_errmsg > (db)); > sqlite3_finalize(stmt); > sqlite3_close(db); > exit(1); > } > > rc = sqlite3_bind_blob(stmt, 2, data, sb.st_size, SQLITE_STATIC); > > if (rc != SQLITE_OK) { > fprintf(stderr, "sqlite3_bind_blob() %s\n", sqlite3_errmsg > (db)); > sqlite3_finalize(stmt); > sqlite3_close(db); > exit(1); > } > > rc = sqlite3_step(stmt); > > if (rc != SQLITE_DONE) { > fprintf(stderr, "sqlite3_step() %s\n", sqlite3_errmsg(db)); > sqlite3_finalize(stmt); > sqlite3_close(db); > exit(1); > } > > sqlite3_reset(stmt); > } > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users