Re: [sqlite] store image file as blob

2013-10-30 Thread Richard Hipp 
On Wed, Oct 30, 2013 at 9:10 AM, Teg  wrote:

>  I do keep the
> blobs in one table and meta-data in another.
>

Good point, and worth repeating.

If you store large BLOBs in your database, performance will be much better
if you keep them in a separate table something like this:

CREATE TABLE bigThings(id INTEGER PRIMARY KEY, stuff BLOB);

Then store all of your metadata in separate tables and reference the big
BLOBs using the short integer ID.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] store image file as blob

2013-10-30 Thread Teg 
Hello d,

I prefer them in the DB so, I can move them as a package. I have 30-40
GB  DB's filled with image files. Performance is decent. I do keep the
blobs in one table and meta-data in another.

C

Wednesday, October 30, 2013, 7:30:58 AM, you wrote:

db> Hi,

db>  My sqlite database module has to store images (max. 100 KB) on client
db> machine.

db>  1. store images on file system and have reference in database
db>  2. store image as blob in database.

db>  Which is the best way to store these images?

db>  Any suggestions are welcome.

db> Best Regards,
db> va.
db> ___
db> sqlite-users mailing list
db> sqlite-users@sqlite.org
db> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards,
 Tegmailto:t...@djii.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] store image file as blob

2013-10-30 Thread Richard Hipp 
On Wed, Oct 30, 2013 at 7:30 AM, d b  wrote:

> Hi,
>
>  My sqlite database module has to store images (max. 100 KB) on client
> machine.
>
>  1. store images on file system and have reference in database
>  2. store image as blob in database.
>
>  Which is the best way to store these images?
>

BLOBs in the database.  http://www.sqlite.org/intern-v-extern-blob.html



>
>  Any suggestions are welcome.
>
> Best Regards,
> va.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] store image file as blob

2013-10-30 Thread d b 
Hi,

 My sqlite database module has to store images (max. 100 KB) on client
machine.

 1. store images on file system and have reference in database
 2. store image as blob in database.

 Which is the best way to store these images?

 Any suggestions are welcome.

Best Regards,
va.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users