On 2/23/07, Stef Mientki <[EMAIL PROTECTED]> wrote:
hello, I've started with SQLite, because it's one of the first dbases with a local filessytem without authenciation. It looks great, compared to ini-files. Now I've a basic problem: I've a table, with 10 simple fields and 1 blob field, containing a (possibly large) image. Uptill now the dbase is small so no performance problems yet. But what if it grows ?
I use sqlite in the pixaddix suite. In one installation I have about 250,000 images. I store the images as paths and put them in the file system. The performance is still quite good. File systems are designed to handle files, and databases are designed to do queries, so that design decision seemed pretty trivial. I have written code to find duplicates and do store some binary data from the images in the database, but not the entire image. You can play with it if you like by going to the address in the signature line of my message. -- -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com