[sqlite] Using SQLite for storing photo's

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

[sqlite] Using SQLite for storing photo's

On 2016/04/14 10:18 PM, Cecil Westerhof wrote: > 2016-04-14 22:07 GMT+02:00 Clemens Ladisch : > >> Cecil Westerhof wrote: >>> what is the best way to make a backup? >> With the backup API: . >> (Also available as .backup in the shell.) >> > ?I should be more

[sqlite] Using SQLite for storing photo's

2016-04-14 22:07 GMT+02:00 Clemens Ladisch : > Cecil Westerhof wrote: > > what is the best way to make a backup? > > With the backup API: . > (Also available as .backup in the shell.) > ?I should be more precise in my communication. :'-( I prefer to make my

[sqlite] Using SQLite for storing photo's

2016-04-14 21:37 GMT+02:00 Simon Slavin : > > On 14 Apr 2016, at 8:10pm, Cecil Westerhof wrote: > > > ?I would like to have everything in one file. > > From previous discussions on this list, what you want to do will work > fine. Of course you should make sure your operating system is able to

[sqlite] Using SQLite for storing photo's

Hello Cecil, I have multiple 30-40 GB Sqlite DB's which contain images as blobs. I back them up by copying them to my backup drive. Unless your application runs 24x7, I see no reason to do anything complicated with the backup. My image blobs are in a table which contains an

[sqlite] Using SQLite for storing photo's

Cecil Westerhof wrote: > what is the best way to make a backup? With the backup API: . (Also available as .backup in the shell.) Regards, Clemens

[sqlite] Using SQLite for storing photo's

2016-04-14 19:41 GMT+02:00 Simon Slavin : > > On 14 Apr 2016, at 6:37pm, Cecil Westerhof wrote: > > > I am thinking about storing my photo's in SQLite. > > Doesn't answer your question, but you should definitely read > > > ?I would like to have

[sqlite] Using SQLite for storing photo's

On 14 Apr 2016, at 8:10pm, Cecil Westerhof wrote: > ?I would like to have everything in one file.

[sqlite] Using SQLite for storing photo's

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

[sqlite] Using SQLite for storing photo's

On 14 Apr 2016, at 6:37pm, Cecil Westerhof wrote: > I am thinking about storing my photo's in SQLite. Doesn't answer your question, but you should definitely read Simon.