aditya siram <aditya.si...@...> writes: > > Hi all, > How do I insert an image file into sqlite table? Can I just use a > path-specifier? For instance, > create table ("name" varchar, "data" blob); > insert into table ("someBlob", "./blob.jpg"); > > thanks, > deech
But obviously holding the image within the DB means your DB file gets bigger, reducing the effectiveness of memory caching. You could have INSERT and DELETE triggers (and maybe an extra table) to manage the image files, and just store the image filenames in the DB. But you knew that ! MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users