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
