I would definitely store the pictures in separate files. The main reason is compatibility. If you store them as blobs in sqlite, you have to extract them first to view or edit them in a another program.i Are you sure you've covered all your use cases with your program?
Ketil On 14 Apr 2016 7:37 p.m., "Cecil Westerhof" <cldwesterhof at gmail.com> wrote: > I am thinking about storing my photo's in SQLite. This has to be done in a > blob of-course, but I was wondering if there are any caveats, or if anyone > has helpful tips. > > One thing I was wondering: what is the best way to make a backup? I would > think a normal dump is not very handy. It would probably better to store > the pictures them-self in one file pro picture and only store the > (meta-)data in SQL. What would be a good way? > > -- > Cecil Westerhof > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
