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:

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

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

[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.